隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
- ], t$ K8 d: e6 h/ R! d+ n- |( V
- U3 A! K4 }% Q8 z! t$ G2 M. m) d: T7 c0 V9 }
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345; }2 C1 { y/ J$ ?2 j
: K9 R3 r' U' k8 n& |: ^9 D$ B& c亥岷mysql函賊豢
c! u9 d3 ~2 Z( Z T+ t>SHOW STATUS;7 B6 {0 r8 p* B8 e( [9 r1 V. K( [+ ?
* r; H, D# D$ i* d: A4 F亥岷mysql函賊蝵桅賊; P& }# F) M3 c) g1 ^ o }6 Z; ^
>SHOW VARIABLES;+ }4 e3 V0 c, \7 c! J, @
; O1 u( g6 d+ ~
渡亥岷蝺抵鋆∠蝣/ t% K2 @: W& a* {6 Z2 c
>flush query cache;; }$ d6 q1 W! |/ M: O
) [! x) [- d7 D9 M$ p* s, F1 t2 W5 c芷斗亥岷蝺抵鋆∠批捆
, x) m& b# V9 H1 \9 |>reset query cache;$ |1 ~* u$ R, l8 @8 E7 I
0 b m# _5 v7 Y2 ~
閮剔蔭mysql
+ D P+ j$ |+ N0 O>SET GLOBAL;4 L% L* X+ _1 G0 v
+ B. S8 \1 R3 B( O' n亥岷mysql嗅瑁sql隤/ N# C1 |9 y% h$ @* F
>show processlist; 6 J+ ~2 n) M3 W" j4 R# |. B6 M
1 X! V5 Q9 F7 A X
|
|