52AV璈A|52AV.ONE

 曉撖蝣
 蝡唾酉
敹急瑕
  • av隢憯BBS
  • 璈A
  • 芣瑟憭瘚
  • 鞎澆
  • 52av鋆貉摰
  • 銝剜-銝剖銝餅
  • 伐AI璁函移瘛怠伐
     
亦: 4683|敺: 0
銝銝銝駁 銝銝銝駁

[mysql] MySQL slow query log, 脣瑁Y SQL 隤

[銴鋆賡包
頝唾唳摰璅撅
璅銝
潸” 2019-1-6 16:41:37 | 芰閰脖 撣 |摨閬 |梯璅∪
潸死蝔撘瑁敺, 嗡葉銝閬瑼X亦唳寞航摨怒MySQL 臭誑撠瑁 SQL 隤亙券函銝靘, 臭誑芣臬瑁Y SQL 隤亦銝靘, 璅撠 MySQL 隤亦 Debug 撠梯擛敺憭鈭# j2 x* k0 u5 C  N& D

( i2 P# L2 o3 R' v5 a2 k) b* Q閬蝝瑁Y SQL 隤, 臭誑靽格 my.cnf 摰, my.cnf 憭詨其誑銝雿蝵:
1 G( z) m2 v  \5 n, L* F; L( Z/ T) @: v6 Z; a5 m
/etc/my.cnf
' y1 M2 I& w4 h' S- H) K1 [+ F/etc/mysql/my.cnf
, ^: S4 K$ _! `
. A5 ]# W2 L1 X: g my.cnf, [mysqld] 畾菔賢乩誑銝撟曇:
2 l1 c6 u7 O% T/ O6 J& F
slow_query_log = 1/ c% x4 _6 @$ d8 z. \* b+ v
slow_query_log_file = /var/log/mysql-slow.log' ?  N6 @6 i& s# L3 d0 F
long_query_time = 2
% \/ P0 |) B4 s" w, M
隞乩撟曇交:
7 k7 `6 w4 U& j5 U% v' {/ f* _. J( Q3 n: h% d
slow_query_log = 1
# d' k# g% U$ z8 ~6 p蝝瑁Y SQL 隤:
$ q( X7 x8 U" A+ T& u* g; w1 ]; }
* p' d9 G9 I/ L" `# f. u. i/ Y- wslow_query_log_file = /var/log/mysql-slow.log
, y9 x" |0 r: d) O$ J" C閮剖蝝瑼雿蝵桀 /var/log/mysql-slow.log
( E" Y& B/ L7 }4 ~( B: S) S6 `  n
4 p0 i0 h$ u" [) Vlong_query_time = 2
6 m3 z, i& ?! Z' U閮剖 SQL 隤亙瑁頞 2 蝘, 靘踵撠 SQL 隤亙脣
8 Y  j9 i+ v/ b+ i7 [4 b5 ?% i: g' u/ f& Q- O: i
靽格孵末 my.cnf 敺, 啣 MySQL 靘踹鈭( ~' v1 Y  N$ p( N" q& F+ I( S  k

! |, J$ F. C7 D3 H
) a- t7 d6 y% e8 u) g6 |) I

雿輻券

祉蝛閬

砍憛批捆靘餉衣雯頝臬批捆蝝颲行粹嗥蝬脩嚗摰撟湔遛嚗嚗甇脖誑銝嗅啣摰嗆摰撟湧翩鈭箏ㄚ孵舫脣伐銝憿亙祉璇甈橘芣遛18甇 雓蝯脣亦閬賬粹脩芣遛18甇脖芣撟渡雯閬賜雯頝臭嗥批捆鞈閮嚗撱箄降典舫脰蝬脰楝批捆蝝蝯蝜ICRA蝝摰鋆閮剖 (粹蝯行霅 祉蝬脣銝蝝瘛函隢憯啣嚗祉閮剜蝞∠)

QQ|撠暺撅||52AV璈A

GMT+8, 2026-1-30 18:24 , Processed in 0.073123 second(s), 15 queries .

蝯∠.撱

[email protected] | QQ:2405733034     since 2015-01

鋆貉憒 敹恍敺 餈銵