SHOW ENGINES
This statement is used to list all supported storage engines. The syntax is included only for compatibility with MySQL.
Synopsis
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.