mysql查询死锁表 Unknown table ‘INNODB_LOCKS‘ in information_schema

https://blog.csdn.net/zhougubei/article/details/121329428?spm=1001.2101.3001.6650.4&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-4-121329428-blog-81865690.pc_relevant_default&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-4-121329428-blog-81865690.pc_relevant_default&utm_relevant_index=9

mysql查询死锁表
mysql 8.0 版本跟之前是不一样的，网上到处都是

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

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

在8.0版本之前会报

Unknown table 'INNODB_LOCKS' in information_schema

Unknown table 'INNODB_LOCK_WAITS' in information_schema

8.0版本之后替换为

 select * from performance_schema.data_locks;

 select * from performance_schema.data_lock_waits;