List:General Discussion« Previous MessageNext Message »
From:Marcin Lewandowski Date:March 3 2005 11:50am
Subject:MySQL hangs
View as plain text  
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.


Thread
MySQL hangsMarcin Lewandowski3 Mar
  • Re: MySQL hangsPhilippe Poelvoorde4 Mar
  • Re: MySQL hangsGleb Paharenko4 Mar