Name
SHOW ENGINE
Synopsis
SHOW ENGINE engine
{STATUS|MUTEX}
Use this statement to display details of the status of a given storage engine. This statement provides information on table and record locks for transactions, waiting locks, pending requests, buffer statistics and activity, and logs related to the engine.
Currently, the engines that may be given are
INNODB
, NDB
, and
NDBCLUSTER
. These last two keywords are
interchangeable. Prior to version 5.1.12 of MySQL, the option of
BDB
was permitted. In later versions, the BDB
engine is not supported and a warning message is generated when it is
used with this statement. The MUTEX
option
is available only for the InnoDB engine. For the NDB
engine, an empty results set is returned if there are no operations at
the time.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.