MySQL Forums :: InnoDB :: Maximum Transaction Timeout
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.
|Maximum Transaction Timeout||778||Adam Nelson||10/14/2016 08:12AM|
|Re: Maximum Transaction Timeout||351||Rick James||10/16/2016 03:47PM|
|Re: Maximum Transaction Timeout||485||Adam Nelson||10/17/2016 02:29AM|
|Re: Maximum Transaction Timeout||349||Rick James||10/19/2016 11:28PM|
|Re: Maximum Transaction Timeout||297||Adam Nelson||10/24/2016 02:02PM|
|Re: Maximum Transaction Timeout||374||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.