MySQL slow queries, small tables
dave at thesmithfam.org
Tue Jun 10 14:38:36 MDT 2008
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
More information about the PLUG