Re: re : PHP and persistent connections - Mailing list pgsql-novice

From GH
Subject Re: re : PHP and persistent connections
Date
Msg-id 20001123101417.C30801@over-yonder.net
Whole thread Raw
In response to re : PHP and persistent connections  (<pejac@altern.org>)
Responses Re: re : PHP and persistent connections
List pgsql-novice
On Thu, Nov 23, 2000 at 04:53:35PM +0100, some SMTP stream spewed forth:
> Set the number of connection in php.ini to 2

I tried doing this, with the max set to 1, 2, and 3; but the number
of backends continues to grow until smacking into the ceiling.
What is controlled by max_persistent? It seems like PHP is just
ignoring this value. I apologize for bringing PHP onto this list, but
it is relevant.

Should not the backends die at *some* point?

Using regular connections almost triples the script's execution time.
(It is still under .5 seconds, but...)

It seems like the number of Apache processes would have to be *really*
low or the number of backends would have to be *really* high.

Our backend limit is still the default 32.

I thank you.
gh

>
> Exemple :
> [PostgresSQL]
> pgsql.allow_persistent  =       On      ; allow or prevent persistent link
> pgsql.max_persistent    =       2      ; maximum number of persistent links. -1
>  means no limit
> pgsql.max_links                 =       2      ; maximum number of links (persi
> stent+non persistent).  -1 means no limit
>
> Because if you keep the default value each apache process
> has an ulimited number of connection. So if your
> httpd start with 10 child process you have 20 persistent connections. So be carefull about the number of apache
> process and check the value of persistent connection
> in php.ini in order to adjust it.
>
> Cheers
>
> PEJAC Pascal
>
>

pgsql-novice by date:

Previous
From: "Eduardo Kotujansky"
Date:
Subject: startup script for FreeBSD
Next
From: GH
Date:
Subject: Re: re : PHP and persistent connections