Re: MySql insert deadlock
Posted by:
Rick James
Date: December 16, 2015 10:21PM
Multiple indexes are involved. This led, in some obscure way, to a deadlock. I suggest you live with deadlocks and simply restart the transaction when it happens.
Note that each secondary index implicitly has a copy of the PRIMARY KEY (id).
Subject
Views
Written By
Posted
4871
December 15, 2015 07:35PM
Re: MySql insert deadlock
1887
December 16, 2015 10:21PM
1720
December 17, 2015 07:14PM
1589
December 18, 2015 05:25PM
1436
December 28, 2015 03:54AM
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.