mysql系列之doublewrite buffer 双写缓冲区

参考手册:

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 双写缓冲区

mysql系列之doublewrite buffer 双写缓冲区

上一篇:oracle RAC和RACOneNode之间的转换


下一篇:安装SQL Server 2005过程中遇到无法启动安装失败的解决方法