MySQL slow queries, small tables

Matthew Walker mwalker at kydance.net
Tue Jun 10 13:57:14 MDT 2008


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



More information about the PLUG mailing list