潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭8 U& _1 \" ~% p4 s# I7 d
! ^. Z/ v$ N4 I$ U. s& W9 D0 u閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:
' p8 u1 X1 }0 N" D) h
: Q7 m! i6 B# E# Q2 r( K/etc/my.cnf
* ~* ]1 c/ w' @/etc/mysql/my.cnf' b% J% }) n! w P7 O& D P
( M+ Q, n' i8 x+ X' @7 [/ V
my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:4 c& ~& {" C6 L6 A" I6 E& {+ @
slow_query_log = 1
! @3 d7 |! Y( N3 X* @+ sslow_query_log_file = /var/log/mysql-slow.log7 O* ?$ }4 C7 ?# o+ \
long_query_time = 2
# E/ u. g5 `/ Z6 o) u! s隞乩撟曇交:
6 A' \+ u6 D5 i2 N) F( ?) v
1 k( I) R$ q2 U+ D0 I) zslow_query_log = 1
; K7 p) M% @6 t2 g4 k蝝瑁Y SQL 隤:+ l. x a1 N/ Q/ z$ T
% w5 F7 y' ~# {% ^ U1 c; Q
slow_query_log_file = /var/log/mysql-slow.log
/ S; d' ~2 u+ Z; `" Y$ b閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log
1 q. N8 U( _0 o- S) ^, V; m
2 @- K6 T: N3 X i; |long_query_time = 2
, {0 v. P* @7 I Z閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
$ S+ u5 r+ h! x9 p9 b& S
7 h9 M/ ]* Y8 u3 [2 ^靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭; M( @# [1 m% \" Q( S
7 h2 U. _8 u: w1 [" G& a) C* J/ [
4 j9 |8 D9 N' r# L+ }+ T+ j
|
|