隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86) l! f$ ~3 ^, P
* ~% e, j" H- [( k
7 y; c- W- o1 t& y
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
) R1 E! g# q* f# U0 Q' {6 k+ { h) c' {- P& ]' t5 e$ ~% {
亥岷mysql函賊豢9 Y0 } |: h% i4 @. m
>SHOW STATUS;
7 _ `$ N3 y, l! E4 [( P% H5 o+ S( ]( ^; i' e+ w$ }
亥岷mysql函賊蝵桅賊
1 s$ j8 Z% a/ V, \9 E>SHOW VARIABLES;: V* z& I# C) d y0 H( I
6 a+ N* `- o" a: S: m2 }. ?/ |
渡亥岷蝺抵鋆∠蝣
$ Z8 j* ~2 S( B- m- X3 G: f>flush query cache;
% ?: p2 L+ R# ]1 j$ {% n+ d p; K1 S4 |2 e: g" `
芷斗亥岷蝺抵鋆∠批捆" J& @1 V4 u( H0 Z% l+ p
>reset query cache;
1 w5 Q% A* n, }: h* H, o* C: U1 V) X* |0 C4 n/ b3 ~! o: W4 P
閮剔蔭mysql
% z1 t( \1 k3 f; u9 D0 ^8 N* X' F>SET GLOBAL;( Y$ s) p; B' B! g. R* N5 d- B
: A# F7 `( X4 y
亥岷mysql嗅瑁sql隤3 ~/ i2 B, u" J9 G! M
>show processlist; 4 t! M! Z* t: \4 L2 r: d( X
% N& m- w3 i/ h; T/ h1 N2 l7 ]) m9 i |
|