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


Advanced Search

Re: 1205 Lock Wait Timeout on heavy SELECT load?
Posted by: Paul Chambre ()
Date: February 06, 2017 12:13PM

We got an admin to pull engine status for us. Everything looks very normal, even when the problem is manifesting.

One other weird thing is that we have the default of 50 seconds for lock timeout, but we're getting 1205s 17 seconds after submitting a query.

Options: ReplyQuote


Subject Views Written By Posted
1205 Lock Wait Timeout on heavy SELECT load? 411 Paul Chambre 12/20/2016 12:24PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 210 harry sheng 12/20/2016 12:53PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 301 Paul Chambre 12/22/2016 07:40AM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 216 Peter Brawley 12/22/2016 11:45AM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 233 Paul Chambre 01/12/2017 09:32AM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 148 Peter Brawley 01/12/2017 12:27PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 170 Paul Chambre 02/06/2017 12:13PM
Re: 1205 Lock Wait Timeout on heavy SELECT load? 93 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.