MySQL InnoDB中的WAL协议浅谈[转]
2023-09-11 14:21:36 时间
- Any changes to a page is first done to the in-memory copy of the page. The page that is modified in memory and not yet flushed to disk is marked as the dirty page in memory.
- An associated redo log is generated in memory, in the local mini transaction (mtr) buffer. This will then be transferred to the global in-memory redo log buffer.
- The redo log record is written from the redo log buffer in memory to the redo log file on disk. This is subsequently flushed. These two steps are considered separate - writing to the redo log file and flushing the redo log file to the disk. This is to account for the file buffering done by the operating system.
- The dirty page is flushed from memory to disk at some later point of time as part of the checkpointing operation.
The order of these steps are important. The redo log record of a change must be flushed to disk before flushing the corresponding dirty page to the disk. This is the concept of write-ahead logging (WAL).
相关文章
- Mysql加锁过程详解(2)-关于mysql 幻读理解
- MySQL无法启动报 Error: could not open single-table tablespace file ./mysql/innodb_table_sta
- 【MySQL进阶-09】深入理解mysql执行的底层机制
- 【MySQL进阶-10】mysql语句的执行流程以及集群的高可用
- MySQL 授权远程登录(Ubuntu 环境)
- MySQL数据库中随机获取一条或多条记录
- MySQL查看数据库表容量大小
- CentOS7下JSP连接Mysql
- mysql 的存储过程调试软件
- 转发 可设置skip_name_resolve参数 会出现 ERROR 2005 (HY000): Unknown MySQL server host _mysql ...
- mysql 5.7 显示中文
- MySQL运维之---mysqldump备份、select...into outfile、mysql -e 等工具的使用
- python操作mysql数据库系列-操作MySql数据库(五)
- Mysql命令mysql:连接Mysql数据库
- sql:MySql create FUNCTION,VIEW,PROCEDURE
- 分享MYSQL中的各种高可用技术(源自姜承尧大牛)
- Django+Bootstrap+Mysql 搭建个人博客(二)
- mysql数据插入前判断是否存在
- mysql故障解决笔记
- Mysql_mysql force Index 强制索引
- 在centos中php 在连接mysql的时候,出现Can't connect to MySQL server on 'XXX' (13)
- LoadRunner参数化使用mysql数据源
- 【数据库】Mysql-5.7.X 最详细部署教程(linux/macos),真的很详细,一篇文章你就会了
- ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysql 或 manjaro 安装 mariadb
- 【MySql 】is not allowed to connect to this MySql server 无法访问远程MySQL数据库