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

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

InnoDB, like any other ACID-compliant database engine, flushes the redo log of a transaction before it is committed. InnoDB uses group commit functionality to group multiple such flush requests together to avoid one flush for each commit. With group commit, InnoDB issues a single write to the log file to perform the commit action for multiple user transactions that commit at about the same time, significantly improving throughput.

InnoDB,像任何其他ACID标准数据库引擎一样,在事务提交之前会刷新事务redo日志。InnoDB使用组提交功能将这类刷新请求打包到一起以避免每个提交都触发一次刷新。通过组提交,InnoDB可为大概在同一时间提交的多个用户事务分配一个单独的日志文件写入操作用来执行这些提交行为,这大大提高了吞吐量。

For more information about performance of COMMIT and other transactional operations, see Section 9.5.2, “Optimizing InnoDB Transaction Management”.

更多信息关于COMMIT以及其他事务操作的执行过程,请参考9.5.2,“优化InnoDB事务管理”。
阅读更多
文章标签: mysql
个人分类: Mysql
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭