Re: Explain deadlock locking the same index

[Rick James]

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