MySQL Forums
Forum List  »  InnoDB

Re: DeadLock issue in MultiThreading due to foreign key constraint.
Posted by: Peter Brawley
Date: March 28, 2016 11:51PM

Let's see the SQL that the MySQL server receives from your app when a deadlock occurs.

And let's see the result of ...

Show Engine InnoDB Status;

... when the deadlock occurs.

Have you worked through the item list re deadlocks at http://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html?

Options: ReplyQuote




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.