查询事务

SELECT * FROM information_schema.INNODB_TRX;

查询正在锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;

查询等待锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

查询进程

show PROCESSLIST;

查询是否锁表

show OPEN TABLES where In_use > 0;