Re: [phplib] performance From: nathan r. hruby (nhruby <email protected>)
Date: 11/30/00

On Wed, 29 Nov 2000, Krzysztof Sierota wrote:

> > Hello,
> >
> > I'm having some performance issues with one of my PHPlib-based web
> > sites. The site gets around 220,000 hits a day. It runs on Redhat 6.1,
> > MySQL 3.22.32, PHP 3.07, Apache 1.3.6. 128 MB RAM. Can anybody with
> > similar traffic and a similar configuration post how they've configured
> > Apache and MySQL to handle the traffic?
> >
> > I know there are too many variables involved in tuning a system, but any
> > input will at least be a starting point for me. By the way, some other
> > information:
> >
> > MySQL:
> > max_connections: 100
> >
> > Apache:
> > MaxClients: 150
> > MaxRequestsPerChild: 50
> > StartServers: 10
> > MaxSpareServers: 10
> > MinSpareServers: 5
> >
> > Sometimes I get "can't connect to db, too many connections" errors,
> > which I find strange.
> I don't know what is your php setup, but It might be that each apache
> instance is having its own db connection and when you exceed 100 concurrent
> users the 'too many connections' error appears.
>

phplib-7.2a also used to leave tons of open connections laying around, if
you have't, change up to 7.2c it should help the out of connection
problems. Also, make sure you're destroying and / or reusing db objects as
opposed to just starting a new one every time you need db access.
(destroying the object will release the connection back to php's
conenction pool)

Also, you can also just up the mysql_max_connections limit in your
php3.ini file to something more resonable. 100 seems low if you get even
20 percet of your traffic at one time (say early morning...)

-n
 --
........
nathan hruby
Webmaster: UGA Department of Drama and Theatre
Project Maintainer: phpSlash, Carousel
nhruby <email protected>
........

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>