潸死蝔撘瑁敺, 嗡葉銝閬瑼Ｘ亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Ｙ SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭; S S& j0 I4 j: m+ l
" T) m u3 d: ^' n9 C5 v8 [' U+ G
閬蝝瑁Ｙ SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:9 \+ u, Q$ f: q
6 m) f6 E: D4 ^0 t: _" U; G/etc/my.cnf( o2 O+ w2 M: J7 y9 N y" T) ^
/etc/mysql/my.cnf
, I3 h' j" k) ]# q7 O
: v' n4 P- x0 o my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:4 k1 k$ C/ k- R/ T2 T
slow_query_log = 11 }- q% B I. |$ j7 S- g$ ]
slow_query_log_file = /var/log/mysql-slow.log/ n( o# D8 M" J3 ?1 K
long_query_time = 2
隞乩撟曇交:& B' w+ N- S( L) U; ^
) s( P% U5 c7 k; z6 O: J! Kslow_query_log = 1, d; H! t) j; G9 R, y2 H6 U! [* P
蝝瑁Ｙ SQL 隤:
! w$ O7 v5 O9 Q8 x& M9 E, n1 \
- j2 t2 B% p# L* ~. e3 }slow_query_log_file = /var/log/mysql-slow.log _0 s6 M( w% I6 s
閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log
' O) Q% L6 Q+ ?3 v3 n" |/ w9 [$ U
long_query_time = 26 M; n6 r1 n2 g1 ~4 f0 K9 ~
閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣: }' I, a# c, k$ ]. { H
2 ]- ^5 j0 k2 }* X( P靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭7 H h- x0 @/ u1 w. P# r
9 R- a7 N4 g/ ?6 `$ Y3 `
4 Z( Z0 y: s2 I, Z& ~9 v |
|
潸” 2019-1-6 16:41:37
嗉
鈭
霈
