Re: Understanding Deadlocks in MySQL
Are these transactions coded to retry in the event of deadlock?
What MySQL version is this?
Is the InnoDB Lock Monitor on?
What does information_schema.innodb_locks (performance_schema since 5.7) show?
In the 2nd query, is the app code that generates multiple ...set x=ifnull(some_input_value,x)... sql clauses inciting reads and therefore S locks? Did you try changing the code to something like (pseudocode) ...
if new value is not null then add a set clause for this value
Edited 1 time(s). Last edit at 11/22/2019 02:31PM by Peter Brawley.
Subject
Written By
Posted
November 22, 2019 03:30AM
Re: Understanding Deadlocks in MySQL
November 22, 2019 02:26PM
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.