13.5.4.18. SHOW OPEN TABLES Syntax
SHOW OPEN TABLES [FROM db_name] [LIKE 'pattern']
SHOW OPEN TABLES lists the
non-TEMPORARY tables that are currently
open in the table cache. See Section 7.4.8, “How MySQL Opens and Closes Tables”.
SHOW OPEN TABLES returns the following
fields:
-
Database
The database containing the table.
-
Table
The table name.
-
In_use
The number of times the table currently is in use by
queries. If the count is zero, the table is open, but not
currently being used.
-
Name_locked
Whether the table name is locked. Name locking is used for
operations such as dropping or renaming tables.
