潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭, l" e7 F% }+ g+ J" i9 K W2 S# ^+ B# N
- [ Y0 S0 t( {$ E+ l7 m
閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:0 M) J; M5 h1 F, z
2 y% ~" ?% B3 l1 N+ Z1 P. ~. J/etc/my.cnf
. e: D: N+ y4 J5 h; s/etc/mysql/my.cnf2 i) L; {; V7 ^( b: L4 |" Y. ]
5 \# Z* {* b' O! t my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:# K( P3 N( T! d4 ?' w
slow_query_log = 19 ^5 \: |: z9 s- L4 D. K" y
slow_query_log_file = /var/log/mysql-slow.log/ f+ f2 y9 h" F2 Q9 y @7 y4 J$ m
long_query_time = 2 ( N4 z+ R% ~ i- N* M
隞乩撟曇交:& z- H+ @" E+ L5 E5 w5 Y, k
. |2 |; j' g+ U- `6 ]3 |slow_query_log = 1+ J0 H! N P* s# V$ k+ N
蝝瑁Y SQL 隤:
7 A; A' S: u! N3 L* H0 A( j2 `8 {2 I5 ?8 `' I2 B- L
slow_query_log_file = /var/log/mysql-slow.log3 L" F" w) ^1 t( [3 |6 k o! X
閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log
- |# {- Z7 B' h3 w/ D5 N) [5 V o6 z, A4 Z- {
long_query_time = 2$ n9 U6 M9 n8 O$ d# \
閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
. v( D7 E/ b; T/ l, z
; T/ m0 a/ n0 S# m/ Q- t5 C+ u' z* F靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
( B& i9 j$ s$ K9 g6 X2 h1 S3 L) k& d5 C# ^/ P# }) B$ S5 Z% V
" O: {$ A# Q3 g N7 i u
|
|