[Pgpool-general] new connections are not accepted

Martin Badie martinbadie at yahoo.com
Fri Jun 5 07:30:19 UTC 2009


Yoshiharu I am very new to pgpool but I think maximum number of connection allowed in a  certain time is num_init_chidren x max_pool (which is in my case 40x32?)
Am I wrong?

# number of pre-forked child process
num_init_children = 40

# Number of connection pools allowed for a child process
max_pool = 32




________________________________
From: Yoshiharu Mori <y-mori at sraoss.co.jp>
To: Martin Badie <martinbadie at yahoo.com>
Cc: pgpool-general at pgfoundry.org
Sent: Friday, June 5, 2009 9:39:56 AM
Subject: Re: [Pgpool-general] new connections are not accepted

Hi

> Hi,
> Yes my application uses persistent connections.How can I found out how many 
> connections are used in a certain time

Simply, ps auxwww or netstat -nap | grep pgpool

> and how can I detect  maximum 
> simultaneous connections from pgpool.conf so I can tweak my application 
> for that maximum connection number.

"num_init_children" is maximum simultaneous connection number.

-- 
SRA OSS, Inc. Japan
Yoshiharu Mori <y-mori at sraoss.co.jp>
http://www.sraoss.co.jp/



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090605/93a725f2/attachment.html>


More information about the Pgpool-general mailing list