On Mon, March 22, 2010 11:08, Andres Salazar wrote:
> Everytime i run a mysqldump (mysql-server-5.0.77) all the other
> legitimate queries that are ocurring at that time pretty much sleep
> and build up in the processlist untill I either stop the dump or wait
> for it finish. The moment i do either one i can have about 8-15
> queries waiting they all free up immediately.
> What could be causing this? I know there might be many factors
> involved but Id like to get some clues as to where to look.
First, what are the table types?
Did you set --lock-tables? This will lock the tables within a database
That could cause the behavior you are seeing. I get a similar result when
I do a repair table For transaction enabled table types try
--single-transaction since it avoids read locks (according to the man
William R. Mussatto