- 13.5.4 SHOW Syntax
- 13.5.4.1 SHOW AUTHORS Syntax
- 13.5.4.2 SHOW CHARACTER SET Syntax
- 13.5.4.3 SHOW COLLATION Syntax
- 13.5.4.4 SHOW COLUMNS Syntax
- 13.5.4.5 SHOW CONTRIBUTORS Syntax
- 13.5.4.6 SHOW CREATE DATABASE Syntax
- 13.5.4.7 SHOW CREATE EVENT
- 13.5.4.8 SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax
- 13.5.4.9 SHOW CREATE TABLE Syntax
- 13.5.4.10 SHOW CREATE VIEW Syntax
- 13.5.4.11 SHOW DATABASES Syntax
- 13.5.4.12 SHOW ENGINE Syntax
- 13.5.4.13 SHOW ENGINES Syntax
- 13.5.4.14 SHOW ERRORS Syntax
- 13.5.4.15 SHOW EVENTS
- 13.5.4.16 SHOW GRANTS Syntax
- 13.5.4.17 SHOW INDEX Syntax
- 13.5.4.18 SHOW INNODB STATUS Syntax
- 13.5.4.19 SHOW OPEN TABLES Syntax
- 13.5.4.20 SHOW PLUGINS Syntax
- 13.5.4.21 SHOW PRIVILEGES Syntax
- 13.5.4.22 SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax
- 13.5.4.23 SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax
- 13.5.4.24 SHOW PROCESSLIST Syntax
- 13.5.4.25 SHOW SCHEDULER STATUS Syntax
- 13.5.4.26 SHOW STATUS Syntax
- 13.5.4.27 SHOW TABLE STATUS Syntax
- 13.5.4.28 SHOW TABLES Syntax
- 13.5.4.29 SHOW TRIGGERS Syntax
- 13.5.4.30 SHOW VARIABLES Syntax
- 13.5.4.31 SHOW WARNINGS Syntax
SHOW OPEN TABLES [FROMdb_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:
-
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. -
Name_lockedWhether the table name is locked. Name locking is used for operations such as dropping or renaming tables.
User Comments
Add your own comment.