Where would I set the maximum time a query will wait for a lock in MySQL 5.0.68 before timing out?
13
6
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
6
By default, it is 50 seconds
Just set innodb_lock_wait_timeout as needed.
answered May 17 '11 at 12:56
1
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
-
1Or due to errors, I've an extremely busy mysql and mariadb server and deadlocks are a normal thing ot happen all the time. Even if "impossible". If you have a hundred million rows and ten thousands of sql command every second you'll find every sort of bug in mysql (crashes) as well as deadlocks of various sorts. – John Dec 19 '18 at 19:15
