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