SET GLOBAL innodb_lock_wait_timeout = 120; 这将把 innodb_lock_wait_timeout 的值设置为120秒。注意,使用 SET GLOBAL 需要具有适当的权限。 永久修改(在MySQL服务器重启后仍然有效): 要永久修改 innodb_lock_wait_timeout 参数值,你需要编辑MySQL的配置文件(通常是 my.cnf 或my.ini),在 [mysqld] 部...
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) mys...
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) mys...