隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
) D2 ]/ i4 \0 y. |) S- Q& Y! h# p+ {, `$ c) s1 ]" \
0 }& g5 z4 z- ^" b
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/63456 S/ M! ^2 e6 b( @6 @: n/ g) F
( x, C. _8 ^$ h4 G
亥岷mysql函賊豢
5 X- S- W, a" @6 O1 K% I6 a0 S; e>SHOW STATUS;
8 I1 Y& C! v3 Z* }% t, T: ^9 q4 |7 Z; a# U
亥岷mysql函賊蝵桅賊
8 Z3 k" T4 ]' b1 A1 D>SHOW VARIABLES;1 ~) v+ w6 Q" i4 W+ E5 {
1 c+ W% [/ A0 f+ s! s
渡亥岷蝺抵鋆∠蝣1 Y* r# t; b+ [
>flush query cache;1 b& R: f r; N7 b
" F6 u3 R1 X/ O8 \+ B9 ^/ h# H" W芷斗亥岷蝺抵鋆∠批捆6 r/ J/ M) Q7 M# [" B
>reset query cache;( j- R9 [$ ~; t: [, Q3 ^
/ s r0 N/ L) U! O+ i% E( _8 J閮剔蔭mysql/ ~) J0 v) p! N% W3 G7 v4 P/ \+ t
>SET GLOBAL;
" O7 s! |) R; j* c' w2 Q$ ~! G
亥岷mysql嗅瑁sql隤
) o8 Y/ Y& Q; u% ~+ G>show processlist; ( M3 S: L2 h( n4 k' O% N/ w
& S: k I/ s( U8 }, d3 ^( p9 k
|
|
潸” 2015-11-6 12:01:02
嗉
鈭
霈
