隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
: c2 c3 {1 Z& x: W; J1 y' V
7 U- O% \- z6 E; B* n3 I, Q0 T8 f. D( [2 f2 C% k9 F( q
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
% b0 I( D/ d2 y, m* W/ s$ Y7 Y1 P# v1 D3 x) h" g) i
亥岷mysql函賊豢
$ P5 O/ t8 P( P2 c F% n>SHOW STATUS;
6 ?4 `# n* L8 S* {2 h; l: f
" O: T0 z( z6 G; n亥岷mysql函賊蝵桅賊- L+ s) T2 w; ]8 f- r0 S
>SHOW VARIABLES;
, f0 A+ Z8 c0 ^3 d% D4 r! K6 O* }% _* F+ e4 n/ S
渡亥岷蝺抵鋆∠蝣
1 N7 e. [" e; e9 j3 ~>flush query cache;5 K) `0 |! N+ R. n# x, x
3 W2 M7 k H3 f
芷斗亥岷蝺抵鋆∠批捆+ Z. f+ W$ x9 F J$ B; l* b
>reset query cache;
( M/ m F2 F" g# Y u N' r' u1 l) Q- }" F
閮剔蔭mysql8 s# Y3 y+ [, j6 y8 @. b6 H
>SET GLOBAL;% w# j% ^/ M8 C* c9 u7 }
) z" V4 Q- x' F# ]亥岷mysql嗅瑁sql隤, F2 [) T( J8 d& k/ k
>show processlist; - x" ]7 u& N# ? D
2 R; A" I* b B/ W; x1 b |
|
潸” 2015-11-6 12:01:02
嗉
鈭
霈
