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

Editor to share with you what are the differences between Mysql search engines, I hope you will learn a lot after reading this article, let's discuss it together!

General MySQL commonly used engines are: ISAM,MyISAM,HEAP,InnoDB and Berkley (BDB).

ISAM:ISAM performs read operations very fast and does not take up a lot of memory and storage resources. The deficiency is that it does not support transactions, foreign keys, and fault tolerance.

MyISAM: on the basis of ISAM, it provides a large number of functions of index and field management that ISAM does not have, and uses a table locking mechanism to optimize multiple concurrent read and write operations, but it is a waste of space and needs to run a command (OPTIMIZE TABLE) to recover the space wasted by the update mechanism.

HEAP: allows temporary tables that reside only in memory, which makes it faster than both ISAM and MyISAM, but the data it manages is also unstable, and if it is not saved before shutting down, all data will be lost. HEAP doesn't waste a lot of space when data is deleted, and HEAP tables are useful when you need practical SELECT expressions to select and manipulate data. But remember, delete the form after you finish using it!

InnoDB and BDB: although much slower than ISAM and MyISAM engines, it includes transaction processing and foreign key support.

After reading this article, I believe you have a certain understanding of the differences between Mysql search engines. If you want to know more about it, welcome to follow the industry information channel. Thank you for your reading!

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.