information_schema(INNODB_TRX | INNODB_LOCKs | INNODB_LOCK_waits)_select * from information_schema.innodb_locks;-CSDN博客

网站介绍:这三条语句 分别 查 事务 、锁、锁等待:SELECT * FROM information_schema.INNODB_TRX;-- 命令是用来查看当前运行的所有事务:SELECT * FROM information_schema.INNODB_LOCKs;-- 命令是用来查看当前出现的锁;SELECT * FROM information_schema.INNODB_L..._select * from information_schema.innodb_locks;