| From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
| Cc: | greg(at)turnstep(dot)com, Tony Grant <tony(at)tgds(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Website troubles |
| Date: | 2003-01-30 02:52:07 |
| Message-ID: | 20030129224853.I22851@hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Perrin | 2003-01-30 02:54:21 | Re: Perl DBI and placeheld values |
| Previous Message | Neil Conway | 2003-01-30 02:43:20 | Re: Crypt in queries and functions? |