Mysql的组复制(group commit)
An InnoDB optimization that performs some low-level I/O operations (log write) once for a set of commit operations, rather than flushing and syncing separately for each commit
事务提交的过程：redo log(perpare) ---> binlog刷盘持久化 ---->redo log(commit)
binlog刷盘分为三个阶段(flush 阶段、sync阶段和commit阶段)
这里说说关于组提交的两个相关的参数(以下参数一般基于双1参数进行设置的：sync_binlog=1 innodb_flush_log_at_trx_commit=1)：
- Binlog_group_commit_sync_delay：定时发车在等待N 微秒后，进行binlog刷盘操作
- binlog_group_commit_sync_no_delay_count=N：人满发车，达到最大事务等待数量，开始binlog刷盘，忽略定时发车
- 以上两个参数的默认值都是0
这两个参数的具体的解释见：https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
组复制这里参考：https://blog.csdn.net/sanylove/article/details/127576237
标签：binlog,group,log,Mysql,sync,复制,67,commit,刷盘 From： https://www.cnblogs.com/zmc60/p/17234362.html