潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭( t* D4 }0 [$ Y6 P
& | K8 _3 F J8 f3 }6 O Y
閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:" r) b9 }7 \5 i+ z$ d
! c! i. }9 ?( I, D
/etc/my.cnf9 P H! F, N# h2 I) J
/etc/mysql/my.cnf3 C9 I2 C. Y1 P+ O
& R9 @! i. ~" J& o5 K my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:! N* U/ |$ H3 Y8 P. G
slow_query_log = 1
( G6 c0 _! h, h6 |8 R$ u! f) e4 dslow_query_log_file = /var/log/mysql-slow.log
; |% Q% ~" H- ^. F0 slong_query_time = 2 9 o* k2 G5 \0 o- G( J
隞乩撟曇交:
* c3 m- j) l" X4 q7 M# c) s
8 H) L+ w) A4 |" A K5 Z1 h' z5 n' Hslow_query_log = 10 X7 R2 c$ F" h" A1 q5 b2 ?! M' e
蝝瑁Y SQL 隤:
7 d, K* H# p+ x8 ]7 p* S4 A; X7 }7 ~1 L# K! h1 z
slow_query_log_file = /var/log/mysql-slow.log
! o- U7 t: I: t. a: X* }5 L閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log$ Z, \/ u* q# g4 w% F3 D# ]
( ]7 T$ u6 ~! Dlong_query_time = 2
S. @9 _$ f# R6 E- e閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣7 C+ z/ @7 H! v K& b& c$ q
2 @' C0 z/ Q/ o靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭$ Y7 y4 K+ x. }
[/ @7 t F. P# V
( Q( G$ @# [: Z1 j' `, ^6 m
|
|