首页 > 数据库技术 > 详细

mysql系列之doublewrite buffer 双写缓冲区

时间:2020-08-18 20:16:07      阅读:306      评论:0      收藏:0      [点我收藏+]

参考手册:

The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before writing the pages to their proper positions in the InnoDB data files. If there is an operating system, storage subsystem, or unexpected mysqld process exit in the middle of a page write, InnoDB can find a good copy of the page from the doublewrite buffer during crash recovery.

Although data is written twice, the doublewrite buffer does not require twice as much I/O overhead or twice as many I/O operations. Data is written to the doublewrite buffer in a large sequential chunk, with a single fsync() call to the operating system (except in the case that innodb_flush_method is set to O_DIRECT_NO_FSYNC)

 

 

理解:

技术分享图片

mysql系列之doublewrite buffer 双写缓冲区

原文:https://www.cnblogs.com/mmh760/p/13525221.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!