- Documentation Library
- Table of Contents
- MySQL 5.5 Manual
- MySQL 5.4 Manual
- MySQL 5.1 Manual
- MySQL 5.0 Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW BINARY LOGS Syntax
- 12.4.5.2 SHOW BINLOG EVENTS Syntax
- 12.4.5.3 SHOW CHARACTER SET Syntax
- 12.4.5.4 SHOW COLLATION Syntax
- 12.4.5.5 SHOW COLUMNS Syntax
- 12.4.5.6 SHOW CREATE DATABASE Syntax
- 12.4.5.7 SHOW CREATE TABLE Syntax
- 12.4.5.8 SHOW DATABASES Syntax
- 12.4.5.9 SHOW ENGINE Syntax
- 12.4.5.10 SHOW ENGINES Syntax
- 12.4.5.11 SHOW ERRORS Syntax
- 12.4.5.12 SHOW GRANTS Syntax
- 12.4.5.13 SHOW INDEX Syntax
- 12.4.5.14 SHOW INNODB STATUS Syntax
- 12.4.5.15 SHOW LOGS Syntax
- 12.4.5.16 SHOW MASTER STATUS Syntax
- 12.4.5.17 SHOW OPEN TABLES Syntax
- 12.4.5.18 SHOW PRIVILEGES Syntax
- 12.4.5.19 SHOW PROCESSLIST Syntax
- 12.4.5.20 SHOW SLAVE HOSTS Syntax
- 12.4.5.21 SHOW SLAVE STATUS Syntax
- 12.4.5.22 SHOW STATUS Syntax
- 12.4.5.23 SHOW TABLE STATUS Syntax
- 12.4.5.24 SHOW TABLES Syntax
- 12.4.5.25 SHOW VARIABLES Syntax
- 12.4.5.26 SHOW WARNINGS Syntax
SHOW OPEN TABLES
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 columns:
-
DatabaseThe database containing the table.
-
TableThe table name.
-
In_useThe number of table locks or lock requests there are for the table. For example, if one client acquires a lock for a table using
LOCK TABLE t1 WRITE,In_usewill be 1. If another client issuesLOCK TABLE t1 WRITEwhile the table remains locked, the client will block waiting for the lock, but the lock request causesIn_useto be 2. If the count is zero, the table is open but not currently being used.In_useis also increased by theHANDLER ... OPENstatement and decreased byHANDLER ... CLOSE. -
Name_lockedWhether the table name is locked. Name locking is used for operations such as dropping or renaming tables.
Before MySQL 4.0, SHOW OPEN
TABLES displays information only for open tables in
the default database, and the output format is somewhat
different. The
Open_tables_in_
column indicates the table name, and the
db_nameComment column displays all other available
information.
SHOW OPEN TABLES was added in
MySQL 3.23.33.
Note
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.
User Comments
Add your own comment.