隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
0 w+ f; K3 B# ^3 b
# ]! u0 f3 H" N3 ?# @" L& }5 V; |% `) r+ o7 J
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
+ X2 L, b% f! \( y% F7 d3 k
4 `4 @ N! }& k0 L/ `' G亥岷mysql函賊豢1 L$ o. K& P7 b$ b1 S! c
>SHOW STATUS;
% _; h2 G; n. H; S
( r. A6 F$ g5 ?* A Q+ W! H/ _! s亥岷mysql函賊蝵桅賊) ^% l" {' N! t' ~7 \& N& ]
>SHOW VARIABLES;
" ]% Z6 \, t/ o# T# h6 S
6 Y* h1 ]4 ?5 h渡亥岷蝺抵鋆∠蝣; \, N+ w- m4 }( r# T
>flush query cache;2 @1 x) q2 ^. U# t T& ]+ ?$ o
' J n: Y7 t# o' u1 t; G# P
芷斗亥岷蝺抵鋆∠批捆
" S; q8 L0 I9 z- {; k4 o: P* N. b>reset query cache;
& W3 w* O, T4 a! O4 P1 k. [9 F3 P @, I4 h: r$ j' U$ Q
閮剔蔭mysql
9 @, \' J5 L: G. v3 V( r>SET GLOBAL;: }9 Z V$ l$ m V/ Z) D1 T
) a0 o$ P9 B' l2 M' J/ G5 w) [3 V" T1 O
亥岷mysql嗅瑁sql隤
' ?" h3 r; ~3 N3 i! B; M3 ?>show processlist;
1 G2 H4 Y( }0 M. P0 ?5 H( e9 d* q; p& \! J7 u
|
|