What is the maximum value of innodb_lock_wait_timeout in mysql?
The maximum possible value is 63000.
Why we need to set innodb_lock_wait_timeout value in mysql?
When you run a time consuming query in mysql l (i.e: update query with joining multiple tables), we might face below errors.
Error Code: 1205 Lock
wait timeout exceeded; try restarting transaction
Error Code: 2013 Lost connection to MySQL server during query
How to set innodb_lock_wait_timeout value in mysql?
Use the below query to increase the timeout value