SHOW OPEN TABLES
SHOW OPEN TABLES lists the
TEMPORARY tables that are currently open
in the table cache. See Section 7.7.2, “How MySQL Opens and Closes Tables”.
SHOW OPEN TABLES returns the
The database containing the table.
The table name.
The number of table locks or lock requests there are for the
table. For example, if one client acquires a lock for a
LOCK TABLE t1 WRITE,
In_use will be 1. If another client
LOCK TABLE t1 WRITE while the
table remains locked, the client will block waiting for the
lock, but the lock request causes
to be 2. If the count is zero, the table is open but not
currently being used.
In_use is also
increased by the
OPEN statement and decreased by
Whether the table name is locked. Name locking is used for operations such as dropping or renaming tables.
Before MySQL 4.0,
TABLES displays information only for open tables in
the default database, and the output format is somewhat
column indicates the table name, and the
Comment column displays all other available
SHOW OPEN TABLES was added in
It is not possible to guarantee the order in which the tables are displayed in this output of this statement from one invokation to the next.