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; -- 查看锁等待情况