MySQL Forums
Forum List  »  InnoDB

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
2124
October 14, 2016 08:12AM
873
October 16, 2016 03:47PM
Re: Maximum Transaction Timeout
1024
October 17, 2016 02:29AM
760
October 19, 2016 11:28PM
669
October 24, 2016 02:02PM
699
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.