|
|
楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:04% J& x2 g: [& s9 o$ k! l+ o
需要关闭 /usr/local/mysql/my.cnf 里面的 static table3 W) j4 j" \( l9 S& S
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
# For advice on how to change settings please see
7 ~; ?: @( V" ^+ N, N/ k; i$ `3 g: W# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
4 D1 M3 @2 l3 }, f# E$ f( U, w8 J
7 U* D( O% u6 i' c[mysqld]& P( l9 ]: V" u3 V8 ]6 v
: ]. k6 T& w# _8 B( v# Remove leading # and set to the amount of RAM for the most important data8 n# u! r3 m) T. @% D d4 w
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.) P- w2 r7 A0 F1 G6 C
# innodb_buffer_pool_size = 128M
% G4 g# m, e( d: o
! }5 [ `$ ~+ h4 M# Remove leading # to turn on a very important data integrity option: logging
0 t. D7 C0 Z; M# changes to the binary log between backups.+ M0 @5 D4 [7 {# ]3 t! `+ L1 l
# log_bin
6 S& G# D0 a* g: m, P
, G8 n7 Q/ m3 H( E# These are commonly set, remove the # and set as required.
* u% p% J& U% Z1 i# basedir = .....
2 T! ~; p4 X; u3 M# datadir = .....! x9 V8 E+ ~" Q0 V: J
# port = .....: a# P7 f2 k4 P6 p' n' O9 U
# server_id = .....
' W9 e- L4 h8 B8 Z5 y( r8 M# socket = .....
# H9 \6 Z' ?- A7 {2 P! t5 V, s' X; p- q1 k% r
# Remove leading # to set options mainly useful for reporting servers.
) U0 U& w) w T% ?3 n1 P1 C: T# \# The server defaults are faster for transactions and fast SELECTs.
9 _! s7 i) T# A4 T# Adjust sizes as needed, experiment to find the optimal values.& Y' l8 ?: I( p
# join_buffer_size = 128M! u5 t0 ]0 l) \. l/ M- U; _' s, d
# sort_buffer_size = 2M
8 P5 a- m$ |2 O) l. \6 f% e0 u# read_rnd_buffer_size = 2M
" K, g2 F& V% w9 B
% G1 f0 Z. o; ~! a |! Hsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
6 z$ h$ _& P+ ]/ l 里面是这样的文件， 那个关闭啊？ 师兄 |
|
发表于 2015-7-15 10:22:00
发表于 2015-7-15 11:21:18
楼主
发表于 2015-7-17 20:39:12