MySQL Forums :: InnoDB :: Maximum Transaction Timeout

Advanced Search

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.

Options: ReplyQuote

Subject Views Written By Posted
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.