mysql版本5.7.22,Innodb_row_lock_current_waits值为持续为400,不变化,查看INNODB_LOCKS、INNODB_LOCK_WAITS表信息都为空,没有持有锁的事务。
1:查看当前的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
2:查看当前锁定的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
3:查看当前等锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
bugid :MySQL Bugs: #71520: Constantly increasing Innodb_row_lock_current_waits value
监控时监控增量变化