Home >> FAQs/Tutorials >> MySQL Tutorials >> Index

MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB

By: FYIcenter.com

Part:   1  2  3  4  5  6  

(Continued from previous part...)

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

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)

Part:   1  2  3  4  5  6