Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.