設定mysql 事務鎖超時時間 innodb_lock_wait_timeout

Mysql資料庫採用InnoDB模式，預設引數:innodb_lock_wait_timeout設定鎖等待的時間是50s，一旦資料庫鎖超過這個時間就會報錯。

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)