IS.LOCKS

mysql> SELECT * FROM INFORMATION_SCHEMA.LOCKS;
+-----------+----------------+---------------+--------------+-------------------+-------------+------------+------------+-----------+--------------------------------------+| THREAD_ID | OBJECT_CATALOG | OBJECT_SCHEMA | OBJECT_TABLE | OBJECT_IDENTIFIER | OBJECT_TYPE | LOCK_STATE | LOCK_LEVEL | LOCK_TYPE | INFO                                 |+-----------+----------------+---------------+--------------+-------------------+-------------+------------+------------+-----------+--------------------------------------+|         1 | NULL           | test          | t1           | t1                | TABLE       | GRANTED    | TABLE      | READ      | Read lock without concurrent inserts ||         2 | NULL           | test          | t2           |                   | TABLE       | GRANTED    | TABLE      | IX        |                                      ||         2 | NULL           | test          | t2           | GEN_CLUST_INDEX   | ROW         | GRANTED    | ROW        | X         |                                      |+-----------+----------------+---------------+--------------+-------------------+-------------+------------+------------+-----------+--------------------------------------+3 rows in set (0.00 sec)