InnoDB, like any other ACID-compliant database engine, flushes the redo log of a transaction before it is committed. InnoDB uses group commit functionality to group multiple such flush requests together to avoid one flush for each commit. With group commit, InnoDB issues a single write to the log file to perform the commit action for multiple user transactions that commit at about the same time, significantly improving throughput.
For more information about performance of
COMMIT and other transactional operations, see
Section 8.5.2, “Optimizing InnoDB Transaction Management”.
Copyright © 1997, 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices