List:General Discussion« Previous MessageNext Message »
From:Perrin Harkins Date:October 11 2012 1:54pm
Subject:Re: innodb_lock_wait_timeout
View as plain text  
On Thu, Oct 11, 2012 at 7:29 AM, Markus Falb <markus.falb@stripped> wrote:
> Should I raise innodb_lock_wait_timeout? What are the disadvantages?

The disadvantage is that if the locks still don't clear by the time
the timeout is reached, you're just making the other process wait
longer before failing.

> Should I retry application side?

Most people don't do that, but you could.

The best solution is to find out what's holding the locks and make it
stop holding them for so long or use a narrower lock.  I usually find
these are a result of a transaction or an "INSERT...SELECT" that's
running too long.

- Perrin
innodb_lock_wait_timeoutMarkus Falb11 Oct
  • Re: innodb_lock_wait_timeoutJohan De Meersman11 Oct
    • Re: innodb_lock_wait_timeoutAndrĂ©s Tello11 Oct
      • Re: innodb_lock_wait_timeoutAkshay Suryavanshi11 Oct
        • RE: innodb_lock_wait_timeoutRick James11 Oct
    • Re: innodb_lock_wait_timeoutMarkus Falb12 Oct
      • Re: innodb_lock_wait_timeoutReindl Harald12 Oct
        • Re: innodb_lock_wait_timeoutMichael Dykman12 Oct
      • Re: innodb_lock_wait_timeoutJohan De Meersman15 Oct
  • Re: innodb_lock_wait_timeoutPerrin Harkins11 Oct
Re: innodb_lock_wait_timeoutJohan De Meersman15 Oct