Syntax
------

SHOW [STORAGE] ENGINES

Description
-----------

SHOW ENGINES displays status information about the server's storage engines.
This is particularly useful for checking whether a storage engine is
supported, or to see what the default engine is. SHOW TABLE TYPES is a
deprecated synonym.

The information_schema.ENGINES table provides the same information.

Since storage engines are plugins, different information about them is also
shown in the information_schema.PLUGINS table and by the SHOW PLUGINS
statement.

Note that both MySQL's InnoDB and Percona's XtraDB replacement are labeled as
InnoDB. However, if XtraDB is in use, it will be specified in the COMMENT
field. See XtraDB and InnoDB. The same applies to FederatedX.

The output consists of the following columns:

* Engine indicates the engine's name.
* Support indicates whether the engine is installed, and whether it is the
default engine for the current session.
* Comment is a brief description.
* Transactions, XA and Savepoints indicate whether transactions, XA
transactions and transaction savepoints are supported by the engine.

Examples
--------

SHOW ENGINES\G
*************************** 1. row ***************************
   Engine: InnoDB
  Support: DEFAULT
  Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
     XA: YES
 Savepoints: YES
*************************** 2. row ***************************
   Engine: CSV
  Support: YES
  Comment: CSV storage engine
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 3. row ***************************
   Engine: MyISAM
  Support: YES
  Comment: MyISAM storage engine
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 4. row ***************************
   Engine: BLACKHOLE
  Support: YES
  Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 5. row ***************************
   Engine: FEDERATED
  Support: YES
  Comment: FederatedX pluggable storage engine
Transactions: YES
     XA: NO
 Savepoints: YES
*************************** 6. row ***************************
   Engine: MRG_MyISAM
  Support: YES
  Comment: Collection of identical MyISAM tables
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 7. row ***************************
   Engine: ARCHIVE
  Support: YES
  Comment: Archive storage engine
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 8. row ***************************
   Engine: MEMORY
  Support: YES
  Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 9. row ***************************
   Engine: PERFORMANCE_SCHEMA
  Support: YES
  Comment: Performance Schema
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 10. row ***************************
   Engine: Aria
  Support: YES
  Comment: Crash-safe tables with MyISAM heritage
Transactions: NO
     XA: NO
 Savepoints: NO
10 rows in set (0.00 sec)

URL: https://mariadb.com/kb/en/show-engines/