What are the three engines supported by the MySQL database?

The following articles give you easy access to three different types of engines supported by MySQL databases. We all know that the main purpose of ISAM is to define clearly, with time-tested data table management, it is designed to take into account that the number of queries to the MySQL database is much greater than the number of updates. Therefore, ISAM performs read operations quickly, while

The following articles give you easy access to three different types of engines supported by MySQL databases. We all know that the main purpose of ISAM is to define clearly, with time-tested data table management, it is designed to take into account that the number of queries to the MySQL database is much greater than the number of updates. Therefore, ISAM performs read operations quickly, while

The following articles give you easy access to three different types of engines supported by MySQL databases. We all know that the main purpose of ISAM is to define clearly, with time-tested data table management, it is designed to take into account that the number of queries to the MySQL database is much greater than the number of updates.

Therefore, ISAM performs read operations quickly without occupying a large amount of memory and storage resources.

The two major disadvantages of ISAM are that it does not support transaction processing or fault tolerance: If your hard disk crashes, data files cannot be recovered. If you are using ISAM in a key task application, you must always back up all your real-time data and use its copy feature to MySQL (the best combination with PHP) supports such backup applications.

MyISAM

MyISAM is the ISAM extension format of MySQL (the best combination with PHP) and the default MySQL database engine. In addition to providing a large number of functions for indexing and field management not available in ISAM, MyISAM also uses a table lock mechanism to optimize multiple concurrent read/write operations. The cost is that you need to run the optimize table command frequently to restore the space wasted by the update mechanism.

MyISAM also has some useful extensions, such as the MyISAMChk tool used to fix MySQL database files and the MyISAMPack tool used to restore wasted space.

MyISAM emphasizes fast read operations, which may be the main reason why MySQL (the best combination with PHP) is so favored by Web development: in Web development, a large amount of data operations are read operations. Therefore, most VM providers and Internet platform providers (Internet Presence Provider, IPP) only allow the use of MyISAM format.

HEAP

HEAP allows only temporary tables in memory. HEAP is faster than ISAM and MyISAM in the memory, but the data it manages is unstable. If it is not saved before shutdown, all the data will be lost. When a row is deleted, HEAP does not waste much space. HEAP tables are useful when you need to use SELECT expressions to SELECT and manipulate data. Remember to delete the table after the table is used up. Let me repeat it again: do not forget to delete the table after you have used up the table.

InnoDB and Berkley DB

InnoDB and Berkley DB (BDB) database engines are both direct products that make MySQL (the best combination with PHP) flexible technology. This technology is the best combination of MySQL (and PHP) ++ API. When using MySQL (the best combination with PHP), almost every challenge you face comes from the fact that the ISAM and MyISAM database engines do not support transaction processing or foreign keys. Although it is much slower than ISAM and MyISAM engines, InnoDB and BDB include support for transaction processing and Foreign keys, both of which are not available in the first two engines. As mentioned above, if your design requires one or both of these features, you will be forced to use one of the two engines.

The above content is an introduction to the three engines supported by the MySQL database with ease, and I hope you will gain some benefits.