潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭
' \6 }7 l0 X+ K& h7 k% x3 Q& u p& ^! p* Q
閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:
* u* ]/ m- _1 z5 t) ]; v* ~* W/ A6 u% i% ~
/etc/my.cnf) K' M: v: H6 K: [
/etc/mysql/my.cnf. l5 V7 ]0 z* K$ _8 E
: B0 K* ^4 t9 i. u/ t my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:
. Q" R6 P! T$ \6 t' Hslow_query_log = 16 x8 N8 F0 T, ]
slow_query_log_file = /var/log/mysql-slow.log
# E% ^) k( g* @; D3 \2 W' V3 l5 wlong_query_time = 2 7 n* |+ ?% C1 ?, A1 ^4 D" {
隞乩撟曇交:
' c9 t" ~! }* b- M/ y2 n1 s* B- A& }* T6 B. M' c( J4 x+ f
slow_query_log = 1& }4 [/ I6 |3 l {* F, ^
蝝瑁Y SQL 隤:
N. m$ A; f; O" K' D. `( ^0 a4 \; N, ~0 e9 Q$ f" ?4 w# E
slow_query_log_file = /var/log/mysql-slow.log
2 h# }6 n3 h" S: n& h閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log
- M- I3 z7 U l
8 v) u: i$ l Slong_query_time = 2$ D9 k( e" a8 S! z" D: M' ?; z; j- x
閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
( o( Y* ^$ p p; B* m6 _# ]8 u
% E0 F) r! z. [! S, Q+ D: j靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
_; g7 P% }8 S, S& f- |+ y
. X3 C8 x" ]1 j ^7 A, h8 s: _
! Q! A" f) \- _* b' Q5 ~ |
|