Name
SHOW ENGINES
Synopsis
SHOW [STORAGE] ENGINES
This statement lists the table types or storage engines
available for the version of MySQL running on the server. It states
which are disabled on the server and which are enabled, as well as
which is the default type. It also provides comments on each type. The
STORAGE
keyword is optional
and has no effect on the results. This SQL statement replaces
SHOW TABLE TYPES
, which produced the same results,
but is deprecated. Here is an example of this statement:
SHOW ENGINES \G *************************** 1. row *************************** Engine: ndbcluster Support: DISABLED Comment: Clustered, fault-tolerant tables Transactions: YES XA: NO Savepoints: NO *************************** 2. row *************************** Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tables Transactions: NO XA: NO Savepoints: NO *************************** 3. row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 4. row *************************** Engine: CSV Support: YES Comment: CSV storage engine Transactions: NO XA: NO Savepoints: NO *************************** 5. row *************************** Engine: MEMORY Support: YES Comment: Hash based, stored in memory, useful for temporary tables Transactions: NO XA: NO Savepoints: NO *************************** 6. row *************************** ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.