How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL?

If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below:

mysql> SHOW ENGINES;
+------------+---------+-----------------------------------
| Engine     | Support | Comment
+------------+---------+-----------------------------------
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 
                            with great performance
| MEMORY     | YES     | Hash based, stored in memory, 
                            useful for temporary tables
| InnoDB     | YES     | Supports transactions, row-level 
                            locking, and foreign keys
| BerkeleyDB | YES     | Supports transactions and page-
                            level locking
| BLACKHOLE  | YES     | /dev/null storage engine (anything
                            you write to it disappears)
| EXAMPLE    | YES     | Example storage engine
| ARCHIVE    | YES     | Archive storage engine
| CSV        | NO      | CSV storage engine
| ndbcluster | NO      | Clustered, fault-tolerant, memory-
                            based tables
| FEDERATED  | YES     | Federated MySQL storage engine
| MRG_MYISAM | YES     | Collection of identical MyISAM 
                            tables
| ISAM       | NO      | Obsolete storage engine
+------------+---------+-----------------------------------
12 rows in set (0.00 sec)

⇒ Transaction Management: Commit or Rollback in MySQL

⇐ Data Removed in MEMORY Tables in MySQL

⇑ Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇑⇑ MySQL Database Tutorials