MySQL Forums
Forum List  »  General

Re: Is it best practice to lock table for every Mysql query?
Posted by: Craig Liu
Date: December 21, 2018 01:41PM

To explain why a SELECT only MySQL query need to place READ lock for all tables included in this SELECT query.

If we don't place READ lock, what bad things should happen?

Options: ReplyQuote

Sorry, only registered users may post in this forum.

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.