From: Perrin Harkins Date: October 11 2012 1:54pm Subject: Re: innodb_lock_wait_timeout List-Archive: http://lists.mysql.com/mysql/228369 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 On Thu, Oct 11, 2012 at 7:29 AM, Markus Falb 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