13.5.4.10. 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
Section 14.2.11.1, “SHOW ENGINE INNODB STATUS and the InnoDB Monitors”.
Older (and now deprecated) synonyms for these statements are
SHOW [BDB] LOGS and SHOW INNODB
STATUS.
