潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭
( N6 ^' U8 T" p6 S2 w4 `2 j9 z/ a ^
閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:
/ z& L- n7 `: S: H: E6 Y
3 \0 @+ m" Y X* A& i& z3 B5 } e' q8 e/etc/my.cnf% H3 l0 c: s4 j, {5 ?
/etc/mysql/my.cnf
5 Y# f/ }* u( [2 w' m% J" z! G! \
G- P) x) T) t% ^- r& W my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:
! E8 {4 G- M; ]" `slow_query_log = 18 S3 j. u) U9 m* X0 G4 |. b. l( e
slow_query_log_file = /var/log/mysql-slow.log
7 s! u- s( x) @1 clong_query_time = 2
^& c9 h1 G# I" j, [隞乩撟曇交:
( K' C6 }3 \2 ~0 y* }! N) \. t0 [9 i
slow_query_log = 1
0 E" s* p4 Q& I2 W蝝瑁Y SQL 隤:
4 M9 K. T* y: v, Z: ^0 c
$ i+ V# |$ \' Oslow_query_log_file = /var/log/mysql-slow.log
- R: t$ ~" h5 O1 T: i& D閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log1 G4 V; G7 v; B
2 c3 r; J2 J! n6 c2 qlong_query_time = 2& w. O6 e6 k8 ]% p- ^ I
閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣6 r1 h8 }0 M- ]' {5 Z { U
2 ~; p# L) v; x1 G5 @- g靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
5 ~2 n3 K$ E$ H" x
" x. F8 p. U. j S5 m a! E0 t7 P1 v9 _6 _1 D1 A2 M
|
|