MySQL Forums
Forum List  »  InnoDB

why UPDATE requires share lock(S) for table joined
Posted by: Mingyang chen
Date: November 12, 2014 01:03AM

for example
update t inner join lktest on lktest.c3=t.x set t.y=t.y where lktest.c3=2;

in this case , mysql always places share lock on the rows(c3=2) of lktest table no matter what transaction level it is


I am wondering why the S is needed , why mysql doesn't take advantage of MVCC to avoid lock on lktest ?

many thanks .

Options: ReplyQuote


Subject
Views
Written By
Posted
why UPDATE requires share lock(S) for table joined
1857
November 12, 2014 01:03AM


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.