This is the third and final article in a series about group commit in MySQL. The first article discussed the background: group commit in MySQL does not work when the binary log is enabled. The second article explained the part of the InnoDB code that is responsible for the problem.
So how do we fix group commit in MySQL? As we saw in the second
article of this series, we can just eliminate
prepare_commit_mutex from InnoDB, extend the binary logging
to do group commit by itself, and that would solve the problem.
However, we might be able to do even better. As explained in the first article, with binary logging[Read more...]