隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86/ R' w) Z/ Y. j6 V0 t* \6 f
4 X( S& _5 `/ c" i
v; b: |- \+ |% w0 R餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/6345
0 i7 f& p8 V9 T: h# ?4 ]1 j G* Y9 w5 G" P$ @
亥岷mysql函賊豢( l/ Y- f0 I3 s5 |7 }
>SHOW STATUS;
8 o$ ~6 t" q; r. E
, ^5 l$ }- n( ?: K; X亥岷mysql函賊蝵桅賊
9 L0 Q: Y: o; U5 w>SHOW VARIABLES;
1 H# G, y$ x/ O
+ p' s/ d* m0 K$ @ ^6 l; t5 y渡亥岷蝺抵鋆∠蝣- S) s; G5 l) Z* a. ?2 u# x$ v' l
>flush query cache;
; ~0 b: X: l' o- `1 G9 j6 h% o
5 H& w7 Z; Z# o% {9 X) E: _& ?芷斗亥岷蝺抵鋆∠批捆, I/ _7 A1 b+ H$ ]* ~8 e* p
>reset query cache;8 E( M8 Z/ x: k, O, x7 y
; d5 O! c7 M/ `2 R/ S9 N' c1 e! G6 O2 m% q閮剔蔭mysql
' R& D& i5 I# q! @+ d; P$ k# ?>SET GLOBAL;
2 Y$ F7 D+ h" }2 K2 \ K' {2 d3 m1 M
亥岷mysql嗅瑁sql隤6 h, n. y* a$ h! T ]
>show processlist;
" b! m- F, K0 ~: c W, e5 G! y# U/ d; T7 G. D v
|
|
潸” 2015-11-6 12:01:02
嗉
鈭
霈
