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
/*
PLUG: http://plug.org, #utah on irc.freenode.net
Unsubscribe: http://plug.org/mailman/options/plug
Don't fear the penguin.
*/