潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭
+ J: G- e& i" b1 R+ S7 i2 y$ o8 Z2 |8 S
閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:
& q6 A3 ?8 i5 ~7 x! N3 t- H
( |% E' V2 a w' m0 d/etc/my.cnf
, \. Q; _) F' r9 [/etc/mysql/my.cnf" v/ Z; Z4 Z) U3 {
" [9 B# v4 h5 t E* W
my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:# U9 \8 \. u9 c; S2 h e- U
slow_query_log = 1# |1 W- l# F( N3 t" _$ @/ ~
slow_query_log_file = /var/log/mysql-slow.log
& j0 m2 o M& Zlong_query_time = 2
2 x7 \. e J# H6 x6 Z) ?8 O隞乩撟曇交:
# i/ }* r# u5 k* d
$ J s% I0 \; K4 Q; ]: A/ K( Vslow_query_log = 1
% j' S3 Y' W9 G% t蝝瑁Y SQL 隤:( y2 [6 o3 x- g, j0 _
' l7 {, v- L# ]# a
slow_query_log_file = /var/log/mysql-slow.log
" X* K+ m# G6 _! B, T" E: H( D# [閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log
, f' p! f" Y9 Z7 S4 Q: M' {- b, m, u. a. J: p x7 E4 g, ^4 I
long_query_time = 2
. V# l% I/ x6 F N# M" |閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
0 R% M9 [. `0 }( R3 W; r7 L9 W! b s2 n6 _9 O
靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
: ~2 W6 J, N9 \) |8 {5 f [4 ~$ Y
3 U3 x- M2 D0 j5 I$ e+ D. S. @7 K3 ~
|
|