SELECT straight_join
    dl.THREAD_ID
   , est.SQL_TEXT
   , dl.OBJECT_SCHEMA
   , dl.OBJECT_NAME
   , dl.INDEX_NAME
   , dl.LOCK_TYPE
   , dl.LOCK_MODE
   , dl.LOCK_STATUS
   , dl.LOCK_DATA
 FROM
   performance_schema.data_locks dl inner join performance_schema.events_statements_current est on dl.THREAD_ID = est.THREAD_ID
 ORDER BY est.TIMER_START,dl.OBJECT_INSTANCE_BEGIN;

또는

select * from performance_schema.data_locks;

출처

http://minsql.com/mysql8/B-5-A-data_locks/

https://otrodevym.tistory.com/entry/Mysql-MySql-Lock-%EC%A1%B0%ED%9A%8C-%EB%B0%8F-%ED%95%B4%EC%A0%9C-%EB%B0%A9%EB%B2%95

https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html

https://www.letmecompile.com/mysql-innodb-lock-deadlock/

https://dev.mysql.com/doc/refman/8.0/en/glossary.html#glos_buffer_pool