perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Malcolm J Harwood <>
Subject Re: DBI persistence problem
Date Wed, 01 Dec 2004 23:10:57 GMT
On Wednesday 1 December 2004 08:26 pm, Richard N. Fogle wrote:

> 1.  We disabled Apache::DBI - the server can generate thousands of
> queries per second and this feature literally made the CPU catch fire.

Odd. Normally (in my limited experience) it has the reverse effect as you 
aren't creating and destroying a connection every time.

> 3.  We have a disconnect at the end of each perl CGI.  Not sure if it is
> being reached, see no plausible reason why it shouldn't - the code isn't
> that complex.

Worth checking anyway.

> 4.  This is what we have in httpd.conf:
> SetHandler perl-script
> PerlHandler Apache::Registry

Registry will keep any globals around, so if $dbh is global it wont destroy it 
(though if disconnect is being called, it should disconnect it).

> 5.  We easily reach 1024 webserver processes, apache 1.3.

If each one is connecting to the db server (assuming you don't have any 
interprocess connection pooling), then that's your 1024+ db connections right 
there. If the connections are made but not disconnected until the end of the 
script, you would (I think) see a lot of "idle" connections that don't have 
an active query (it's already completed) because they haven't reached the end 
of the script and been disconnected yet.

I always wanted to be somebody, but I should have been more specific.
- Lily Tomlin

Report problems:
Mail list info:
List etiquette:

View raw message