(mysql.info) show-open-tables

 
 13.5.4.16 `SHOW OPEN TABLES' Syntax
 ...................................
 
      SHOW OPEN TABLES [FROM DB_NAME] [LIKE 'PATTERN']
 
 `SHOW OPEN TABLES' lists the non-`TEMPORARY' tables that are currently
 open in the table cache. See  table-cache.
 
 `SHOW OPEN TABLES' returns the following fields:
 
    * `Database'
 
      The database containing the table.
 
    * `Table'
 
      The table name.
 
    * `In_use'
 
      The number of times the table currently is in use by queries. If
      the count is zero, the table is open, but not currently being used.
 
    * `Name_locked'
 
      Whether the table name is locked. Name locking is used for
      operations such as dropping or renaming tables.
 
 The `FROM' and `LIKE' clauses may be used as of MySQL 5.0.12.

Info Catalog

(mysql.info) show-logs

(mysql.info) show

(mysql.info) show-privileges

automatically generated byinfo2html