MySQL Forums
Forum List  »  InnoDB

Maximum Transaction Timeout
Posted by: Adam Nelson
Date: October 14, 2016 08:12AM

I've got a problem with an InnoDB database and I'm not really sure what setting to adjust to fix it. The problem I'm having is connections come in and start a transaction. Before the commit is issued the remote end then forcefully kills the connection (usually with a kill -9) and the rows just stay locked for hours and hours. I've tried setting the global wait_timeout to 3600 seconds but the rows still stay locked for 20,000+ seconds. Can someone point me in a direction of what I need to change? I don't have control over the remote server and I've already smacked the programmers for doing this. However, I need a DB side solution as they say it will take months to redesign that part while they are blaming the database for their issues.

Options: ReplyQuote


Subject
Views
Written By
Posted
Maximum Transaction Timeout
14753
October 14, 2016 08:12AM
4460
October 16, 2016 03:47PM
4198
October 17, 2016 02:29AM
3191
October 19, 2016 11:28PM
2757
October 24, 2016 02:02PM
2799
October 25, 2016 05:18PM


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.