Set "lock wait timeout" in MySQL

Question

Where would I set the maximum time a query will wait for a lock in MySQL 5.0.68 before timing out?

RolandoMySQLDBA · Answer 1 · 2013-01-30T16:08:51.097

15

By default, it is 50 seconds

Just set innodb_lock_wait_timeout as needed.

edited Jan 30 '13 at 16:08

answered May 17 '11 at 12:56

RolandoMySQLDBA

185,223
33
326
536

score 9 · Accepted Answer · answered May 17 '11 at 13:04

9

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)

answered May 17 '11 at 13:04

Derek Downey

23,568
11
79
104

score 4 · Answer 3 · answered May 20 '11 at 21:13

4

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.

answered May 20 '11 at 21:13

Rick James

80,479
5
52
119

Set "lock wait timeout" in MySQL

3 Answers3