To: "Ryan Shrout" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 6:50 AM
Subject: Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1
> Okay, here is the problem: everyone once in a while, say once or twice a
day, my web server running
> Okay, here is the problem: everyone once in a while, say once or twice a day, my
>web server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users
>point of view). Upon SSH'ing
> into the server, and running "top" I see the system load averages in the 90s (!!!)
>and all
<[EMAIL PROTECTED]>
Sent: Friday, August 17, 2001 8:28 PM
Subject: Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1
> On Fri, Aug 17, 2001 at 06:54:59PM -0400, Ryan Shrout wrote:
> >
> > This message is broken into two parts because the MySQL list blocked
> &g
It may be that MySQL is simply spawning too many processes for your
machine to handle.
I might be wrong, but here's something to try:
1. Set MySQL max_connections to 45.
2. Set httpd MaxClients to 50.
That will limit the number of processes MySQL is allowed to start, and
also makes sure that Ap
On Fri, Aug 17, 2001 at 06:54:59PM -0400, Ryan Shrout wrote:
>
> This message is broken into two parts because the MySQL list blocked
> it as being too big!!!
>
> Okay, here is the problem: everyone once in a while, say once or
> twice a day, my web server running RH 7.2, PHP 4.0.6 and MySQL, wi
This message is broken into two parts because the MySQL list blocked it as being too
big!!!
Okay, here is the problem: everyone once in a while, say once or twice a day, my web
server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users
point of view). Upon SSH'ing int
