|
|
楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:045 B' C7 o! I& p2 w# A0 H6 w/ _
需要关闭 /usr/local/mysql/my.cnf 里面的 static table
8 w& ]/ }" ?' `& _sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
# For advice on how to change settings please see
- W* S' k! i2 U% Q# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
4 b4 g5 Z+ t$ y( M+ M3 I1 N
! C0 c7 R6 C) J0 E; Y[mysqld]
* O/ F9 t' n' \$ V# {
# y' b2 W! y7 U; U# Remove leading # and set to the amount of RAM for the most important data8 L+ x% k/ X- a P1 _! o. e( i
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.- @( C# ] @" y
# innodb_buffer_pool_size = 128M q; c& o X2 x# c# {$ `
& E; J8 o+ F2 r# q( O
# Remove leading # to turn on a very important data integrity option: logging( _* B1 @" r4 y' Z5 ^
# changes to the binary log between backups.
! T- M" i/ r4 Y' E( C# log_bin
/ X0 b8 v6 D) T) U) b6 a0 U( e3 G x7 W& d, J
# These are commonly set, remove the # and set as required.
) D. c/ y" q. b" ?+ R; \# basedir = .....
7 H% y- e* _* D7 E# datadir = .....5 o: a4 @$ x7 w! M6 ^6 A
# port = .....9 i8 n; B8 a+ d+ [! o* L
# server_id = .....
7 y% M1 T: r7 K7 Z# socket = .....
* P6 e& w. C) \. @$ c/ x; S" a! a9 b, @' `
# Remove leading # to set options mainly useful for reporting servers.9 @( y" F, i/ A- F" }
# The server defaults are faster for transactions and fast SELECTs.
; k4 z7 x9 a% z0 W5 m, X1 K# Adjust sizes as needed, experiment to find the optimal values.5 B% z. k$ T, d; T$ I/ I0 Y
# join_buffer_size = 128M
! a' S0 Q- E/ q8 Q: J& Z# sort_buffer_size = 2M% p. a) X& e: }6 \4 Z8 ^
# read_rnd_buffer_size = 2M . ?% U4 |( V# t9 G, L& i) j
: G0 ?8 l! B. V! C- Gsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
& \$ \6 s9 P% o$ m* f 里面是这样的文件， 那个关闭啊？ 师兄 |
|
发表于 2015-7-15 10:22:00
发表于 2015-7-15 11:21:18
楼主
发表于 2015-7-17 20:39:12