潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭
) k8 `* B+ F! @' F, |4 {
; x; v- o. b* W/ Q5 H1 w閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:" y# I' j3 {( T; \* `9 Q' C7 p% ~- `
1 H# K' l G6 X7 F/etc/my.cnf
3 E# c5 I' ?0 H$ k6 |. Y6 Q/etc/mysql/my.cnf! `+ S' n2 H6 \: h8 R
% g! z. J# K, n my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:
( J' u+ F6 s, f+ [$ wslow_query_log = 1
, h7 m: Z5 |$ f% vslow_query_log_file = /var/log/mysql-slow.log8 {3 }. Z' g2 b4 m
long_query_time = 2
" E5 C! j5 t, A( b' }隞乩撟曇交:& g i E8 f% A9 w- B$ z
: k$ c0 u+ g, b' T& P- Pslow_query_log = 1
! o( D P0 V/ S$ z* [4 m/ i# l- \! q蝝瑁Y SQL 隤:8 l4 o& Y B4 J, ~8 P# s/ a" _+ z2 S
( Z$ t7 w5 B" _5 _' c
slow_query_log_file = /var/log/mysql-slow.log
# M6 @& s: ~. o; K$ s閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log! ]/ G8 J, Y) g
+ q5 ^: H- P5 t0 r8 q! k2 Q$ {* S- U
long_query_time = 2
9 f2 f0 D. q9 n Q4 z9 V' ^) P; Z閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣+ ?. W2 X' y o8 H$ r* I+ ?0 v
% ]( q, s, t/ U" Y6 ]; w! `! d* b
靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
) u/ X7 {+ F V; f' h% m
7 v; l0 o; S2 e
1 B" ?& y4 j( D3 N |
|