Storage engines are software modules used by database management systems to create, read and update data from databases. There are two types of storage engines in MySQL: transactional and non-transactional.
For MySQL 5.5 and later, the default storage engine is InnoDB. Prior to version 5.5, MySQL's default storage engine was MyISAM.
So what are the mysql storage engines?
1. InnoDB
This is the default storage engine for MySQL 5.5 or higher. It provides transaction-safe (ACID-compliant) tables and supports foreign key referential integrity constraints. It supports commit, rollback and emergency recovery functions to protect data. It also supports row-level locking. Its "consistent non-locking reads" improve performance when used in a multi-user environment. It stores data in a clustered index, thereby reducing I/O for primary key-based queries.
2. MyISAM
This storage engine manages non-transactional tables, provides high-speed storage and retrieval, and supports full-text search.
3. MEMORY
Provides tables in memory, formerly known as heaps. It handles all data in RAM for faster access than storing data on disk. Used to quickly find references and other identical data.
4. MERGE
Groups multiple similar MyISAM tables into one table, can handle non-transactional tables, and includes these tables by default.
5. EXAMPLE
You can use this engine to create tables, but you cannot store or retrieve data. The purpose of this is to teach developers how to write new storage engines.
6. ARCHIVE
is used to store large amounts of data and does not support indexes.
7. CSV
Store data in comma-separated value format in a text file.
8. BLACKHOLE
accepts the data to be stored, but always returns empty.
9. FEDERATED
Store data in a remote database.
Related recommendations: "MySQL Tutorial"
This article is an introduction to the mysql storage engine. I hope it will be helpful to friends in need!
The above is the detailed content of What are the mysql storage engines?. For more information, please follow other related articles on the PHP Chinese website!