隢 http://blog.xuite.net/towns/hc/6 ... A%E7%AE%A1%E7%90%86
* M5 H$ y7 \9 n! t9 Y2 T% J3 h! Q+ q x0 J+ |& g
* z$ ^7 w6 i( T% q
餃叮ysql 敺 銝鈭 command: 臬 http://article.denniswave.com/63455 [/ ^4 l/ |1 m: o6 S
% z+ H" W x8 b8 u7 d0 q4 B' H
亥岷mysql函賊豢( o# [+ t" J% c/ s1 H6 l0 Y2 ~9 Y
>SHOW STATUS;
5 T3 o5 v1 C8 p; \
$ Q( x/ |' O/ e& w亥岷mysql函賊蝵桅賊
! |. a: [: S! B4 W! h" x/ j/ R>SHOW VARIABLES;- @1 K8 @ C, N7 j$ k! Q
3 I" H) B g/ }# ]0 R0 x; H+ t
渡亥岷蝺抵鋆∠蝣
g! L/ I! D$ k! V3 x0 A>flush query cache;% E$ V, L9 }5 s' W# Q
" t/ c# b, ?4 h# v3 `: ?+ D7 \8 n
芷斗亥岷蝺抵鋆∠批捆, e0 ]" }& k2 ?% V
>reset query cache;( }. }& d0 \7 L2 r) F- l
" [" x% m$ _ [" }* ?5 Q; }
閮剔蔭mysql
. [. e( L8 O i$ s* C+ W3 b>SET GLOBAL;% b* \+ L2 |- X$ y( N/ t- `
+ w8 S/ [9 r( f. [# N( H
亥岷mysql嗅瑁sql隤
9 W, y; |' Z" g, ~2 P/ v4 W3 A>show processlist; ( s7 v( b) n6 `+ a* }
4 _+ B' V G, {7 @" S |
|
潸” 2015-11-6 12:01:02
嗉
鈭
霈
