mysql查询死锁表

mysql 8.0 版本跟之前是不一样的，网上到处都是
1

 # 查询死锁表
 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
1
2

# 查询死锁等待时间
 SELECT * FROM information_schema.INNODB_LOCK_waits;
1
2

在8.0版本之前会报

Unknown table 'INNODB_LOCKS' in information_schema

Unknown table 'INNODB_LOCK_WAITS' in information_schema
1
2
3
4

8.0版本之后替换为

 select * from performance_schema.data_locks;

 select * from performance_schema.data_lock_waits;
1
2
3
4