MySQL Forums :: InnoDB :: 1205 Lock Wait Timeout on heavy SELECT load?


Advanced Search

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
1205 Lock Wait Timeout on heavy SELECT load? 354 Paul Chambre 12/20/2016 12:24PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 186 harry sheng 12/20/2016 12:53PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 250 Paul Chambre 12/22/2016 07:40AM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 170 Peter Brawley 12/22/2016 11:45AM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 181 Paul Chambre 01/12/2017 09:32AM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 124 Peter Brawley 01/12/2017 12:27PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 121 Paul Chambre 02/06/2017 12:13PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 68 Paul Chambre 02/21/2017 09:23AM


Sorry, only registered users may post in this forum.

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.