Re: innodb_lock_wait_timeout

[Perrin Harkins]

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