mysql> select * from performance_schema.metadata_locks; +-------------+--------------------+----------------+-------------+-----------------------+---------------------+---------------+-------------+-------------------+-----------------+----------------+ | OBJECT_TYPE | OBJECT_SCHEMA | OBJECT_NAME | COLUMN_NAME | OBJECT_INSTANCE_BEGIN | LOCK_TYPE | LOCK_DURATION | LOCK_STATUS | SOURCE | OWNER_THREAD_ID | OWNER_EVENT_ID | +-------------+--------------------+----------------+-------------+-----------------------+---------------------+---------------+-------------+-------------------+-----------------+----------------+ | TABLE | performance_schema | metadata_locks | NULL | 140446424792192 | SHARED_READ | TRANSACTION | GRANTED | sql_parse.cc:6084 | 2170254 | 10 | | BACKUP LOCK | NULL | NULL | NULL | 140458717974272 | INTENTION_EXCLUSIVE | EXPLICIT | GRANTED | rpl_rli.cc:3334 | 2170467 | 3 | +-------------+--------------------+----------------+-------------+-----------------------+---------------------+---------------+-------------+-------------------+-----------------+----------------+ 2 rows in set (0.00 sec)