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

[Tatsuo Ishii]

> 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