MySQL Forums
Forum List  »  InnoDB

Re: Creating sort index cause shared lock
Posted by: SSAP 01
Date: May 24, 2016 09:08PM

We have already tuned up the SQL. The locking is not an issue now. But, I just wonder why there is difference between MySQL & Oracle for the consistent read behavior. In Innodb, the behavior should be almost the same as Oracle, ie. no locking is placed when the consistent read is performed. However, in my case, there are some locks placed when a consistent read is performed by a select statement (without for update or locking mode). In the normal case of MySQL, there is no locking placed in the consistent read performed.

Options: ReplyQuote

Written By
Re: Creating sort index cause shared lock
May 24, 2016 09:08PM

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.