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
