Re: Maximum Transaction Timeout
Posted by: Adam Nelson ()
Date: October 17, 2016 02:29AM
Yes, the innodb_lock_wait_timeout is higher than the default value. However, my understanding was that this only effected how long a query would wait for a lock not now long the query could hold the lock. Meaning that I could set the innodb_lock_wait_timeout to 100 seconds and do a select for update then sleep for 300 seconds and that timeout would not trigger. However, any other query that attempted to lock that row while the first query was running would time out if the row could not be locked before 100 seconds passed. What I'm looking for is a way to prevent the first query from locking the row for 300 seconds.
|Maximum Transaction Timeout||793||Adam Nelson||10/14/2016 08:12AM|
|Re: Maximum Transaction Timeout||359||Rick James||10/16/2016 03:47PM|
|Re: Maximum Transaction Timeout||495||Adam Nelson||10/17/2016 02:29AM|
|Re: Maximum Transaction Timeout||359||Rick James||10/19/2016 11:28PM|
|Re: Maximum Transaction Timeout||302||Adam Nelson||10/24/2016 02:02PM|
|Re: Maximum Transaction Timeout||377||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.