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

Q

How To See Which Storage Engines Are Supported in Your MySQL Server? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB

✍: FYIcenter.com

A

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)

2007-05-10, 4510👍, 0💬