Re: SELECT blocks SELECT?
Posted by:
Rick James
Date: August 31, 2013 05:06PM
> Query Locked LOCK TABLES Table2 WRITE, Table1 WRITE, Table3 WRITE...
That is waiting for the running SELECT before locking-for-write `table1`. After UNLOCKing, the other SELECTs can get to the table.
Do not use LOCK TABLE on InnoDB. Instead use SELECT...FOR UPDATE, and BEGIN...COMMIT.
Subject
Views
Written By
Posted
1506
August 27, 2013 07:49AM
731
August 30, 2013 09:32AM
826
August 30, 2013 02:52PM
Re: SELECT blocks SELECT?
768
August 31, 2013 05:06PM
767
August 31, 2013 10:18PM
825
September 01, 2013 11:01AM
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.