磯部 和広
k-iso****@rozet*****
2013年 5月 14日 (火) 20:17:45 JST
$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B $B8=:_$O!"2<5-$N$h$&$J=hM}$K$J$C$F$*$j$^$9!#(B $B!!-!3F%F!<%V%kKh$N%^%C%A7o?t$r<hF@$9$k(B $B!!-"-!$N9g7WCM$,#5K|0J2<$G$"$l$P-#$r<B9T$9$k(B $B!!-#-!$G%^%C%A$7$?9T$r=PNO$9$k(B $B-!$H-#$O!"(Bselect$B6g$,(Bcount(1)$B$+!"%U%#!<%k%IL>$+$,0[$J$k$@$1$G$9!#(B $B$I$A$i$N(BSQL$B72$b!"@hF,$HKvHx$K!V(Bflush tables;$B!W$,IUM?$5$l$F$*$j$^$9!#(B $B$3$N0Y!"-!$N(BSQL$B$G$NJV5Q%l%3!<%I?t$O%F!<%V%k?t$G(B $B-#$O#5K|0J2<$N$^$A$^$A$JCM$H$J$j$^$9!#(B $B99$K6qBNE*$K$O!#(B $B8=:_!"(BDB$B%5!<%P!<$O#2$D$"$j!"$=$l$>$l(B120$B8D$H(B73$B8D$N%F!<%V%k$,$"$j$^$9!#(B SQL$B$O(B $B!!(Ba. $B%5!<%P!<(BA$B$N%F!<%V%k(B0$B!A(B59 $B!!(Bb. $B%5!<%P!<(BB$B$N%F!<%V%k(B120$B!A(B193 $B!!(Bc. $B%5!<%P!<(BA$B$N%F!<%V%k(B60$B!A(B119 $B$H$$$&$U$&$K(B3$B2s$KJ,$1$F<B9T$5$l$^$9(B a$B$H(Bb$B$,N>J}=*$o$C$F$+$i(Bc$B$,<B9T$5$l$k$N$GF1;~$K$O<B9T$5$l$^$;$s!#(B $B8G$^$k$N$O!"(Ba$B$H(Bc$B$N(BSQL$B$,F0$/%5!<%P!<(BA$B$G$9!#(B SWAP$B$,BgNL$KH/@8$9$k$N$b$3$A$i$G$9!#(B $B8=:_$O!"(BDB$B%5!<%P!<$,;~!98G$^$j$^$9$,(BDB$B%5!<%P!<%/%i%C%7%e0J30$O(B $B4pK\E*$KLdBjL5$/%G!<%?$,<hF@$G$-$F$$$^$9!#(B SQL$B$N<hF ＠ 7k2L$K0[>o$,$"$k$N$G$O$J$/$F(B $B!!(BDB$B%5!<%P!<$,8G$^$k(B $B$N$,LdBj$H$$$&G'<1$G$9!#(B $B"(>/$J$/$H$b!":#$N$H$3$m$O!&!&!&(B $B$A$J$_$K!"(BDB$B%5!<%P!<$,%/%i%C%7%e$7$F:F5/F0$7$?$N$O(B $B!!7o?t$,(B21914.$B$N$b$N$N<B%G!<%?<hF@$N:](B $B$G$7$?!#(B $B:#$^$G<hF@$7$?$&$A!":G$b7o?t$,B?$+$C$?$b$N$O(B $B!!(B4047195 $B$G$7$?!#(B $B7o?t$NB?$+$C$?=g$K%j%9%H$9$k$H!"2<5-$N$h$&$K$J$j$^$9!#(B [k-isobe ＠ PMJ14 ~]$ cut -f 2 /dev/shm/kv | sort -rn | head 4047195 3855477 3344830 2765195 1901400 1865015 1830702 1610473 1437442 1397990 [k-isobe ＠ PMJ14 ~]$
