Ask a question:
Innodb_flush_log_at_trx_commit: this parameter controls the binlog written to disk, such as: the value is 1, said every time commit; Are written to disk
Binlog_group_commit_sync_delay: said binlog submitted after how long delay synchronization to disk
These two parameters Settings will have any conflict at the same time, if at the same time set innodb_flush_log_at_trx_commit=1, binlog_group_commit_sync_delay=100, so a commit, when writing the binlog?

CodePudding user response:

This is two different LOG, not conflict

CodePudding user response:

Innodb_flush_log_at_trx_commit the refresh is not binlog redo log ib_logfile0 namely