You are viewing the archived documentation of TiDB, which no longer receives updates.

View latest LTS version docs

SHOW ENGINES

This statement is used to list all supported storage engines. The syntax is included only for compatibility with MySQL.

Synopsis

ShowEnginesStmt:

ShowEnginesStmt

SHOW ENGINES;

Examples

mysql> SHOW ENGINES; +--------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------+---------+------------------------------------------------------------+--------------+------+------------+ | InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | +--------+---------+------------------------------------------------------------+--------------+------+------------+ 1 row in set (0.00 sec)

MySQL compatibility

  • This statement will always only return InnoDB as the supported engine. Internally, TiDB will typically use TiKV as the storage engine.