|
|
楼主 |
发表于 2015-7-15 22:52:38
|
显示全部楼层
malong101 发表于 2015-7-15 21:04
% R) X, ~/ D5 @( q8 `需要关闭 /usr/local/mysql/my.cnf 里面的 static table- p% G) J- W" [9 y+ L o
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITU ...
3 T4 ?+ J8 G0 `9 C; `# For advice on how to change settings please see
- R: r; y0 B& I0 Z# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html1 @5 \& S' L7 f1 A* K3 s$ [
$ ^% @2 q7 K" A$ }. ?; Q9 @: `6 Z% N" J1 P[mysqld]" E( J$ } Y$ `8 H$ P
7 ~4 B: e4 X+ c' w6 k' N
# Remove leading # and set to the amount of RAM for the most important data9 v8 W6 @, d3 R; Y4 B
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.- J5 d9 R1 H2 d' r) U! c6 q( S6 [
# innodb_buffer_pool_size = 128M
* R2 {* S, a4 v# C
8 p+ T& w) M/ A7 r; {# Remove leading # to turn on a very important data integrity option: logging' V% o- T" n8 l& Y& n
# changes to the binary log between backups.7 W& s4 a$ {/ I, M* F6 Q
# log_bin5 t/ x- R% C5 `5 Y5 |. N
; O" J0 R: N b0 f: z9 z4 }
# These are commonly set, remove the # and set as required.$ d6 q; \$ Y0 ~. T
# basedir = .....
7 L& D/ l/ ?7 G Y/ k# datadir = .....! g5 e c6 ^. |6 E; k6 t* ]
# port = .....7 B0 t$ v- p0 t5 |' G
# server_id = .....
0 b: _3 n% K" q. P( f# socket = .....9 D+ f# P) {% C
: ?) z \- D" A" M2 l# Remove leading # to set options mainly useful for reporting servers.
+ J' b- V3 ?2 F# c2 o8 T# The server defaults are faster for transactions and fast SELECTs.4 H+ ]& e9 N6 f" Y! z
# Adjust sizes as needed, experiment to find the optimal values.
9 `1 c6 `9 N. g8 X# join_buffer_size = 128M- Y6 }/ d9 O7 p2 g! B7 q4 {
# sort_buffer_size = 2M2 p7 J3 z2 F3 b$ b |0 f6 d
# read_rnd_buffer_size = 2M 9 T( j4 n0 r$ ^6 n3 V
+ h& V/ ?8 v6 ^7 V' s1 x! E
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 6 i9 ?1 c$ U7 Z1 K
里面是这样的文件， 那个关闭啊？ 师兄 |
|
发表于 2015-7-15 10:22:00
发表于 2015-7-15 11:21:18
楼主
发表于 2015-7-17 20:39:12