Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Major Storage Engines Supported in MySQL

By: FYIcenter.com

(Continued from previous topic...)

What Are Storage Engines?

Storage engines are programs that are integrated into MySQL database management system to manage data tables. MySQL 5.0 supports the following major storage engines:

  • MyISAM Storage Engine - MySQL default storage engine. Based on ISAM database concept. MyISAM is not transaction safe.
  • InnoDB Storage Engine - A transaction safe storage engine developed by Innobase Oy (an Oracle company).
  • BDB (BerkeleyDB) Storage Engine - A transaction safe storage engine originally developed at U.C. Berkeley. Sleepycat Software, Inc. was created in 1996 to continue BDB development. Sleepycat is an Oracle company now.
  • CSV Storage Engine - A simple storage engine storing data as text files using comma-separated values format.
  • MEMORY (HEAP) Storage Engine Storage Engine - A storage engine storing data in computer main memory.

(Continued on next topic...)

  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...