隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
# ~( t/ H: D% p: ~$ h% |. R7 }0 V; {+ T3 r3 x2 e
# Z+ ^" h6 E" T) n- Q
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
! J& H$ j& H8 ?" F9 Z& N" b
8 ?. }2 K/ m2 Q2 ~; S5 {# p. j亥岷mysql函賊豢" [: @! U6 Q+ c& B
>SHOW STATUS;* }7 Y/ O- r; X
% L9 x/ g1 m" m0 Y4 R亥岷mysql函賊蝵桅賊
; ^3 q5 }% _7 R* s1 r>SHOW VARIABLES;6 C& U# Z2 |# x% E) Y% f& I
- k7 m# a% m( r3 U渡亥岷蝺抵鋆∠蝣
0 p! O, j+ ^- d6 J+ M4 E$ o2 L% Z; g>flush query cache;
+ h" p9 |6 Z1 g4 n7 r6 Z( d/ ?# H) T, P3 ^, C5 L! B% Y
芷斗亥岷蝺抵鋆∠批捆( i' N' J5 p, ]
>reset query cache;* k. Z; G" z/ Q7 @0 J
2 W+ c6 w1 u2 _4 \* `* r3 H
閮剔蔭mysql5 _- U* k: W7 V0 Z, ^4 x2 D, B
>SET GLOBAL;
, u1 U* F, F- a6 m1 g5 S1 ~% C! f9 |! L! H: k' @0 n( ]+ v& ^
亥岷mysql嗅瑁sql隤
" e( W# M. q* |/ `' D6 O' G: C>show processlist; - C$ S9 Q( a! ~7 U! b. `1 I& ^
! m8 |' @, h! o6 @7 L
|
|