a mysqldump causes all other queries to be queued super slow. Any clue what is going on?

2010-03-22 Thread Andres Salazar
Hello, 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

Re: a mysqldump causes all other queries to be queued super slow. Any clue what is going on?

2010-03-22 Thread Wm Mussatto
On Mon, March 22, 2010 11:08, Andres Salazar wrote: Hello, 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

Re: a mysqldump causes all other queries to be queued super slow. Any clue what is going on?

2010-03-22 Thread Andres Salazar
Hello, On Mon, Mar 22, 2010 at 12:55 PM, Wm Mussatto mussa...@csz.com wrote: First, what are the table types? MyISAM Did you set --lock-tables?  No 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