概述【详解mysql数据库double write原理、性能影响及相关参数】今天主要介绍下MySQL一个崩溃恢复很重要的特性--double write.
The doublewrite buffer is a storage area located in the system tablespace where InnoDB writes pages that are flushed from the InnoDB buffer pool, before the pages are written to their proper positions in the data file. Only after flushing and writing pages to the doublewrite buffer, does InnoDB write pages to their proper positions. If there is an operating system, storage subsystem, or mysqld process crash in the middle of a page write, InnoDB can later find a good copy of the page from the doublewrite buffer during crash recovery.
推荐阅读
- mysql数据库基本增删改查操作总结
- Spring框架详解
- 详解十大灾难 人为什么有大灾大难
- Linux日志切割神器logroate原理介绍和配置详解
- 利用shell脚本运行MYSQL语句，并在mysql中执行shell脚本
- CentOS 系统各个目录的作用详解
- 一份非常完整、详细的MySQL规范
- MySQL和PostgreSQL在多表连接算法上的差异
- 当你的Mssql数据库被黑客攻击时，快来看看如何抓住黑客
- 中秋节之由来详解