隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
" t$ ]& X+ u+ M, q* o( O5 z5 [& `- u" P$ @1 I+ |
) L" N. H3 J- z. y
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
% Y4 |; L& t* p" {7 a
1 F& W" X+ W5 u7 I$ h% I/ D亥岷mysql函賊豢 p# b$ p6 t0 i$ A
>SHOW STATUS;
+ D% @1 M0 @7 q/ K% V5 g% T( G3 E" V7 H# L
亥岷mysql函賊蝵桅賊; T0 h$ b; t" p9 h6 c4 i/ [
>SHOW VARIABLES;
# X- `: ^6 R: t$ i) D) @ ]
4 N9 ~' ?; t( k, N' E: c渡亥岷蝺抵鋆∠蝣# y { C1 `% _+ I- v/ `* h$ D% _
>flush query cache;
- e/ X' {+ r, A/ U0 g, n( J9 V, r
芷斗亥岷蝺抵鋆∠批捆
, E. _/ k' e+ ] K>reset query cache;
. l* X2 o; g }1 ~/ v% g
5 R8 Z* @5 g9 Q! c4 {8 l閮剔蔭mysql
7 k4 ]. T% A9 W9 A* q9 v>SET GLOBAL;
! A, x7 J# o% ~7 W/ y- X% U- ]- M' H* J- K
亥岷mysql嗅瑁sql隤
' |! f! ^0 b3 Q# P# X>show processlist;
! I+ D0 Z6 K3 y# Z7 R) y, {& G
. q# t; P4 I0 M7 `2 U |
|