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
1489
August 27, 2013 07:49AM
729
August 30, 2013 09:32AM
821
August 30, 2013 02:52PM
Re: SELECT blocks SELECT?
764
August 31, 2013 05:06PM
763
August 31, 2013 10:18PM
823
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.