Skip to content

Latest commit

 

History

History
34 lines (24 loc) · 1.17 KB

sql-statement-show-engines.md

File metadata and controls

34 lines (24 loc) · 1.17 KB
title summary
SHOW ENGINES | TiDB SQL Statement Reference
An overview of the usage of SHOW ENGINES for the TiDB database.

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.