mysql 8.0
select * from performance_schema.data_locks;

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html

• 테이블에 대한 설명

mysql 5.7
select * from information_schema.InnoDB_LOCKS;

#Database
#Query
#lock
#Trouble-Shooting
#InnoDB