隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86* A) V5 R3 U& x3 e% D+ X6 Y
+ X! g" x% p4 ]3 @. `
; F, ^" r! z, b# @: S) z( o; }) U餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
! @& _9 h E7 B; H% _+ M3 [
2 c( P* E. [4 a" L3 p* y亥岷mysql函賊豢" I0 E/ g: {! F, i n3 W; K
>SHOW STATUS;
) |3 k$ [+ C2 [" s
; a* \2 K/ U2 b& r, R亥岷mysql函賊蝵桅賊4 [" t4 Q' B7 ]0 H# |' |0 B
>SHOW VARIABLES;
) d$ O- [- M1 F! s! ^6 X- Q" G" i- Q, r1 a
渡亥岷蝺抵鋆∠蝣
5 r- u- L" g/ i4 M! t/ `. M; P>flush query cache;! B/ `) [, Z5 D. W7 P1 Y
! |, l* x p$ {3 z$ ~
芷斗亥岷蝺抵鋆∠批捆0 I& O2 A/ d0 H% E
>reset query cache;
# k+ z u1 l5 J+ y) ~3 P3 r+ M# L1 @' [& F8 t# x& u; L
閮剔蔭mysql
' O( h" l" T! ~; x6 H8 O/ R# y>SET GLOBAL;
8 A+ | x- R2 T' B9 K( Q$ I* b+ S" Z
" J7 q- a) b8 {6 V# \亥岷mysql嗅瑁sql隤0 c9 K! z9 F9 w: [
>show processlist;
1 T {+ o; H7 P5 U9 J( [7 r& a/ N- k5 J1 T7 E9 p$ h+ T n$ q
|
|