[pgpool-general: 8] Re: [Pgpool-general] pgpool limitations
sandeeptt at yahoo.com
Tue Nov 29 15:49:56 JST 2011
client_idle_limit is set to '0'. Here is the other related settings:
pcp_timeout = 10
num_init_children = 32
max_pool = 4
child_life_time = 300
connection_life_time = 0
child_max_connections = 0
client_idle_limit = 0
From: Tatsuo Ishii <ishii at sraoss.co.jp>
To: sandeeptt at yahoo.com
Cc: singh.gurjeet at gmail.com; pgpool-general at pgfoundry.org; pgpool-hackers at pgfoundry.org
Sent: Wednesday, November 23, 2011 8:21 PM
Subject: Re: [Pgpool-general] pgpool limitations
One possibility is client_idle_limit.
SRA OSS, Inc. Japan
> I have found that sometimes the client connections get disconnected and the new ones are established. What I do is I get the PIDs using "pcp_proc_count" before running "pcp_attach_node" and then run "pcp_proc_count" to check if the PIDs remain same. I found that the behaviour is random. When can this happen?
> From: Tatsuo Ishii <ishii at sraoss.co.jp>
> To: singh.gurjeet at gmail.com
> Cc: pgpool-general at pgfoundry.org; pgpool-hackers at pgfoundry.org
> Sent: Thursday, August 11, 2011 6:11 AM
> Subject: Re: [Pgpool-general] pgpool limitations
>>> > > Is there something in the works to enable this, or is this feature
>>> still in
>>> > > design phase? If it is already being/been developed, I wish to know if
>>> > > can be back-patched to a point release of pgpool 3.0.x.
>>> > It has been already in pgpool-II 3.1 alpha version.
>>> > Currently there's no plan to back-patching to 3.0.x.
>>> I certainly hope we won't backpatch a new feature. That would be insane.
>> I don't consider this a new feature. I'd say this is unexpected side-effect
>> (a.k.a bug) of pcp_attach_node, since nowhere in the docs does is say that
>> invoking pcp_attach_node would drop all client connections.
> This behavior has not been changed since pcp_attach_node was born in
> 2006. Moreover, the enhancement in 3.1 is only for steaming
> replication mode. Other modes including replication mode does not take
> advantage of this.
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general