隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
, O+ z! y4 B# P6 a% ?- m& x7 _7 H* [# O8 L. O! n
6 C" W5 [& t2 Y; B
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
/ X; G5 U2 k/ _. Y# F% u6 Y
, ]0 V. @: j9 ?' B0 Y ?亥岷mysql函賊豢) `2 x+ z$ c% `% V h+ F4 @
>SHOW STATUS;
, x3 {- z' J% S) V9 z: C# n! n! t' L \6 ]# ?
亥岷mysql函賊蝵桅賊( W5 U1 W/ o8 a* O( i9 `! f
>SHOW VARIABLES;& f/ O8 P3 T c
! G9 O- D7 f0 L8 u, D* v
渡亥岷蝺抵鋆∠蝣
6 t5 l" y1 i1 q- b* c, i Y>flush query cache;
' v4 b" Q3 @& B+ N
5 f. z+ o9 A) R: N% O/ e& }# `芷斗亥岷蝺抵鋆∠批捆) N6 z |% u+ _( E" s3 X
>reset query cache;# ~! U, R4 K0 z( t$ E
" A# H1 }( `, y$ K! h( h3 @4 U% c
閮剔蔭mysql; `8 d9 C* g' x$ H; {- q f% C
>SET GLOBAL;5 J$ R" a% S1 d% b
- w, ~) _( A, N
亥岷mysql嗅瑁sql隤; T) H; l1 ~1 O4 E4 q& j5 O0 Y
>show processlist;
+ n, |7 `5 E- Q: n1 L
. g* @4 w. d$ O4 s, K) h5 h! k6 Y |
|