content_image/736872.jpg content_image/736873.jpg content_image/736874.jpg
delay to increase contention and therefore reduce throughput. Typically, the benefits of setting a delay outweigh the drawbacks, but tuning should always be carried out to determine the optimal setting. 

• binlog_group_commit_sync_no_delay_count 

<img src='content_image/736872.jpg'>

The maximum number of transactions to wait for before aborting the current delay as specified by binlog_group_commit_sync_delay . If binlog_group_commit_sync_delay  is set to 0, then this option has no effect. 

• binlog_max_flush_queue_time 

<img src='content_image/736873.jpg'>

binlog_max_flush_queue_time  is deprecated, and is marked for eventual removal in a future MySQL release. Formerly, this system variable controlled the time in microseconds to continue reading transactions from the flush queue before proceeding with group commit. It no longer has any effect. 

• binlog_order_commits 

<img src='content_image/736874.jpg'>

