MySQL Forums
Forum List  »  InnoDB

SELECT blocks SELECT?
Posted by: Ekrem Onsoy
Date: August 27, 2013 07:49AM

Hello guys,

According to the MySQL documentation, SELECT takes Schema Lock and Schema Lock is compatible with other Schema Locks. So why does one pure SELECT operation block another SELECT operation?

Command State Info
Query Sending Data SELECT * FROM Table1 WHERE F1 LIKE...
Query Locked LOCK TABLES Table2 WRITE, Table1 WRITE, Table3 WRITE...
Query Locked SELECT * FROM Table1 WHERE F1 = 'XXX'
Query Locked SELECT * FROM Table1 WHERE F1 = 'XXX'
Query Locked SELECT * FROM Table1 WHERE F1 = 'XXX'

What's that I'm missing? Please shed a light.

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT blocks SELECT?
1479
August 27, 2013 07:49AM
724
August 30, 2013 09:32AM
817
August 30, 2013 02:52PM
761
August 31, 2013 05:06PM
760
August 31, 2013 10:18PM
820
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.