Where would I set the maximum time a query will wait for a lock in MySQL 5.0.68 before timing out?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
||||
|
|
|
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) |
|||||
|
|
By default, it is 50 seconds Just set innodb_lock_wait_timeout as needed. |
||||
|
|
|
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. |
|||
|
|
