MySQL Forums
Forum List  »  InnoDB

Re: Explain deadlock locking the same index
Posted by: Rick James
Date: October 30, 2009 08:40PM

Could it be that they hit the same set of rows? Or at least one row in common?


I suspect you could get in trouble running these simultaneously:

DELETE FROM tbl WHERE id IN (11,22);

DELETE FROM tbl WHERE id IN (22,11);

Or these:
BEGIN
DELETE FROM tbl WHERE id = 11;
DELETE FROM tbl WHERE id = 22;
COMMIT

BEGIN
DELETE FROM tbl WHERE id = 22;
DELETE FROM tbl WHERE id = 11;
COMMIT

Options: ReplyQuote


Subject
Views
Written By
Posted
2671
October 29, 2009 08:53AM
Re: Explain deadlock locking the same index
1527
October 30, 2009 08:40PM


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.