Re: 1205 Lock Wait Timeout on heavy SELECT load?
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.
Subject
Views
Written By
Posted
2534
December 20, 2016 12:24PM
Re: 1205 Lock Wait Timeout on heavy SELECT load?
1108
December 20, 2016 12:53PM
1110
December 22, 2016 07:40AM
853
December 22, 2016 11:45AM
943
January 12, 2017 09:32AM
847
January 12, 2017 12:27PM
895
February 06, 2017 12:13PM
805
February 21, 2017 09:23AM
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.