SHOW ENGINES

List available storage engines. View the support status (default, active, or disabled) and description for each engine.

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)

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}