潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭
& u. v; w# d2 x- P
- r$ y- R4 x |: q閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:: `3 s- _7 d/ `7 o
* a& i; X, l/ x: Q% `
/etc/my.cnf
4 R9 D( p* L: W; M: E/etc/mysql/my.cnf
8 J8 |/ F- |! d" Y# V0 ]+ \: q
* z9 a! X3 h7 o' ] my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:
% M" }, ^+ M$ `slow_query_log = 1
) y, C5 {# j" f' l/ ^$ V, \: Dslow_query_log_file = /var/log/mysql-slow.log
1 c7 t# x1 A2 d; _* N3 h9 h4 U$ Mlong_query_time = 2
( h% D) @' l- ` t% X隞乩撟曇交:
x: W4 L6 B/ l0 U8 E9 ^7 Q4 v
slow_query_log = 1 h% s8 Y! H3 ]* k6 l# t
蝝瑁Y SQL 隤:
- t% j* V* z5 b" n# t, E! F, j+ z$ U I* Z
slow_query_log_file = /var/log/mysql-slow.log
! [3 [, U: e6 j4 R. ^; l閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log$ J, e# M6 j/ G* @8 B* b/ {9 X
w. y5 _( |) ~
long_query_time = 2
1 ], W" L6 _* l6 ]閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
0 y4 P5 |1 @6 G* u0 C7 P4 [
. T) g$ L" N! ?6 B$ L" {: m, K靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭
! Y% ^+ n# X7 N' D) z# |) J m! I/ h
3 `( G# Z/ t6 K
- W; |' L* y2 I3 D( S5 I7 G |
|