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

This article will explain in detail what the commonly used MySQL storage engine is. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The most commonly used storage engines are:

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. Note that you can easily change the default storage engine of the MySQL server by changing the STORAGE_ENGINE configuration variable.

InnoDB: for transactional applications, with many features, including ACID transaction support. (row-level locks are provided)

BDB: a transaction engine that replaces 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 found quickly.

Merge: allows MySQL DBA or developers to logically group a series of equivalent MyISAM tables together and reference them as one object. Ideal for VLDB environments such as data warehousing.

Archive: provides the perfect solution for the storage and retrieval of a large number of rarely referenced historical, archiving, or security audit information.

Federated: the ability to link multiple separate MySQL servers to create a logical database from multiple physical servers. Ideal for distributed or data Mart environments.

Cluster/NDB:MySQL 's clustered database engine is especially suitable for applications with high-performance lookup requirements, which also require the highest uptime and availability.

Other: other storage engines include CSV, which refers to files used as database tables separated by commas, Blackhole, which temporarily prohibits application input to the database, and the Example engine, which helps to quickly create a custom plug-in storage engine.

This is the end of the article on "what is the commonly used MySQL storage engine". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please 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.