潸死蝔撘瑁敺, 嗡葉銝閬瑼Ｘ亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Ｙ SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭+ I& M; e* h, t2 s6 V4 o
1 i0 O( K# r; k/ P8 x/ V
閬蝝瑁Ｙ SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:7 k1 y0 D3 f; G. ]+ y/ v7 i+ M$ h4 v
5 u" e8 K/ c3 X3 U3 \0 k
/etc/my.cnf
( d. N/ k+ D; Z# [/etc/mysql/my.cnf& B" _5 ~7 F. i
9 L1 S& q" H$ ] W S# D3 r( { my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:
5 ]0 d5 \ ?# T8 r& F% ?# v- Kslow_query_log = 11 U& C; M: K) B7 d; \0 z
slow_query_log_file = /var/log/mysql-slow.log) j) ^" |$ y+ R$ ]* z9 U1 I; h
long_query_time = 2
" k- N+ X9 v9 ]9 c) B' _7 ~& b隞乩撟曇交:
& k4 F1 J' k Y
3 |- F9 e2 O6 R8 Q% C9 islow_query_log = 1" t% I7 ] T' o
蝝瑁Ｙ SQL 隤:
% M: p0 g- m. i D2 b/ ~
# h3 a! X3 r8 @slow_query_log_file = /var/log/mysql-slow.log
% Z' S# V; P: y" K閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log
1 i8 S/ ]0 h9 `6 h. d2 v! a3 n4 r' ^) T
long_query_time = 2
- ^7 }8 w" `0 r. x1 Z閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣. w( Q3 g2 k& i5 M
! W% o( l' ^" t d) p s- U6 o) D靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
q3 o7 G' {, b) t0 ~$ H4 v
) D% i, v- q; ?( w
8 v: s' W2 p K3 L: y4 ~3 c |
|
潸” 2019-1-6 16:41:37
嗉
鈭
霈
