MySQL - What are storage engines? Explain storage engines supported

What are storage engines? Explain storage engines supported in MySQL

Storage engines are used to manage the database of the MySQL.

Following are the storage engines supported by MySQL:-

1. MyISAM Storage Engine - MySQL default storage engine. Based on ISAM database concept. MyISAM is not transaction safe.
2. InnoDB Storage Engine - A transaction safe storage engine developed by Innobase Oy (an Oracle company).
3. 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.
4. CSV Storage Engine - A simple storage engine storing data as text files using comma-separated values format.
5. MEMORY (HEAP) Storage Engine Storage Engine - A storage engine storing data in computer main memory.
MySQL - Explain how to create a new table using MyISAM storage engine
Explain how to create a new table using MyISAM storage engine - MyISAM Is based on Indexed Sequential Access Method is the default storage engine......
MySQL - Explain how to create a new table using InnoDB Storage Engine
Explain how to create a new table using InnoDB Storage Engine - InnoDB storage engine is transaction safe and developed by Oracle.....
MySQL - Explain how to create a new table using BDB Storage Engine
Explain how to create a new table using BDB Storage Engine - BDB (BerkeleyDB) storage engine is transaction safe and developed by Oracle......
Post your comment