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.
*/

Reply via email to