Have you tested with MyISAM for your table type? I suspect some of the extended logging InnoDB has to do for transactions may be part of this slowdown.
On Tue, June 10, 2008 1:53 pm, 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. > > 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. > */ > -- Matthew Walker Kydance Hosting & Consulting LAMP & MU* Specialist /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
