On Thu, Oct 11, 2012 at 7:29 AM, Markus Falb <markus.f...@fasel.at> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql