Re: SELECT blocks SELECT?
Thank you for your reply Rick.
Well, actually this is a 3rd party application and when I monitor the running processes, I see a lot of LOCK TABLES command.
At this point, I do not understand why did they use such a command (LOCK TABLES) explicitly? Does MySQL let dirty reads by default?
I read the documentation about LOCK TABLES and SELECT ... FOR UPDATE, as far as I understand the first one locks the whole table however the latter locks only related rows with the query.
Subject
Views
Written By
Posted
1502
August 27, 2013 07:49AM
731
August 30, 2013 09:32AM
826
August 30, 2013 02:52PM
767
August 31, 2013 05:06PM
Re: SELECT blocks SELECT?
766
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.