隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86% s& H, H+ ?! R3 m) A r3 _/ X
* v/ T3 a" p7 s$ D# R+ q A0 W8 t2 D) k, }- ]. X
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
" x- d. b% e* P0 a4 [9 W, g+ [* z- R. G8 q( ]& L! R
亥岷mysql函賊豢2 E3 D9 N7 r$ d" C
>SHOW STATUS;2 }/ ^, i! T8 e! v5 N2 m; i: d# ]
& E6 g! S' p- {# W( y% F( a' V
亥岷mysql函賊蝵桅賊
- _. d1 ~; @# D* \7 ?1 N) q' O! e4 [>SHOW VARIABLES;
% [+ t$ ~1 G( ^' B2 V: ?' G8 s4 Z
5 X, D7 ]9 T. {4 j渡亥岷蝺抵鋆∠蝣" I1 ?* N1 }$ {4 @9 [5 o/ ~
>flush query cache;
1 x7 j" A! e- V! O5 K- O* ` a S( \
芷斗亥岷蝺抵鋆∠批捆6 [. b$ d- Y: `6 V, g
>reset query cache;6 e w \# b6 g4 `5 R! q1 r# V1 o
5 g$ B! f3 N- l. y閮剔蔭mysql
- `& ^, p3 i4 W0 {- w>SET GLOBAL;
2 x. u4 S3 w- Q$ @2 b/ G9 |* [; w% g
亥岷mysql嗅瑁sql隤
2 e2 ~9 T, G% m3 i5 E>show processlist; & U, F# A8 z6 N+ ?% |7 d
- ] A, C7 H+ |& x |
|