MySQL slow queries, small tables

Dave Smith dave at thesmithfam.org
Tue Jun 10 13:53:04 MDT 2008


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.

Any idea what's going on?

TIA.

--Dave



More information about the PLUG mailing list