[pgpool-general-jp: 1129] Re: CPU LOAD AVERAGE が急に高くなった

張 福民 cho @ jtrustsystem.co.jp
2012年 12月 3日 (月) 13:19:51 JST


$B$*@$OC$K$J$C$F$*$j$^$9!#(B

$B$*@$OC$K$J$C$F$*$j$^$9!#(B
vmstat$B$G3NG'$7$?$H$3$m!"2<5-$N7k2L$H$J$j$^$7$?!#(B

$ vmstat -a 60 20
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu-----
r b swpd free inact active si so bi bo in cs us sy id wa st
0 0 0 2709144 509296 4257028 0 0 0 1 2 1 0 1 99 0 0
0 0 0 2719180 509292 4247096 0 0 0 6 7488 45216 2 11 86 0 0
744 0 0 2712740 509292 4253820 0 0 0 4 7591 45949 2 12 86 0 0
1 0 0 2725264 509296 4240500 0 0 0 5 7233 43023 2 11 87 0 0
0 0 0 2722528 509296 4243832 0 0 0 5 8218 50401 2 13 85 0 0
0 0 0 2707284 509292 4259328 0 0 0 4 7681 46280 2 12 86 0 0
1 0 0 2715328 509292 4251216 0 0 0 5 7580 45324 2 12 86 0 0
1 0 0 2705532 509296 4260352 0 0 0 5 8149 48694 2 12 85 0 0
1 0 0 2723388 509292 4242424 0 0 0 4 7773 46200 2 12 86 0 0
1 0 0 2745840 509292 4220840 0 0 0 4 7888 47009 2 12 86 0 0
0 0 0 2742732 509292 4223856 0 0 0 5 8347 51063 2 13 85 0 0
872 0 0 2721048 509292 4245500 0 0 0 6 7978 47823 2 12 85 0 0
1 0 0 2726248 509292 4240560 0 0 0 5 7473 44433 2 11 87 0 0
0 0 0 2723048 509292 4243676 0 0 0 6 7189 43058 2 11 87 0 0
0 0 0 2720164 509292 4246212 0 0 0 7 7906 46810 2 12 86 0 0
0 0 0 2727024 509288 4239000 0 0 0 5 8075 49246 2 12 86 0 0
743 0 0 2723536 509288 4243188 0 0 0 5 8212 50050 2 12 85 0 0
0 0 0 2714988 509288 4251804 0 0 0 5 8132 49569 2 12 86 0 0
0 0 0 2726860 509808 4238744 0 0 0 5 9099 55722 3 14 83 0 0
0 0 0 2721808 509812 4244748 0 0 0 5 8597 52920 2 13 84 0 0

$B=hM}BT$A$N%W%m%;%9?t$,5^$K(B700$B0J>e$KA}$($?$?$a!"(B
$B$3$N860x$G%m!<%I%"%Y%l!<%8$,9b$/$J$C$?$G$O$J$$$+$H;W$$$^$9!#(B

$B0x$_$K!"(Bpgpool$B$N%m%0$K$O!"2<5-$N$h$&$J%(%i!<%m%0$,=PNO$5$l$F$$$^$9!#(B
$B$3$l$O=hM}BT$A$N%W%m%;%9?t>e$,$C$?M}M3$G$7$g$&$+!)(B

2012-12-03 08:37:58 ERROR: pid 43600: "MD5" authentication with pgpool
failed for user "postgres"
2012-12-03 10:27:48 ERROR: pid 46814: "MD5" authentication with pgpool
failed for user "postgres"
2012-12-03 11:13:18 ERROR: pid 48096: "MD5" authentication with pgpool
failed for user "postgres"
2012-12-03 11:40:13 ERROR: pid 49149: "MD5" authentication with pgpool
failed for user "postgres"
$B!J0lIt$N$_!K(B

$B8=:_(Bpool_hba.conf $B$GG'>Z$7$F$$$^$9!#(B
pool_hba.conf$B$O2<5-$N$h$&$K @ _Dj$7$F$$$^$9!#(B

host all all 111.111.111.112/32 md5
host all all 111.111.111.113/32 md5

pool_passwd$B$K(Bpostgres$B$N(BID$B!?(BPWD$B$O5-:\:Q$G!"(B
Apache$B"*(Bpgpool$B$X$N@\B3$OLdBjL5$5$=$&$G$9!#(B
$B>e5-$N%(%i!<$O$I$N860x$G$7$g$&$+!)(B

$B$*<j?t$r$*3]$1$7$^$9$,!"59$7$/$*4j$$CW$7$^$9!#(B


(2012/12/01 23:35), $BD%!!J!L1(B wrote:
> $B @ P0fMM(B
>
> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
> $BAaB.$N$4JV?.@?$K$"$j$,$H$&$4$6$$$^$9!#(B
>
> $B3NG'$7$F$+$i$4Js9p$5$;$FD:$-$^$9!#(B
>
>
> (2012/12/01 23:22), Tatsuo Ishii wrote:
>> $B @ P0f$H?=$7$^$9!#(B
>>
>> $BLdBj$r @ Z$jJ,$1$k$?$a$K!"(Bwatchdog$B$r(Boff$B$K$7$?$i2~A1$5$l$k$G$7$g$&$+!)(B
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>>> $B$*@$OC$K$J$C$F$*$j$^$9!#(B
>>> $BD%$H?=$7$^$9!#(B
>>>
>>> $BA0F|<ALd$5$;$FD:$$LdBj$O!"8=:_$^$@2~A1$7$F$$$^$;$s!#(B
>>> $B$7$+$b$@$s$@$s$R$I$/$J$C$F$$$^$9!#(B
>>> CPU LOAD AVERAGE$B$,9b$$;~$O!"(B50$B!A(B70$B$0$i$$$N?t;z$b$"$j$^$7$?!#(B
>>>
>>> $B>\$7$$>pJs$rE:IUCW$7$^$7$?!#(B
>>> $B$<$R$*CN7C$rGR<Z$5$;$FD:$1$l$P$H;W$$$^$9!#(B
>>> $BE:IU-!%7%9%F%`9=@.?^(B
>>> $BE:IU-"(Bpgpool.conf
>>> $BE:IU-#(Bpostgresql.conf$B!J%^%9%?B&!K(B
>>>
>>> $B0J>e!"59$7$/$*4j$$CW$7$^$9!#(B
>>>
>>>
>>> (2012/11/27 15:46), $BD%!!J!L1(B wrote:
>>>> $B$O$8$a$^$7$F!#(B
>>>> $BD%$H?=$7$^$9!#(B
>>>>
>>>> PGPOOL-$B-6(B(3.2.1)$B!\(BPostgreSQL(9.1.6)$B$rMxMQ$7$F$*$j$^$9!#(B
>>>> PostgreSQL$B$O(B2$BBf9=@.$G!"(BStream Replication$B$GF14|$r<h$C$F$$$^$9!#(B
>>>>
>>>> $B8=:_!"(BCPU LOAD AVERAGE $B$,5^$K9b$/$J$C$?8=>]$,H/@8$7$F$$$^$9!#(B
>>>> $BBgBN#1F|#5!"#62s$0$i$$$G$9!#(B
>>>>
>>>> $B%5!<%P$O9=C[$7$?$P$C$+$j$G$9$,!"$^$@K\HV2TF/$7$F$$$J$$$N$G!"(B
>>>> $B%5!<%P$NIi2Y$,$"$^$j$J$$$O$:$G$9!#(B
>>>>
>>>> CPU LOAD AVERAGE$B$,9b$/$J$C$?$H$-$G$b!"(B
>>>> pgpool $B$H(B PostgreSQL$B$N%m%0$K$O0[>o$J%a%C%;!<%8$,=PNO$5$l$F$$$^$;$s!#(B
>>>>
>>>> $BBP=hK!$,J,$+$i$J$$$N$G!":$$C$F$*$j$^$9!#(B
>>>> $B$4B8CN$JJ}$O$465<x$*4j$$$G$-$^$9$G$7$g$&$+!#(B
>>>>
>>>> $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> pgpool-general-jp mailing list
>>>> pgpool-general-jp @ sraoss.jp
>>>> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>
>
>
> _______________________________________________
> pgpool-general-jp mailing list
> pgpool-general-jp @ sraoss.jp
> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
-------------- next part --------------
HTML$B$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
URL: <http://www.sraoss.jp/pipermail/pgpool-general-jp/attachments/20121203/b286192e/attachment-0001.html>


pgpool-general-jp メーリングリストの案内