MySQL slow queries, small tables
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?
More information about the PLUG