With the release of MySQL 5.6 binary log group commit is included, which is a feature focused on improving performance of a server when the binary log is enabled. In short, binary log group commit improve performance by grouping several writes to the binary log instead of writing them one by one, but let me digress a little on how transactions are logged to the binary log before going into the details. Before going into details about the problem and the implementation, let look at what you do to turn it on.
Well... we actually have a few options to tweak it, but nothing
required to turn it on. It even works for existing engines since
we did not have to extend the handlerton interface to implement
the binary log group commit. However, InnoDB has some
optimizations to take advantage of the binary log group commit
- This is a …