[pgpool-general: 4776] Re: Cpu increase with pgpool

[Tatsuo Ishii]

Great!

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Tatsuo,
> 
> I installed the latest version and it's OK now.
> 
> Thanks for your tip.
> 
> Best regards.
> 
> 2016-07-06 19:45 GMT-03:00 Tatsuo Ishii <ishii at postgresql.org>:
> 
>> > Tatsuo, good morming
>> >
>> > When I try to install the lastest pgpool version appears:
>> >
>> > rpm -ivh /tmp/pgpool-II-pg94-3.5.3-1pgdg.rhel6.x86_64.rpm
>> > error: Failed dependencies:
>> >         libmemcached.so.2()(64bit) is needed by
>> > pgpool-II-pg94-3.5.3-1pgdg.rhel6.x86_64
>> >         libmemcached.so.2(libmemcached_2)(64bit) is needed by
>> > pgpool-II-pg94-3.5.3-1pgdg.rhel6.x86_64
>> >
>> > but:
>> >
>> > /usr/lib64/libmemcached.so.11
>> > /usr/lib64/libmemcached.so.11.0.0
>> > /usr/lib64/libmemcachedprotocol.so.0
>> > /usr/lib64/libmemcachedprotocol.so.0.0.0
>> > /usr/lib64/libmemcachedutil.so.2
>> > /usr/lib64/libmemcachedutil.so.2.0.0
>>
>> But there's no libmemcached.so.2 here. Also using rpm command directly
>> to install packages is not recommended because it does not take care
>> of the package dependency. Please follow the instruction here and use
>> yum command instead of rpm command:
>>
>> http://pgpool.net/mediawiki/index.php/Yum_Repository
>>
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>>
>> > I tried to export the LD_LIBRABY_PATH but I didn't have success.
>> >
>> > CentOS release 6.7 (Final)
>> > Kernel \r on an \m
>> >
>> > 2.6.32-573.22.1.el6.x86_64 #1 SMP Wed Mar 23 03:35:39 UTC 2016 x86_64
>> > x86_64 x86_64 GNU/Linux
>> >
>> > Thank you
>> >
>> > 2016-07-05 20:28 GMT-03:00 JotaComm <jota.comm at gmail.com>:
>> >
>> >> Hello,
>> >>
>> >> Could I you this version pgpool-II-pg93-3.5.3-1pgdg.rhel7.x86_64.rpm
>> >> <
>> http://www.pgpool.net/yum/rpms/3.5/redhat/rhel-7-x86_64/pgpool-II-pg93-3.5.3-1pgdg.rhel7.x86_64.rpm
>> >
>> >> by http://www.pgpool.net/yum/rpms/3.5/redhat/rhel-7-x86_64?
>> >>
>> >> Thank you.
>> >>
>> >>
>> >> 2016-07-05 20:06 GMT-03:00 Tatsuo Ishii <ishii at postgresql.org>:
>> >>
>> >>> > Tatsuo,
>> >>> >
>> >>> > Thanks for answering.
>> >>> >
>> >>> > My version is: pgpool-II version 3.5.0 (ekieboshi)
>> >>> >
>> >>> > Thanks you.
>> >>>
>> >>> That's definitely too old and has tons of bugs:-). The latest one is
>> >>> 3.5.3.
>> >>>
>> >>> Best regards,
>> >>> --
>> >>> Tatsuo Ishii
>> >>> SRA OSS, Inc. Japan
>> >>> English: http://www.sraoss.co.jp/index_en.php
>> >>> Japanese:http://www.sraoss.co.jp
>> >>>
>> >>> > 2016-07-05 19:47 GMT-03:00 Tatsuo Ishii <ishii at postgresql.org>:
>> >>> >
>> >>> >> > Hello,
>> >>> >> >
>> >>> >> > After to start the pgpool service the load average increased a lot
>> >>> of.
>> >>> >> >
>> >>> >> > My postgresql.conf
>> >>> >> >
>> >>> >> > max_connections = 500
>> >>> >> >
>> >>> >> > My pgpool.conf
>> >>> >> >
>> >>> >> > num_init_children = 32
>> >>> >> >
>> >>> >> > max_pool = 4
>> >>> >> >
>> >>> >> > Before to start the pgpool load average was about 1, after to
>> start
>> >>> the
>> >>> >> > pgpool the load average is increasing, for example: now the load
>> >>> average:
>> >>> >> >
>> >>> >> > load average: 28.63, 27.34, 24.24
>> >>> >> >
>> >>> >> > Any idea?
>> >>> >> >
>> >>> >> > Thank you
>> >>> >>
>> >>> >> What version of pgpool-II are you using? I recall that some versions
>> >>> >> of pgpool-II had similar problems. If you still have the problem
>> even
>> >>> >> with the latest version of pgpool-II, please let me know.
>> >>> >>
>> >>> >> Best regards,
>> >>> >> --
>> >>> >> Tatsuo Ishii
>> >>> >> SRA OSS, Inc. Japan
>> >>> >> English: http://www.sraoss.co.jp/index_en.php
>> >>> >> Japanese:http://www.sraoss.co.jp
>> >>> >>
>> >>> >
>> >>> >
>> >>> >
>> >>> > --
>> >>> > JotaComm
>> >>> > http://jotacomm.wordpress.com
>> >>>
>> >>
>> >>
>> >>
>> >> --
>> >> JotaComm
>> >> http://jotacomm.wordpress.com
>> >>
>> >
>> >
>> >
>> > --
>> > JotaComm
>> > http://jotacomm.wordpress.com
>>
> 
> 
> 
> -- 
> JotaComm
> http://jotacomm.wordpress.com