|
|
楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:04
; K% M# Q$ T# X/ @# G& j. Y需要关闭 /usr/local/mysql/my.cnf 里面的 static table
/ t( x1 A9 r/ D* c$ ^6 Rsql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
* W2 J& P# L0 s$ x+ Y# W# For advice on how to change settings please see. a* ^% z$ ]0 Y8 M* @6 q
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html9 x" H. _, r$ h
; D+ q# K ? z0 V' e% _. h
[mysqld]& B$ P3 h. R: Y( {. D' p
! v3 \' l; }& L$ g* b! z3 M" P- z
# Remove leading # and set to the amount of RAM for the most important data
% H# p" @$ V& \3 E' z+ `# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
) y% T# S2 X9 L7 j# innodb_buffer_pool_size = 128M
4 K+ E1 K* H2 M" ]& s
2 a z- X. U0 H0 s0 C* |" J: ^# Remove leading # to turn on a very important data integrity option: logging( q) f b- l- L. ^+ v
# changes to the binary log between backups.
' |" A1 z0 ~) p& X# log_bin
* W G8 o# @* C" X3 n9 ^4 [ Z5 z/ K/ M6 @9 `1 k
# These are commonly set, remove the # and set as required. ^1 d$ a. g0 O- Q T2 |$ P
# basedir = ....." N! a4 J1 w+ k3 j4 k) P3 D
# datadir = .....+ I/ L4 J9 t6 Z1 E
# port = .....! O3 w/ K6 X2 `* h
# server_id = .....( h9 ]4 T) d6 R* E% [; K# M
# socket = .....
& v, x# P3 ^. x0 Z$ K9 b3 E! a+ ` |. L: L1 n; E: S
# Remove leading # to set options mainly useful for reporting servers.0 _8 v4 }. ]; g
# The server defaults are faster for transactions and fast SELECTs.
2 e; @6 U7 L3 p* ?9 G) r# Adjust sizes as needed, experiment to find the optimal values." B- L" m) S* A" P3 R
# join_buffer_size = 128M5 [% _% Q- A2 q+ O! j7 S6 f
# sort_buffer_size = 2M/ h2 e4 l8 l, \8 u, G2 q( H
# read_rnd_buffer_size = 2M % A0 _& `/ {' E4 N0 O
# W, I2 Q1 D3 b# K; V7 P9 i6 Gsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # i0 J( O2 j8 f: }7 `! o, U7 Z
里面是这样的文件, 那个关闭啊? 师兄 |
|