|
|
楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:04/ k5 s, _1 U5 `
需要关闭 /usr/local/mysql/my.cnf 里面的 static table
/ m: e' p4 D' d3 [1 W9 _sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
7 g! X n* w3 [/ B, c& E" V5 }+ D0 l) L# For advice on how to change settings please see
L) f8 d7 `% m G/ v# H3 r7 O5 Q+ m# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
( j2 J% b2 Y, l% k9 J- d
; j4 u+ O6 b" ?* _# `0 ][mysqld]
7 A1 P2 d$ _5 I# x
$ I/ G. |0 e7 j# Remove leading # and set to the amount of RAM for the most important data
" u! @* T) ^9 |* l5 O1 w# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.7 L9 p8 X, v/ Q* r
# innodb_buffer_pool_size = 128M& t* H3 y" T1 O# I% R
& p" R6 ~. T! S, a! ~0 a
# Remove leading # to turn on a very important data integrity option: logging$ r, Y% B/ R* y d, V3 c2 }
# changes to the binary log between backups.
3 t5 k% C$ t: v5 v( C# log_bin% |" \" g1 e* ~* Z; E
0 u( E( A! W) i6 D% q8 f. U; U# g
# These are commonly set, remove the # and set as required.
& ]3 x. J- N' [2 J& Y M5 P# basedir = .....
3 K7 D" s% S: X& F# datadir = .....
j% j( ~! f+ J8 u9 O7 O' e, H# port = .....! D. z% ~7 T) g0 p0 P! G, Z
# server_id = .....
K P% h* j& A5 s3 @# socket = .....
* F l, l8 w6 K8 ?( c, u W% a7 y
$ J/ g- a. T* E/ o# Remove leading # to set options mainly useful for reporting servers.
( \) b7 y0 Y7 u; l& o9 _3 l) T, c# The server defaults are faster for transactions and fast SELECTs.
1 E, ^; n/ @2 \( s# Adjust sizes as needed, experiment to find the optimal values.
4 T9 Y3 P& J* ^) @4 S2 s# join_buffer_size = 128M
I+ O) a1 s: Z# sort_buffer_size = 2M% u4 L0 j! Y) N4 x5 [8 P" G
# read_rnd_buffer_size = 2M 7 d% c9 J0 a k9 \
- R+ W8 s/ P' {% n$ K" J
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
5 Y' U) }* m3 a7 |3 h 里面是这样的文件， 那个关闭啊？ 师兄 |
|
发表于 2015-7-15 10:22:00
发表于 2015-7-15 11:21:18
楼主
发表于 2015-7-17 20:39:12