How to use engine features? Summarize engine feature example usage

Preface As a mature cross-platform database engine, InnoDB implements a set of efficient and easy-to-use IO interfaces, including synchronous asynchronous IO, IO merging, etc. This article briefly introduces its internal implementation. The main code is concentrated in the file os0file.cc. The analysis in this article is based on MySQL 5.6, CentOS 6, and gcc 4.8 by default. Information on other versions will be pointed out separately. Basic knowledge WAL technology: log-first technology, basically all databases use this technology. To put it simply, when a data block needs to be written, the database front-end thread first writes the corresponding log (batch sequential writing) to the disk, and then tells the client that the operation is successful. As for the actual writing of the data block (discrete random writing) Then put it in the background IO thread. Using this technology, although there is one more disk write operation, because the log is written in batches and sequentially, the efficiency is very high, so the client can get the response quickly. In addition, if the database crashes before the actual data blocks are written to disk, the database can use the log for crash recovery without causing data loss when restarting. Data pre-reading: Data blocks B and C "adjacent" to data block A are read in A

1. MySQL · Engine Features · Detailed introduction of InnoDB IO subsystem

Introduction: As a mature cross-platform database engine, InnoDB implements a set of efficient Easy-to-use IO interface, including synchronous and asynchronous IO, IO merging, etc. This article briefly introduces its internal implementation. The main code is concentrated in the file os0file.cc. The analysis in this article is based on MySQL 5.6, CentOS 6, and gcc 4.8 by default. Information on other versions will be pointed out separately.

2. Sqlserver2008 data engine features spatial data pre-experience

Introduction: Pre-emptive experience of SqlServer 2008 spatial data. This article will Demonstrates how to obtain basic geographical information data, and how to import it into SqlServer2008 with the help of foreigners' tools, and then observe the query results through the query tool. Looking forward to the release of the official version of Sqlserver 2008. 1. Install sqlserver2008. Just install the data engine. Next

3. Mysql storage engine feature summary_MySQL

Introduction: This article mainly introduces the Mysql storage engine Feature summary, and also summarizes the features of the two most commonly used storage engines, as well as the applicable environments of each engine. Friends in need can refer to

4. Three types of MySQL databases Comparison of Common Storage Engine Features_MySQL

Introduction: Data in MySQL is stored in files (or memory) using a variety of different technologies. Each of these technologies The technologies all use different storage mechanisms, indexing techniques, locking levels and ultimately offer a wide range of different functionality and capabilities. Combining these different technologies and supporting related functions in MySQL

The above is the detailed content of How to use engine features? Summarize engine feature example usage. For more information, please follow other related articles on the PHP Chinese website!