Updates/Inserts blocking SELECTS on other tables without locks.
Ok, I've tried everything I can think of here.
We've recently switched our database over to InnoDB from myisam.
We have a table that whenever it is inserted to, updated, or has a row deleted from it no other selects are possible on any tables. As first we thought it might be some of the extra indexes that Django put into the db for us so we removed those. Then we found a blog post on the mysql performance blog about how Foreign Keys can cause other tables to lock, so we removed all foreign keys from the table.
This has helped for the time where all selects are blocked, but has not removed the wait time as it is still up to 20 or 30 seconds.
The select queries are not marked as locked in SHOW FULL PROCESSLIST. And the table getting updated isn't that large, only ~250k rows. Has anyone experienced/have knowledge of a similar issue?
Subject
Views
Written By
Posted
Updates/Inserts blocking SELECTS on other tables without locks.
2347
December 11, 2008 02:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.