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

This article mainly explains "introduction to InnoDB engine in MySQL5.7". The content in the article is simple and clear, and it is easy to learn and understand. Please follow Xiaobian's train of thought to study and learn "introduction to InnoDB engine in MySQL5.7".

InnoDB is a general storage engine with reliability and high performance in MySQL.

Advantages:

1. DML operations follow the ACID model (atomicity, consistency, isolation and persistence), support transactions and support crash-recovery features (when MySQL fails and restarts, for InnoDB tables, uncompleted transactions will be redone through the redo log, and data that has been committed but not written to the data file will be rebuilt from doublewrite buffer) to protect the data.

2. InnoDB buffer pool caches the accessed table and index information, and the frequently used data is read directly from memory.

3. Inserts,update,deletes operations are optimized by a mechanism called change buffering. Not only does InnoDB allow multiple concurrent reads and writes to the same table, it also caches changed data and optimizes disk Imando O.

4. When a database runs long queries on large tables and repeatedly accesses peers of the same table, a feature called Adaptive Hash Index makes these queries faster, just as data is queried from a hash table.

5. Tables and related indexes can be compressed.

6. Indexes can be created and deleted with little impact on performance and availability.

7. You can quickly TRUNCATE a file_per_table tablespace, freeing up disk space for use by the operating system without releasing the system tablespace that can only be reused by InnoDB.

8. Support row-level locking and consistent reading to improve multi-user concurrency and performance.

9. Support primary keys to improve query performance.

10. In order to maintain the integrity of data, InnoDB also supports foreign keys.

11. You can freely combine InnoDB tables with tables from other MySQL storage engines. For example, in a SQL, you can associate an InnoDB table with a memory table.

12. When dealing with a large amount of data, InnoDB engine can effectively exert CPU efficiency and improve performance.

Thank you for your reading, the above is the content of "introduction to InnoDB engine in MySQL5.7". After the study of this article, I believe you have a deeper understanding of the introduction of InnoDB engine in MySQL5.7, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.