(mysql.info) show-engine

 
 13.5.4.9 `SHOW ENGINE' Syntax
 .............................
 
      SHOW ENGINE ENGINE_NAME {LOGS | STATUS }
 
 `SHOW ENGINE' displays log or status information about storage engines.
 The following statements currently are supported:
 
      SHOW ENGINE BDB LOGS
      SHOW ENGINE INNODB STATUS
 
 `SHOW ENGINE BDB LOGS' displays status information about existing `BDB'
 log files.  It returns the following fields:
 
    * `File'
 
      The full path to the log file.
 
    * `Type'
 
      The log file type (`BDB' for Berkeley DB log files).
 
    * `Status'
 
      The status of the log file (`FREE' if the file can be removed, or
      `IN USE' if the file is needed by the transaction subsystem)
 
 `SHOW ENGINE INNODB STATUS' displays extensive information about the
 state of the `InnoDB' storage engine.
 
 The `InnoDB' Monitors provide additional information about `InnoDB'
 processing. See  innodb-monitor.
 
 Older (and now deprecated) synonyms for these statements are `SHOW
 [BDB] LOGS' and `SHOW INNODB STATUS'.

Info Catalog

(mysql.info) show-databases

(mysql.info) show

(mysql.info) show-engines

automatically generated byinfo2html