Skip to content

Latest commit

 

History

History
31 lines (23 loc) · 1.06 KB

show-engines.md

File metadata and controls

31 lines (23 loc) · 1.06 KB
Raw
title summary category
SHOW ENGINES | TiDB SQL Statement Reference
An overview of the usage of SHOW ENGINES for the TiDB database.
reference

SHOW ENGINES

This statement is included only for compatibility with MySQL.

Synopsis

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.