SHOW ENGINES

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

Synopsis

ShowEnginesStmt
SHOWENGINESShowLikeOrWhere
ShowLikeOrWhere
LIKESimpleExprWHEREExpression

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.