What are the commonly used mysql storage engines
I don't know if you have any knowledge of similar articles about mysql storage engines. Today, I'm here to tell you a little bit about it. If you are interested, let's take a look at the text. I'm sure you'll get something after reading the commonly used mysql storage engines.
For MySQL 5.5 and later, the default storage engine is InnoDB. Prior to version 5.5, the default storage engine for MySQL was MyISAM.
So what are the mysql storage engines?
1. InnoDB
This is the default storage engine for MySQL 5.5 or later. It provides transaction security (ACID compatible) 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-lock read" improves performance when used in a multi-user environment. It stores data in a clustered index, thus reducing the Ihand O of primary key-based queries.
II. MyISAM
The storage engine manages non-transactional tables, provides high-speed storage and retrieval, and supports full-text search.
III. MEMORY
Provides in-memory tables, formerly known as heaps. It processes all the data in RAM for faster access than storing data on disk. Used to quickly find references and other identical data.
IV. MERGE
Grouping multiple similar MyISAM tables into a single table can handle non-transactional tables, which are included by default.
5. EXAMPLE
You can use this engine to create tables, but you cannot store or retrieve data. The goal is to teach developers how to write a new storage engine.
VI. ARCHIVE
Used to store a large amount of data, indexing is not supported.
7. CSV
Stores data in a text file in a comma-separated value format.
VIII. BLACKHOLE
Receives the data to be stored, but always returns empty.
IX. FEDERATED
Store data in a remote database.
What do you think of this article after reading what are the commonly used mysql storage engines? If you want to know more about it, you can continue to follow our industry information section.
