MySQL Forums
Forum List  »  InnoDB

Re: 1205 Lock Wait Timeout on heavy SELECT load?
Posted by: harry sheng
Date: December 20, 2016 12:53PM

I had this same problem a few days ago. The message on the mysql client was like "lock timeout in 143 seconds".

I simply changed the innodb_lock_wait_timeout to 120 seconds, and it worked for me.

My case was a one-shot update statement, that would take 20 minutes to finish. I just changed that variable for the session.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: 1205 Lock Wait Timeout on heavy SELECT load?
323
December 20, 2016 12:53PM


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.