why UPDATE requires share lock(S) for table joined
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 .
Subject
Views
Written By
Posted
why UPDATE requires share lock(S) for table joined
1857
November 12, 2014 01:03AM
1013
November 13, 2014 09:58AM
1063
November 14, 2014 03:07AM
1207
November 14, 2014 01:08PM
1060
November 16, 2014 11:19PM
1035
November 17, 2014 12:07AM
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.