MySQL Forums :: InnoDB :: Maximum Transaction Timeout

Advanced Search

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 959 Adam Nelson 10/14/2016 08:12AM
Re: Maximum Transaction Timeout 439 Rick James 10/16/2016 03:47PM
Re: Maximum Transaction Timeout 579 Adam Nelson 10/17/2016 02:29AM
Re: Maximum Transaction Timeout 418 Rick James 10/19/2016 11:28PM
Re: Maximum Transaction Timeout 354 Adam Nelson 10/24/2016 02:02PM
Re: Maximum Transaction Timeout 432 Rick James 10/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.