Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Show Storage Engines Supported in MySQL

By: FYIcenter.com

(Continued from previous topic...)

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)

  1. What Are Storage Engines?
  2. How To Create a New Table Using MyISAM Storage Engine?
  3. Where Table Data Is Stored by the MyISAM Storage Engine?
  4. How To Backup Tables by Copying MyISAM Table Files?
  5. How To Restore Tables by Copying MyISAM Table Files?
  6. How To Check and Repair MyISAM Tables?
  7. How To Create a New Table Using the InnoDB Storage Engine?
  8. Where Table Data Is Stored by the InnoDB Storage Engine?
  9. How To Create a New Table Using the BDB Storage Engine?
  10. How To Start mysqld to Support the BDB Storage Engine?
  11. Where Table Data Is Stored by the BDB Storage Engine?
  12. How To Create a New Table Using the CSV Storage Engine?
  13. How To Create a New Table Using the MEMORY Storage Engine?
  14. What Happens to MEMORY Tables When MySQL Server Is Stopped?
  15. How To See Which Storage Engines Are Supported in Your MySQL Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...