SHOW ENGINES

Sintassi

SHOW [STORAGE] ENGINES

Spiegazione

SHOW ENGINES mostra informazioni di stato sugli Storage Engine presenti nel server. Questo è particolarmente utile per verificare se uno Storage Engine è supportato, o per sapere qual è lo Storage Engine predefinito. SHOW TABLE TYPES è un sinonimo deprecato.

Esempi

MariaDB [(none)]> SHOW ENGINES;
+------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
+------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears)                                   | NO           | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |
| FEDERATED  | YES     | FederatedX pluggable storage engine                                                              | YES          | NO   | YES        |
| MARIA      | YES     | Crash-safe tables with MyISAM heritage                                                           | YES          | NO   | NO         |
| CSV        | YES     | CSV storage engine                                                                               | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
| ARCHIVE    | YES     | Archive storage engine                                                                           | NO           | NO   | NO         |
| MyISAM     | YES     | Default engine as of MySQL 3.23 with great performance                                           | NO           | NO   | NO         |
| InnoDB     | DEFAULT | XtraDB engine based on InnoDB plugin. Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
| PBXT       | YES     | High performance, multi-versioning transactional engine                                          | YES          | YES  | NO         |
+------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
10 rows in set (0.00 sec)