MySQL slow queries, small tables

Dave Smith dave at thesmithfam.org
Tue Jun 10 14:38:36 MDT 2008


Corey Edwards wrote:
> On Tue, 2008-06-10 at 13:53 -0600, Dave Smith wrote:
>   
>> I have a MySQL table with 1 row in it. If I run 'cat /dev/zero > 
>> /tmp/foo', it can take 2 minutes to execute a single UDPATE on my table. 
>> The table has a proper primary key and I am updating a single row, so I 
>> suspect it has nothing to do with MySQL indexes. I suspect that MySQL 
>> can't get time on the disk to actually perform the write. My table is 
>> InnoDB. Select statements still run at normal (fast) speeds, even though 
>> my monster cat is still running.
>>     
>
> What happens if you nice cat?
>   

No difference. I've tried nice and ionice (sorry, should have mentioned 
that earlier).

--Dave



More information about the PLUG mailing list