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

This article will explain in detail how the analysis of Double Write Buffer in MySQL is, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

What is Double Write Buffer?

This is a buffer that exists in memory, and when persisted to disk, this part of the data is written into the tablespace of innodb and consists of a contiguous segment of pages.

The feature of Double Write is exactly the same as that described by the name: write it twice.

Why introduce Double Write Buffer?

Double Write Buffer is introduced to solve the problem of partial page write. The description of this problem quotes the original text of Master Yang.

> > >

The Page Size of InnoDB is generally 16KB, and its data check is also calculated for this 16KB. Writing data to disk is operated in units of Page.

Computer hardware and operating systems, in extreme cases (such as power outages), often do not guarantee the atomicity of this operation.

16K of data, write 4K, the system power outage / os crash occurred, only part of the write is successful, in this case is the partial page write problem.

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.