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.
Subject
Views
Written By
Posted
3670
May 16, 2016 09:29PM
1845
May 16, 2016 09:48PM
1663
May 23, 2016 03:05PM
Re: Creating sort index cause shared lock
1535
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.