隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%863 f& r# o( C$ Q4 W$ S2 V
1 |! N! Y# J& [; n2 B Q1 k2 _
3 K7 H, T* ?' T% |餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/63459 l+ |1 [6 M2 G. @; g0 E
, D; X4 O+ P% b. ]0 H
亥岷mysql函賊豢
' Z( b4 O6 N Q- ~4 @7 D>SHOW STATUS;
- p0 f7 Q! D2 m; w2 _% s. g) w; I7 y* h# V# x8 i
亥岷mysql函賊蝵桅賊- C/ c2 x. [$ X7 G' K
>SHOW VARIABLES;1 s8 W6 H. t2 a
* y1 X+ B6 C' Z8 @# S+ }5 a渡亥岷蝺抵鋆∠蝣
$ b' P2 `6 U8 e! _( V7 ?: q& l>flush query cache;9 A9 m& y( n3 a$ b
( ?. ]6 p: c0 w, u* @2 d: \% Q9 Z芷斗亥岷蝺抵鋆∠批捆: Q3 O2 `9 H" p+ e1 h/ r5 y9 Q1 o' x
>reset query cache;
" C2 z% S" _1 R5 l: l, d/ Z1 _4 q- m1 |/ B2 F, J' M0 n
閮剔蔭mysql
1 j V8 ]* }, ?1 E$ }1 j>SET GLOBAL;
1 s1 C( R" k+ s% d9 i. |. U9 H7 E
* w* r* R$ {" G9 h9 i' W亥岷mysql嗅瑁sql隤: u; E) y9 G" T0 z0 T( ]
>show processlist;
5 H3 j/ S- F6 M9 |" Y2 g( _$ |: G7 y% g$ L3 b' F
|
|
潸” 2015-11-6 12:01:02
嗉
鈭
霈
