From: Janning Vygen <vygen@planwerk6.de>
To: Christopher Murtagh <christopher.murtagh@mcgill.ca>
Cc: pgsql-php@postgresql.org
Subject: Re: How to handle missing pgsql.connect_timeout
Date: Wed, 2 Feb 2005 09:49:20 +0100
Message-ID: <200502020949.21251.vygen@planwerk6.de> (raw)
In-Reply-To: <1107277832.12116.1.camel@localhost.localdomain>
References: <200502010938.17853.vygen@gmx.de>
<200502011740.48639.vygen@planwerk6.de>
<1107277832.12116.1.camel@localhost.localdomain>
Am Dienstag, 1. Februar 2005 18:10 schrieb Christopher Murtagh:
> On Tue, 2005-02-01 at 17:40 +0100, Janning Vygen wrote:
> > Am Dienstag, 1. Februar 2005 14:18 schrieben Sie:
> > > On Tue, 2005-02-01 at 09:38 +0100, Janning Vygen wrote:
> > > > Does anybody has any hints to solve this problem?
> > >
> > > This is a bit of a non-solution, but it is what worked for us. We
> > > simply stopped using pconnect() altogether. This seemed to have solved
> > > connection timeouts and delays. Our site gets 500k page hits per day
> > > without any problems.
> >
> > hm. i didn't get the point. Do you mean you don't use persistent
> > connections just plain pg_connect instead of pg_pconnect??
>
> Exactly. pg_pconnect() is (or was the last time I tried it) broken in
> PHP.
It's not broken anymore! And it speeds up your website.
> We were constantly getting connections that wouldn't close, and
> sometimes not time out. Ever since we gave up on them, we've had no
> problems.
Thats not exactly my problem. I just want to have say
20 MaxClients to wait for http Connections
but only 5 possible DB Connections
I http server no. 6 tries to connect i want pg_pconnect (or pg_connect; that
doesn't matter) to wait maximal 1 second and then return an error.
At the moment it waits "forever" (until max_execution_time i guess) and you
have no chance to show an error message like: DB is overloaded, please try
again.
php_pgsql module doesn't have a directive like mysql which is
mysql_connection_timeout.
i tried pgpool but it doesn't have a timeout value for establishing a
connection.
That's my problem. My DB is overloaded once a week to a special peek time and
i can't afford more hardware. I just want a simple and kind error message.
kind regards
janning
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: vygen@planwerk6.de, christopher.murtagh@mcgill.ca
Subject: Re: How to handle missing pgsql.connect_timeout
In-Reply-To: <200502020949.21251.vygen@planwerk6.de>
References: <200502010938.17853.vygen@gmx.de> <200502011740.48639.vygen@planwerk6.de> <1107277832.12116.1.camel@localhost.localdomain> <200502020949.21251.vygen@planwerk6.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox