mysql> select thread_id, object_name, index_name, engine_lock_id, lock_type, lock_mode, lock_data from performance_schema.data_locks; +-----------+-------------+------------+-------------------------------------+-----------+--------------------+------------------------+ | thread_id | object_name | index_name | engine_lock_id | lock_type | lock_mode | lock_data | +-----------+-------------+------------+-------------------------------------+-----------+--------------------+------------------------+ | 10812 | foo | NULL | 2143972978080:1199:2143938777368 | TABLE | IX | NULL | | 10812 | foo | bar_id_idx | 2143972978080:142:5:1:2143938774584 | RECORD | X,INSERT_INTENTION | supremum pseudo-record | | 10793 | foo | NULL | 2143972977232:1199:2143938764184 | TABLE | IX | NULL | | 10793 | foo | PRIMARY | 2143972977232:142:4:2:2143938761400 | RECORD | X,REC_NOT_GAP | 1 | | 10793 | foo | bar_id_idx | 2143972977232:142:5:2:2143938761744 | RECORD | X,REC_NOT_GAP | 1, 1 | | 10793 | foo | bar_id_idx | 2143972977232:142:5:2:2143938762088 | RECORD | S,GAP | 1, 1 | | 10793 | foo | bar_id_idx | 2143972977232:142:5:3:2143938762088 | RECORD | S,GAP | 1, 2 | | 10793 | foo | bar_id_idx | 2143972977232:142:5:1:2143938762432 | RECORD | S | supremum pseudo-record | +-----------+-------------+------------+-------------------------------------+-----------+--------------------+------------------------+ 8 rows in set (0.00 sec) mysql> select requesting_engine_lock_id, blocking_engine_lock_id from performance_schema.data_lock_waits; +-------------------------------------+-------------------------------------+ | requesting_engine_lock_id | blocking_engine_lock_id | +-------------------------------------+-------------------------------------+ | 2143972978080:142:5:1:2143938774584 | 2143972977232:142:5:1:2143938762432 | +-------------------------------------+-------------------------------------+ 1 row in set (0.00 sec)