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

Editor to share with you what the use of MySQL database engine, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Database engine is the core service for storing, processing and protecting data. The database engine can be used to control access and process transactions quickly to meet the requirements of most applications in the enterprise that need to process large amounts of data. Use the database engine to create a relational database for online transaction processing or online analytical processing data. This includes creating tables to store data and database objects (such as indexes, views, and stored procedures) that are used to view, manage, and secure data.

Database engine task

In the database engine documentation, the order of topics follows the main order of tasks used to implement systems that use the database engine for data storage.

Design and create a database to hold the relationships or XML documents required by the system

Implement the system to access and change the data stored in the database. This includes applications that implement Web sites or work with data, as well as processes that generate and use SQLServer tools and utilities to work with data.

Deploy the implemented system for the unit or customer

Provide daily management support to optimize database performance

MySQL Database engine categories

The database engine you can use depends on how mysql is compiled during installation. To add a new engine, you must recompile MYSQL. By default, MYSQL supports three engines: ISAM, MYISAM, and HEAP. The other two types, INNODB and BERKLEY (BDB), are also often available.

ISAM

ISAM is a well-defined and time-tested data table management method. When it is designed, it takes into account that the number of times the database is queried is much greater than the number of updates. As a result, ISAM performs read operations very quickly and does not consume a lot of memory and storage resources. The two main drawbacks of ISAM are that it does not support transactions and is not fault tolerant: if your hard drive crashes, the data files cannot be recovered. If you are using ISAM in mission-critical applications, you must back up all your real-time data frequently, and MYSQL can support such backup applications through its replication feature.

MYISAM

MYISAM is MYSQL's ISAM extension format and default database engine. In addition to providing indexing and field management functions that are not available in ISAM, MYISAM also uses a table locking mechanism to optimize multiple concurrent read and write operations. The cost is that you need to run the OPTIMIZETABLE command frequently to recover the space wasted by the update mechanism. MYISAM also has some useful extensions, such as the MYISAMCHK tool to repair database files and the MYISAMPACK tool to recover wasted space.

MYISAM emphasizes fast read operations, which is probably the main reason why MYSQL is so popular with WEB developers: a lot of the data operations you do in WEB development are read operations. Therefore, most web hosting providers and INTERNET platform providers are only allowed to use the MYISAM format.

HEAP

HEAP allows temporary tables that reside only in memory. Staying in memory makes HEAP faster than both ISAM and MYISAM, but the data it manages is unstable, and if it is not saved before shutting down, all data will be lost. HEAP does not waste a lot of space when the data row is deleted. HEAP tables are useful when you need to use SELECT expressions to select and manipulate data. Remember to delete the table after you have finished using it.

INNODB and BERKLEYDB

Both INNODB and the BERKLEYDB (BDB) database engine are direct products of the technology that makes MYSQL flexible, which is MYSQL++API. Almost every challenge you face when using MYSQL stems from the fact that the ISAM and MYISAM database engines do not support transactions or foreign keys. Although much slower than the ISAM and MYISAM engines, INNODB and BDB include support for transactions and foreign keys that the first two engines do not have. As mentioned earlier, if your design requires one or both of these features, you will be forced to use one of the last two engines.

The above is all the content of the article "what is the use of MySQL database engine". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.