Take the 2-minute tour ×  Where would I set the maximum time a
query will wait for a lock in MySQL 5.0.68 before timing out?
share|improve this question  3 Answers 3  up vote 5 down vote
accepted  Other timeout settings that are general (not just for
locks, since innodb_lock_wait_timeout only applies to InnoDB row
locks) would be wait_timeout and interactive_timeout (both
default to 28,800)  share|improve this answer +1 for this !!! – 
RolandoMySQLDBA May 17 '11 at 15:46 Thanks chaps - I knew it was
something like that, but MySQL's documentation is useless, I
couldn't find it –  Gaius May 17 '11 at 18:58  By default, it is
50 seconds  Just set innodb_lock_wait_timeout as needed.
share|improve this answer  If you hit the 50-sec InnoDB timeout,
you have a poorly designed application!  That timeout exists to
catch naughty things that cannot be caught any other way.
share|improve this answer One word: Hibernate. –  Gaius May 21
'11 at 6:29  Your Answer