潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭
( g) M3 q& ~9 b+ M
1 A" h- K, z, W( T閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:# j% m: _; O- Q
. Q/ j5 v! I9 x0 c/etc/my.cnf, o5 t- {$ |6 U. Z4 O
/etc/mysql/my.cnf
# ^ K- ^, e1 e% X! d1 v/ V1 {& m2 W/ ] |( Z. ]# x6 c4 ?6 [% d
my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:% C3 H$ ^. h/ ?- P$ O) g p$ W
slow_query_log = 1
1 G# E9 i4 c; Tslow_query_log_file = /var/log/mysql-slow.log
; @/ w3 `# i0 P) _" R A5 slong_query_time = 2
; J5 n. n$ d0 C1 O; |隞乩撟曇交:1 q- ~. k4 }- H: W# o
& q8 X* u7 _) g: q fslow_query_log = 1& m$ t% B7 k, `3 A
蝝瑁Y SQL 隤:, `" L% _. Y/ R! v# [; E$ ~
& h- |& M; j- E5 t% i
slow_query_log_file = /var/log/mysql-slow.log
) ?) ]- m! @. ~閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log' k, \6 T9 S: D6 F5 g8 |
' r& s" q# V0 \5 i' v
long_query_time = 2
) g# S6 Q: I% ?/ s閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
$ F: \% a& @6 F, o. ?+ i3 e" n% {+ m! {
靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭! ^8 ?1 J7 Q* i* {1 K
6 f( C* Y8 F$ C5 Z8 J( v0 i
* A# D, Z" m: f8 ]+ s' m- m* Y |
|