Sign InTry Free

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.
Download PDF
Open Source Ecosystem
TiDB
TiKV
TiFlash
TiSpark
Chaos Mesh
© 2023 PingCAP. All Rights Reserved.