1、查看正在执行的事务
select * from information_schema.INNODB_TRX;
2、查看正在锁的事务
select * from information_schema.INNODB_LOCKS;
3、查看等待锁的事务
select * from information_schema.INNODB_LOCK_WAITS;
4、查询全局等待事务锁超时时间
show global variables like 'innodb_lock_wait_timeout';
5、设置全局等待事务锁超时时间
set global innodb_lock_wait_timeout=100;
6、查询当前会话事务锁超时时间
show variables like 'innodb_lock_wait_timeout';
7、kill锁住的事务
查看当前的mysql连接
show processlist;
kill thread_id;
kill 66402982;
