[pgpool-general-jp: 1131] Re: CPU LOAD AVERAGE が急に高くなった
張 福民
cho ＠ jtrustsystem.co.jp
2012年 12月 7日 (金) 12:36:09 JST
$B ＠ P0fMM(B
$B$*@$OC$K$J$C$F$*$j$^$9!#(B
$B$4JV?.$"$j$,$H$&$4$6$$$^$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
>
> $B$=$l$O$A$g$C$HJ,$+$j$^$;$s$,(B...
$B3N$+$=$&$G$9$M!#$o$1$NJ,$+$i$J$$<ALd$G?=$7Lu$"$j$^$;$s$G$7$?!#(B
$B$b$&$A$g$C$HD4$Y$F$^$?$4Js9p$7$?$7$^$9!#(B
> $BK\Mh ＠ .8y$9$k$O$:$N(Bmd5$BG'>Z$,<:GT$9$k!"$H$$$&>c32$,(Bpgpool-II 3.2.1$B$r%j%j!<(B
> $B%9$7$?8e$K8+$D$+$C$F$*$j!"$=$l$,4X78$7$F$$$k2DG=@-$,$"$j$^$9!#(B
>
>
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ee0bac759857599023da9268d82c05604b759a64
>
> $B$9$G$K(Bgit$B$G$O=$@5$5$l$F$$$k$N$G!"$h$m$7$1$l$P(Bgit$B$+$i(B3.2-stable$B%D%j!<$r(B
> $B%@%&%s%m!<$7$F$*;n$7$/$@$5$$!#(B
>
>
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE
$BN;2r$7$^$7$?!#3NG'$$$?$7$^$9!#(B
$B0J>e!#59$7$/$*4j$$$$$?$7$^$9!#(B
(2012/12/05 17:49), Tatsuo Ishii wrote:
> $B ＠ P0f$G$9!#(B
>
>> $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
> $B$=$l$O$A$g$C$HJ,$+$j$^$;$s$,(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
> $BK\Mh ＠ .8y$9$k$O$:$N(Bmd5$BG'>Z$,<:GT$9$k!"$H$$$&>c32$,(Bpgpool-II 3.2.1$B$r%j%j!<(B
> $B%9$7$?8e$K8+$D$+$C$F$*$j!"$=$l$,4X78$7$F$$$k2DG=@-$,$"$j$^$9!#(B
>
> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ee0bac759857599023da9268d82c05604b759a64
>
> $B$9$G$K(Bgit$B$G$O=$@5$5$l$F$$$k$N$G!"$h$m$7$1$l$P(Bgit$B$+$i(B3.2-stable$B%D%j!<$r(B
> $B%@%&%s%m!<$7$F$*;n$7$/$@$5$$!#(B
>
> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE
>
>> $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
>
pgpool-general-jp メーリングリストの案内