Mysql Storage engine Records

MyISAM

The default database engine before Mysql5.5 is the most commonly used. Has high insert and query speed, but does not support transactions

InnoDB

The preferred engine for transactional database, which supports ACID transactions and row-level locking. MySQL 5.5 has become the default database engine since.

BDB is derived from Berkeley DB, an alternative to transactional databases that supports other transaction features such as COMMIT and ROLLBACK

Memory

All data is stored in memory in the storage engine, with high insertion, update and query efficiency. But it takes up memory space proportional to the amount of data. And its contents will be lost when Mysql is restarted

Merge

Combine a certain number of MyISAM tables into a whole, which is useful for very large-scale data storage.

Archive

It is very suitable for storing large amounts of independent data as historical records. Because they are not often read. Archive has efficient insertion speed, but its support for queries is relatively poor.

Federated

Combine different Mysql servers to logically form a complete database. Very suitable for distributed applications

Cluster/NDB

A highly redundant storage engine that uses multiple data machines to jointly provide services to improve overall performance and security. Suitable for applications with large amount of data, high security and performance requirements

CSV

A storage engine that logically splits data by commas. It creates a .CSV file for each data table in the database subdirectory. This is a normal text file that takes up one line of text per line of data. The CSV storage engine does not support indexing.

BlackHole

Black hole engine, any data written will disappear. It is generally used to record the relay of binlog replication.

EXAMPLE

The storage engine is a stub engine that does nothing. It is intended as an example in the MySQL source code to demonstrate how to start writing a new storage engine. Again, its main interest is for developers. Indexing is not supported by the EXAMPLE storage engine.