SHOW OPEN TABLES
You are viewing an old version of this article. View
the current version here.
Syntax
SHOW OPEN TABLES [FROM db_name] [LIKE 'pattern' | WHERE expr]
Description
SHOW OPEN TABLES
lists the non-TEMPORARY
tables that are currently open in the table cache. See
http://dev.mysql.com/doc/refman/5.1/en/table-cache.html.
The FROM
and LIKE
clauses may be used.
The FROM
clause, if present, restricts the tables shown to those present in the
db_name
database.
The LIKE
clause, if
present on its own, indicates which table names to match. The WHERE
and LIKE
clauses can be given to select rows using more general conditions, as discussed in Extended SHOW.
The following information is returned:
Column | Description |
---|---|
Database | Database name. |
Name | Table name. |
In_use | Number of table instances being used. |
Name_locked | 1 if the table is name-locked, e.g. if it is being dropped or renamed, otherwise 0 . |
Example
SHOW OPEN TABLES; +----------+---------------------------+--------+-------------+ | Database | Table | In_use | Name_locked | +----------+---------------------------+--------+-------------+ ... | test | xjson | 0 | 0 | | test | jauthor | 0 | 0 | | test | locks | 1 | 0 | ... +----------+---------------------------+--------+-------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.