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

This article mainly shows you "what storage engine mysql has", which is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "what storage engine does mysql have".

1. InnoDB is the default transactional engine for MySQL.

Mainly for online transaction processing applications.

As the most important storage engine of MySQL, InnoDB has the following external features: transaction, multi-version concurrency control, intention lock, row-level lock and gap lock, supporting foreign keys, supporting cross-engine query, File per Table, supporting compression, crash recovery and hot backup. Its internal features are: Buffer Poll mechanism, Change Buffering mechanism, adaptive hash index, support for dynamic row format and so on.

2. MyISAM has very strong read-only performance.

MyISAM only supports table locks, which is why MyISAM has extremely high read-only performance.

3. A memory-based storage engine designed by Memory for fast access.

It is nearly an order of magnitude faster than MyISAM, but the restart data is lost because there is no persistence.

4. NDB storage engine for cluster architecture.

Use share nothing's cluster architecture, so it has very high availability.

The above is all the content of this article "what is the storage engine of mysql"? thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.