Re: Lock wait timeout exceeded - MySQL 5.6.15-ndb-7.3.4
Posted by:
Dev Das
Date: December 10, 2014 01:15PM
Thanks for the update Peter,
The app is a multi-threaded application, and based on live traffic independent threads are targeting the same rows. My understanding that will prevent to define "a graceful contention-handling".
This application is not pertaining to a website but a live telecom application, that would require an instant return instead of any "waits".
Would it be possible under MySQL to prioritize the DELETE over UPDATE or vice versa. As that would take care of the deadlocks.
Will it be possible to tweak MySQL to decrease the deadlock frequency?
Subject
Views
Written By
Posted
5124
December 10, 2014 11:51AM
1779
December 10, 2014 12:45PM
Re: Lock wait timeout exceeded - MySQL 5.6.15-ndb-7.3.4
1545
December 10, 2014 01:15PM
1455
December 10, 2014 02:53PM
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.