Major Storage Engines Supported in MySQL in MySQL

Q

What Are Storage Engines in MySQL?

✍: FYIcenter.com

A

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.

 

Tables Using MyISAM Storage Engine in MySQL

Storage Engines: MyISAM, InnoDB and BDB in MySQL

Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇑⇑ MySQL Database Tutorials

2017-09-12, 1575🔥, 0💬