SELECT * FROM information_schema.INNODB_TRX; -- 查看事务进程
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; -- 查看锁
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; -- 查看锁等待情况
SELECT * FROM information_schema.INNODB_TRX; -- 查看事务进程
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; -- 查看锁
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; -- 查看锁等待情况