MYSQL 设立 FOR UPDATE 超时时间
MYSQL 设置 FOR UPDATE 超时时间
show global variables like "%timeout%";
set global innodb_lock_wait_timeout = 10;
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;