SHOW OPEN TABLES
SHOW OPEN TABLES [FROM db_name] [LIKE 'pattern' | WHERE expr]
SHOW OPEN TABLES lists the non-
tables that are currently open in the table cache. See
LIKE clauses may be used in
MariaDB and beginning with MySQL 5.1.24.
clause, if present, restricts the tables shown to those present in the
LIKE clause, if
present on its own, indicates which table names to match. The
LIKE clauses can be given to select rows using more general conditions, as discussed in Extended SHOW.
|In_use||How many table locks or lock requests there are for the table.|
|Name_locked||1 if the table is name-locked, e.g. if it is being renamed.|