Jeremy, it was included in PART #2 of the problem message. Did you get
that?
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
----- Original Message -----
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Ryan Shrout" <[EMAIL PROTECTED]>
Cc: <[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
> > 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 into
> > the server, and running "top" I see the system load averages in the
> > 90s (!!!) and all I see for processes on the list is mysqld. The
> > CPU usage is at 100%, and the top mysqld process ususally is taking
> > 14% or so, then 12% then a lot of 10%, and on down until it goes off
> > the list.
> >
> > Below, I have included a copy of the "top" status during one of the
> > afore mentioned problem times:
>
> Your system has a fair amount of memory. Can we see the output of
> SHOW PROCESSLIST, SHOW STATUS, and maybe SHOW VARIABLES when this
> happens?
>
> You might want to try out mytop
>
> http://public.yahoo.com/~jzawodn/mytop/
>
> to get an idea of what MySQL is doing at various times.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 0 days, processed 10,728,969 queries (174/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
