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 in MariaDB and beginning with MySQL 5.1.24.

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.

ColumnDescription
DatabaseDatabase name.
NameTable name.
In_useHow many table locks or lock requests there are for the table.
Name_locked1 if the table is name-locked, e.g. if it is being renamed.

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.