MySQL Forums
Forum List  »  InnoDB

Re: Does delete statements with primary key needs share lock and X lock ?
Posted by: Andrew Simkovsky
Date: August 30, 2013 09:35AM

If both transactions are attempting to perform a DML operation on the same row, its a first-come, first-serve basis. Whichever one gets there first will get the exclusive lock on the row, and the second one has to wait until the first one releases it.

Andrew Simkovsky
More mysql forums (and other databases):
http://www.dbtekpro.com/forums
Brand new! Just post!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Does delete statements with primary key needs share lock and X lock ?
677
August 30, 2013 09:35AM


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.