Three engines in the MySQL database

Source: Internet
Author: User
The following articles mainly introduce the clever use of the three practical application engines supported by the MySQL database. If you are interested in the actual application of the three practical application engines supported by the MySQL database, you can browse the following articles. I hope you will have some gains. ISAM is a well-defined and time-tested data table management method.

The following articles mainly introduce the clever use of the three practical application engines supported by the MySQL database. If you are interested in the actual application of the three practical application engines supported by the MySQL database, you can browse the following articles. I hope you will have some gains. ISAM is a well-defined and time-tested data table management method.

The following articles mainly introduce the clever use of the three practical application engines supported by the MySQL database. If you are interested in the actual application of the three practical application engines supported by the MySQL database, you can browse the following articles. I hope you will have some gains.

ISAM is a well-defined and time-tested data table management method. It is designed to take into account that the number of MySQL database queries is much larger 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 and default database engine of MySQL (the best combination with PHP. 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) MySQL database engines are 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.