Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2. Sometimes, server's system load rapidly
grows, and mysql are locked. Normally, there are 7-10 mysql processes,
at this strange situation, there are 30-40.
I don't know what can make such big system load in time of 1 minute.
Maybe this could help: http://saepia.net/temp/mysql.txt
It's 'show processlist' when mysql is locked.
Mysql load is about 50 queries per second. There are mostly myisam
tables and they are stored on ide100 drive with dma enabled.
Or maybe it's DoS?
--
m.