Commonly used MySQL storage engines [Summary]

This article mainly introduces to you what are the most commonly used MySQL storage engines? You can also refer to MySQL Video Tutorial or MySQL Manual to learn more.

The following storage engines are the most commonly used:

MyISAM: The default MySQL plug-in storage engine, which is one of the most commonly used storage engines in Web, data warehousing and other application environments. one. Note that the default storage engine of the MySQL server can be easily changed by changing the STORAGE_ENGINE configuration variable.

　InnoDB: For transaction processing applications, has many features, including ACID transaction support. (Provides row-level locks)

BDB: A transaction engine that can replace InnoDB and supports COMMIT, ROLLBACK and other transaction features.

Memory: Saves all data in RAM, providing extremely fast access in environments where references and other similar data need to be quickly found.

Merge: Allows the MySQL DBA or developer to logically combine a series of equivalent MyISAM tables and reference them as 1 object. It is very suitable for VLDB environments such as data warehousing.

Archive: Provides the perfect solution for the storage and retrieval of large amounts of rarely referenced historical, archival, or security audit information.

Federated: Able to link multiple separate MySQL servers to create a logical database from multiple physical servers. Very suitable for distributed environments or data mart environments.

Cluster/NDB: MySQL’s clustered database engine is particularly suitable for applications with high-performance search requirements that also require the highest uptime and availability.

Other: Other storage engines include CSV (comma-separated references to files used as database tables), Blackhole (used to temporarily disable application input to the database), and the Example engine (for rapid creation of A custom plug-in storage engine helps).

So this article is an introduction to the commonly used MySQL storage engine. I hope to be helpful!

The above is the detailed content of Commonly used MySQL storage engines [Summary]. For more information, please follow other related articles on the PHP Chinese website!