|
|

楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:041 v7 o& p. V" n) J4 J
需要关闭 /usr/local/mysql/my.cnf 里面的 static table5 k% O3 E8 U' B q$ N6 I
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
/ q9 [4 K( f+ a0 y7 }, A+ s# For advice on how to change settings please see
2 h$ [+ N' D, `# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
8 e( A# ~: j9 K" q
0 j0 K1 H& K) b" h' B[mysqld]
( B/ \8 }- e! L' M7 I' o7 b0 ^7 ?. k, Z& G
# Remove leading # and set to the amount of RAM for the most important data7 o: ~4 s' c+ k0 {. @) t$ @
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
8 k; X" |# ?8 R$ d0 _1 E1 d! G+ W# innodb_buffer_pool_size = 128M* E. h3 R2 P" u
# C+ t4 j! b4 S v; A5 [0 _% @" W
# Remove leading # to turn on a very important data integrity option: logging6 J o+ n+ [- ~$ S$ Q
# changes to the binary log between backups.7 }1 M+ V! i6 Q+ ~
# log_bin
6 I3 C" j) G' b- j# [' j9 j& ^9 P- ?/ _1 k* u
# These are commonly set, remove the # and set as required.
. d9 N3 d5 V3 l3 y7 ?5 F# basedir = .....
8 @; c0 B! J2 S* b; R$ r# datadir = .....4 h* _* ~8 [- t% o& F
# port = .....
; ^7 i" x' O9 z# server_id = ..... |1 t7 S" P, M/ }, |" d$ f
# socket = ...../ ~& h; Y5 ~. \4 n- F
: o" r: x% I0 P+ V1 v# Remove leading # to set options mainly useful for reporting servers.
1 s6 @2 _! K: o, P; j' t( z1 t# The server defaults are faster for transactions and fast SELECTs.; f( r: K7 y) z
# Adjust sizes as needed, experiment to find the optimal values.
$ w& t7 v" a0 b& T' D# join_buffer_size = 128M' z0 f5 d# s0 N' q% ]: m
# sort_buffer_size = 2M0 [% v% O# R6 V1 ]
# read_rnd_buffer_size = 2M
2 a7 q- w7 Y7 b3 k& }, X/ V" V$ G( N i2 q) ?+ N) ^
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # }% \. K0 g# p: R5 k
里面是这样的文件, 那个关闭啊? 师兄 |
|