How to set the transaction lock timeout in mysql
It is believed that many inexperienced people don't know what to do about how to set the transaction lock timeout in mysql. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.
The Mysql database adopts InnoDB mode. The default parameter: innodb_lock_wait_timeout sets the waiting time for the lock to be 50s. Once the database lock exceeds this time, an error will be reported.
Mysql > SHOW GLOBAL VARIABLES LIKE 'innodb_lock_wait_timeout'
+-+ +
| | Variable_name | Value |
+-+ +
| | innodb_lock_wait_timeout | 50 | |
+-+ +
1 row in set (0.00 sec)
Mysql > SET GLOBAL innodb_lock_wait_timeout=120
Query OK, 0 rows affected (0.00 sec)
Mysql > SHOW GLOBAL VARIABLES LIKE 'innodb_lock_wait_timeout'
+-+ +
| | Variable_name | Value |
+-+ +
| | innodb_lock_wait_timeout | 120 | |
+-+ +
1 row in set (0.00 sec)
After reading the above, have you mastered how to set the transaction lock timeout in mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!
