|
|
楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:04# n4 D+ b, @' D3 S: [ C$ `/ o/ W
需要关闭 /usr/local/mysql/my.cnf 里面的 static table
- V0 H; H( b& j+ {# D' R. u9 O4 ?sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
# For advice on how to change settings please see$ v" B3 \# i0 c
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html5 B% J/ b. y; k* z8 Z8 k4 ~
6 u' ]# E$ ~( X# L
[mysqld]/ O9 C- ?! {( [" K& _' c: O. ^
% N8 l' z; p6 q q- M2 X2 X3 t% `; X
# Remove leading # and set to the amount of RAM for the most important data
" U. i5 f8 Q R5 F/ [# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.6 |* r9 `+ \# \$ I* F* K4 q& w* S0 g
# innodb_buffer_pool_size = 128M
# {; k$ a+ @. G' H# p3 w( R/ ?- n! _: U& \4 S% e# {5 o- c
# Remove leading # to turn on a very important data integrity option: logging9 x8 @/ U w2 t6 Z
# changes to the binary log between backups.
1 {9 t- s; w. r! |, F9 `# log_bin
7 z% t; B' i" ^. }" W0 q/ C2 S# t- S2 F
# These are commonly set, remove the # and set as required.* E8 Z, S; g3 C4 A: t" s7 {
# basedir = .....
. ]+ q6 z3 K7 o# datadir = .....
! W& E- K J( `: Y: ?0 A# port = .....; C1 M7 @; X& ^6 x
# server_id = .....
) ?, t/ S' q1 e9 k& K) N% z. y# socket = .....
; E: @; D* B/ W4 k4 X l5 x
, `5 R* C( \: ~# Remove leading # to set options mainly useful for reporting servers.
% J0 G: T t2 |" S& s# The server defaults are faster for transactions and fast SELECTs.
. ~) Q! E8 P3 o8 Z# Adjust sizes as needed, experiment to find the optimal values.
! t6 |, V9 k; H8 L$ @# join_buffer_size = 128M1 O3 m4 j) S s/ a" j( ]/ W
# sort_buffer_size = 2M
5 Q1 q( X5 Y& A( ]: v, T# read_rnd_buffer_size = 2M 7 B- H# J6 A$ x+ [- [, P1 X
5 m8 W# R" M2 tsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES & x3 X+ c$ p1 j* A
里面是这样的文件， 那个关闭啊？ 师兄 |
|
发表于 2015-7-15 10:22:00
发表于 2015-7-15 11:21:18
发表于 2015-7-17 20:39:12