|
|
楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:04/ o" C; \ V% h d
需要关闭 /usr/local/mysql/my.cnf 里面的 static table. N! ^; `$ h4 R# l* C6 ~2 _1 E& J3 E
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
4 R3 p! K$ |! y" `# For advice on how to change settings please see' e: V+ R$ P" ^+ o3 i3 ?: o
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
8 B$ d T: T% }% Q2 T4 D7 R0 r) E' }# M
[mysqld]
7 w; X1 L ?; X- M; i
; ^7 Y1 d" \$ r# X) u# A" ]4 u2 x# Remove leading # and set to the amount of RAM for the most important data
# e- P) w" t2 N! H5 W- i' t# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.! `- ]0 w8 K) u/ X
# innodb_buffer_pool_size = 128M9 S' R. e3 G) e5 V% e
; L# L, T, S5 A
# Remove leading # to turn on a very important data integrity option: logging) H9 }0 ]( K4 m4 a& R
# changes to the binary log between backups.2 ]8 p: o1 n& _/ O
# log_bin, q! u2 O7 p8 l1 o* @
' b6 e, C. h- B( N- Y% C, P' v# These are commonly set, remove the # and set as required.
4 ^/ z8 h$ H' o" X# basedir = .....
; L( {' s5 k. @; f% f# datadir = ..... c" ^5 T; B& q! z8 j
# port = .....9 g* P( Q5 M3 f0 |9 E! ]2 D0 ^
# server_id = .....
2 K% ]% B% u+ M# socket = .....
6 W* l) r- d& Z7 J- S% k$ m
2 f: A6 s9 f* y( D# Remove leading # to set options mainly useful for reporting servers.) R9 z3 u. U- E! L* a( U2 {7 h
# The server defaults are faster for transactions and fast SELECTs.
+ ~( E' V; ]1 ^4 e4 n5 y# Adjust sizes as needed, experiment to find the optimal values.
: Z9 Z2 s$ v# Q# join_buffer_size = 128M
a/ ~5 Q. h; c" x9 Y+ ?# sort_buffer_size = 2M
# f& Y& C; ~1 L2 z4 y+ L1 |# read_rnd_buffer_size = 2M ( D( A/ L$ {/ o. j
6 I9 P" ]* m3 I1 Q
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES R% p; N6 X2 n, l/ R' Y
里面是这样的文件， 那个关闭啊？ 师兄 |
|
发表于 2015-7-15 10:22:00
发表于 2015-7-15 11:21:18
楼主
发表于 2015-7-17 20:39:12