flush
To write changes to the database files, that had been buffered in a memory area or a temporary disk storage area. The InnoDB storage structures that are periodically flushed include the redo log, the undo log, and the buffer pool.
Flushing can happen because a memory area becomes full and the system needs to free some space, because a commit operation means the changes from a transaction can be finalized, or because a slow shutdown operation means that all outstanding work should be finalized. When it is not critical to flush all the buffered data at once, InnoDB
can use a technique called fuzzy checkpointing to flush small batches of pages to spread out the I/O overhead.
See also buffer pool.
See also commit.
See also fuzzy checkpointing.
See also neighbor page.
See also redo log.
See also slow shutdown.
See also undo log.