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 the 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 …
[Read more]