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

What are the main features of InnoDB? In response to this problem, the editor summed up this article today, hoping to help more friends who want to solve this problem to find a more simple and feasible way.

Since MySQL 5.1, the default storage engine has become the InnoDB storage engine, which has changed greatly from the MyISAM,InnoDB storage engine. Its main features are:

Support for transaction operations, with transaction ACID isolation features, the default isolation level is repeatable read (repetable-read), through MVCC (concurrent version control) to achieve. Can solve the problem of dirty reading and unrepeatable reading.

InnoDB supports foreign key operations.

InnoDB default lock granularity row-level lock, concurrent performance is better, deadlock will occur.

Like MyISAM, the InnoDB storage engine also has .frm file storage table structure definitions, but the difference is that InnoDB table data and index data are stored together, both on the leaf node of B+ numbers, while MyISAM table data and index data are separate.

InnoDB has a secure log file that is used to recover data loss problems caused by database crashes or other situations and to ensure data consistency.

InnoDB and MyISAM support the same index types, but the implementation varies greatly due to different file structures.

In terms of add, delete, modify and query performance, if you perform a large number of add, delete and change operations, it is recommended to use the InnoDB storage engine, which deletes rows during deletion operations and does not rebuild the table.

On the main features of InnoDB to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can 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.