Re: Website troubles - Mailing list pgsql-general

From Marc G. Fournier
Subject Re: Website troubles
Date
Msg-id 20030129224853.I22851@hub.org
Whole thread Raw
In response to Re: Website troubles  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Website troubles
Re: Website troubles
Re: Website troubles
Re: Website troubles
List pgsql-general
On Wed, 29 Jan 2003, Robert Treat wrote:

> Well, maybe it does, but when an important news story drives new
> eyeballs to your website, you need something better than a bouncing $hit
> happens logo if you want to make a positive impression. All Greg wants
> to know is what caused the problem and what steps are being taken to
> make sure it doesn't happen again. That's hardly unreasonable.

The problem is/was persistent database connections ... the problem, IMHO,
is that there is no way of 'timing out' idle connections, so any load on
the web site that creates a whack of persistent connections, and then they
all go idle, then if another hit on a different database goes through, it
gets starved for connections ...

I've started to disable PHPs default of allowing persistent connections,
which seems to have help'd ...


pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Crypt in queries and functions?
Next
From: Andrew Perrin
Date:
Subject: Re: Perl DBI and placeheld values