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)

⇒Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇒⇒MySQL Database Tutorials