Hi there, On Thu, 17 Oct 2002, John Cameron wrote:
> I am finding that the number of open number of database connections I have > open at one time is varying wildly. > > Then, Suddenly, the number of connctions jumps up to 50 or more! Sometimes > this falls back to below 20, but sometimes this keeps climbing. Server load > hits over 50 (99.9% taken by mysql) and the system grinds to a halt. Your Apache is spawning new children to serve multiple concurrent requests. It's supposed to do that. The extra children are opening connections to the database. When it has more children than it needs it kills off surplus ones which closes the extra database connections. If your machine can't handle the load you need to reduce the possible load. Check the value of MaxClients in httpd.conf. You can read more about this in the (admittedly intimidating:) documentation, see the mod_perl home page http://perl.apache.org for some links. 73, Ged.
