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)

Commenti

Sto caricando i commenti......
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.