【第22期】观点:IT 行业加班,到底有没有价值?

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

翻译 2017年01月02日 21:36:01
15.4.13 Redo Log(Redo日志)

15.4.13.1 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”.

redo日志基于磁盘的数据结构,在崩溃恢复期间用于纠正不完整事务所写入的数据。在正常操作情况下,redo日志编码请求以改变InnoDB表数据,这些数据来自于SQL语句或低级API调用的结果。如果在意外关闭之前更新数据文件的操作没有结束,这些修改在初始化期间(连接被接收接受之前)会自动重新执行。

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.

默认情况下,redo日志物理上表现为磁盘上的一堆文件,名为ib_logfile0和ib_logfile1。MySQL以循环方式写入redo日志文件。redo日志中的数据按照受影响的记录进行编码;这些数据整体被用于redo。数据穿过redo日志的通道用一个不断增长的LSN值表示。

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日志文件的数量或大小”
举报

相关文章推荐

Oracle redo log 大小及组数的设置(在线修改日志组数目及组成员个数)

1.查看当前系统现有的redo log状况(组数/大小/名称/状态) desc">SYS@ORCL>desc v$log  Name                                  ...

LogMiner 和 archived redo log,分析归档日志

LogMiner A utility that enables log files to be read, analyzed, and interpreted by means of SQL statements. archived redo log A copy of one of the filled members of an online redo log group made when the<

欢迎关注CSDN程序人生公众号

关注程序员生活,汇聚开发轶事。

oracle Logminer日志挖掘redo log中的sql语句

logminer作用 LogMiner是用于Oracle日志挖掘的利器,使用该工具可以轻松获得Oracle 重做日志文件(归档日志文件)中的具体内容,LogMiner分析工具实际上是由一组PL/SQ...

MySQL5.7 可以回收(收缩)undo log回滚日志物理文件空间

undo log回滚日志是保存在共享表空间ibdata1文件里,随着业务的不停运转,ibdata1文件会越来越大,想要回收(收缩空间大小)极其困难和复杂, 必须先mysqldump -A全库的

【MySQL 5.7 Reference Manual】15.4.13.1 Group Commit for Redo Log Flushing(基于组提交的Redo日志刷新)

InnoDB,像任何其他ACID标准数据库引擎一样,在事务提交之前会刷新事务redo日志。InnoDB使用组提交功能将这类刷新请求打包到一起以避免每个提交都触发一次刷新。通过组提交,InnoDB可为大...
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)