MySQL slow queries, small tables

Corey Edwards tensai at zmonkey.org
Tue Jun 10 14:13:11 MDT 2008


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?

Corey

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://plug.org/pipermail/plug/attachments/20080610/97196cd6/attachment.bin 


More information about the PLUG mailing list