潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭$ Z% |. ?- v4 W" X
5 K1 N5 Z( ^" F4 Q! t& [/ h8 X
閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:
+ ]% ~" E7 R) s: T: t5 @7 [
+ |! h3 V9 y. {, X/etc/my.cnf
2 v3 z1 t# ~- q) J, @8 l/etc/mysql/my.cnf
$ a! O- [4 D0 V0 j# [, F8 ?: t5 O0 H& T V; H, t0 y
my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:/ z/ T6 e' l3 v1 n0 U% Q
slow_query_log = 1% |$ M5 m# _- J. X6 h( j
slow_query_log_file = /var/log/mysql-slow.log
4 p4 c- Y" @1 }' dlong_query_time = 2 9 {) r: `! ]& F% P
隞乩撟曇交:
- K N; [7 b! `2 \: E$ b4 X7 A* Q- L+ V/ G/ V
slow_query_log = 13 m6 d/ Y5 n' d3 U2 W: `4 J' `
蝝瑁Y SQL 隤:/ O& [7 g) e. c- J. Q; P+ o0 x
% @8 l& g) l8 \+ W: E% X/ F6 I- _& `3 p
slow_query_log_file = /var/log/mysql-slow.log
* M6 N) Y4 Q; W T8 ~5 {9 j( l, F閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log' v7 X* W$ s* [. ]9 y K+ _
% {( ?! }1 |+ tlong_query_time = 2
. H* G4 O( S' h1 [+ C" u* p7 J& z閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
- \8 c1 J: A4 ~* u( Y6 S3 X; W' c, ?( G
靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
0 @3 y3 B' x- Z" o! P5 R1 j P( D) C
* v# {" \5 D: M2 k1 S" e |
|