【MySQL 5.7 Reference Manual】15.4.13 Redo Log(Redo日志)

15.4.13 Redo Log(Redo日志) Group Commit for Redo Log Flushing(基于组提交的Redo日志刷新)

The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. During normal operations, the redo log encodes requests to change InnoDB table data that result from SQL statements or low-level API calls. Modifications that did not finish updating the data files before an unexpected shutdown are replayed automatically during initialization, and before the connections are accepted. For information about the role of the redo log in crash recovery, see Section 15.18.1, “The InnoDB Recovery Process”.


By default, the redo log is physically represented on disk as a set of files, named ib_logfile0 and ib_logfile1. MySQL writes to the redo log files in a circular fashion. Data in the redo log is encoded in terms of records affected; this data is collectively referred to as redo. The passage of data through the redo log is represented by an ever-increasing LSN value.


For related information, see:


- Section 15.6.1, “InnoDB Startup Configuration”

- 章节15.6.1,“InnoDB启动配置”

- Section 9.5.4, “Optimizing InnoDB Redo Logging”

- 章节9.5.4,“优化InnoDB Redo日志”

- Section 15.7.2, “Changing the Number or Size of InnoDB Redo Log Files”

- 章节15.7.2,“修改InnoDB Redo日志文件的数量或大小”
文章标签: mysql
个人分类: Mysql
想对作者说点什么? 我来说一句