潸死蝔撘瑁敺, 嗡葉銝閬瑼Ｘ亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Ｙ SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭& s: b% B! y9 n6 J0 h& h
& ~; h: m5 w9 _4 O" J4 b4 f- g
閬蝝瑁Ｙ SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:
. H% f+ u0 m3 t4 H8 ?
" U. c7 G( q3 c! X: i/etc/my.cnf
* q1 Z. C, Y0 r* b3 |( S* X( x* r/etc/mysql/my.cnf
; N- _# ^! P+ D; V; O$ e; v$ L. G) U$ U$ B' a
my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:
- g( Q5 b! u- W8 w; D$ Qslow_query_log = 1
1 z; {& m9 \/ ^* \% f& Cslow_query_log_file = /var/log/mysql-slow.log8 E. `! U1 q+ w% |+ }$ Z8 z9 l/ ^. y
long_query_time = 2
5 J0 ~2 W/ @% S6 {4 Y) W隞乩撟曇交:# W1 e# |5 U9 ]0 F* m; [
+ L: X' d3 ]* t& r0 S/ z5 Vslow_query_log = 1; u h( {% \% N% b n2 D
蝝瑁Ｙ SQL 隤:
8 G: S4 z0 O2 N, g4 Z5 m" m1 Q& W. i% [; j) t% H* a5 w3 D& G
slow_query_log_file = /var/log/mysql-slow.log2 u4 C- Q+ _$ |
閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log1 b' b! z2 V9 c$ Q
0 s; D7 R- U6 U. W$ _" V; }long_query_time = 2) T& `3 j0 M& ~/ h
閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣! r2 d) d% i0 S
' N9 K" r! q( R0 m7 s4 V' D靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭 D3 Z7 I9 |) c" j5 S" X; ]
& S Y/ L+ m) W. `8 W! z1 D
; }3 A/ Y9 m# d) M+ N5 H, X |
|
潸” 2019-1-6 16:41:37
嗉
鈭
霈
