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)
mysql>
设置mysql 事务锁超时时间 innodb_lock_wait_timeout
标签:show glob cte innodb 模式 color 就会 设置mysql 默认参数