Shulou(Shulou.com)05/31 Report--

This article will explain in detail what MySQL storage engines have, and the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Storage engine of MySQL

The engine used by ARCHIVE for data archiving, the data cannot be modified after being inserted, and indexing is not supported.

When CSV stores data, it uses commas as the delimiter between data items.

BLACKHOLE discards the write operation, which returns empty content.

FEDERATED stores data in a remote database, which is used to access the storage engine of remote tables.

InnoDB transaction engine with foreign key support

The table where MEMORY is placed in memory

MERGE is used to manage a collection of tables made up of multiple MyISAM tables

MyISAM's main non-transactional storage engine

NDBMySQL Cluster dedicated Storage engine

Several storage engines have synonyms for their names. For example, MRG_MyISAM and NDBCLUSTER are synonyms for MERGE and NDB, respectively. The storage engines MEMORY and InnoDB were called HEAP and Innobase respectively in the early days. Although the last two names can still be recognized, they have been abandoned.

What about the MySQL storage engine to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.