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 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

How to benchmark OpenBSD for Mysql .

2010-02-28 Thread Andres Salazar
Hello, Iam a OpenBSD user. I would like to know if there is any technique specific to the US to be able to benchmark the IO for this OS. Also, what result would be considered acceptable and what is not. Thanks!! Andres -- MySQL General Mailing List For list archives: