隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%860 N* I( o! @5 l2 v' ^ j H
2 H; n5 ]( j+ d* J. x" m; E
( O* I* l% p8 v. e
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
8 I6 d5 i& ?: n6 ~
2 L e4 J* F0 z' c0 B亥岷mysql函賊豢
- x4 r. {( G% Y>SHOW STATUS;
' F, Z2 S' M+ W, o& K% ^+ A* [; I) M" X9 J$ r+ f" b
亥岷mysql函賊蝵桅賊# [6 `9 N. `& K- g9 u+ ~ w
>SHOW VARIABLES;
8 u6 ?3 @3 D% g# {: S3 ^$ ^4 A5 I; B1 v7 t& b3 o
渡亥岷蝺抵鋆∠蝣
* A5 U4 ?3 D3 f0 B' u; L- N E5 F>flush query cache;
/ `- n( V, K& F6 q
% _. f/ V: I& G1 B/ x8 b芷斗亥岷蝺抵鋆∠批捆
9 @; O7 s3 Y+ @4 K0 o" O1 m>reset query cache;4 n9 x$ f6 U. Y8 j' a! ^, H
2 t4 s% s5 v& h
閮剔蔭mysql$ X9 j/ I w6 n. o" m( H6 D% I9 q
>SET GLOBAL;
" R% _ M: f% r9 J8 ~& o* |' }2 m2 Y
0 X, E5 K$ p9 X/ ^+ N1 M7 O亥岷mysql嗅瑁sql隤
2 ], x! q& E+ E3 @9 Y>show processlist;
- C7 z/ t( O) p0 @/ ^# T1 l# ]% H
7 M1 f5 @6 ^* X2 p |
|
潸” 2015-11-6 12:01:02
嗉
鈭
霈
