Thank you for the tip, but this is not our problem. We are running SCSI
disks with over 40 MB/sec throughput. Any other ideas?
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
----- Original Message -----
From: "Werner Stuerenburg" <[EMAIL PROTECTED]>
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 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.
This is what I used to have. We invoked the scenario described in
http://linux.oreillynet.com/pub/a/linux/2000/06/29/hdparm.html
and since then things went back to normal without any other
tuning. Oh, one more thing: I changed pconnect to connect in php.
So it looks as like we had load problems at times due to poor hd
performance which gave trouble to mysql.
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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