Sep 7, 2026 · Databases

InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios

This article explains InnoDB's checkpoint mechanism, contrasting synchronous and fuzzy checkpoints, detailing the pre-MySQL 8.0 fuzzy checkpoint implementation using flush lists and page cleaners, and describing two principles for detecting abnormal shutdowns plus four post-restart crash scenarios with their recovery requirements.

CheckpointCrash RecoveryInnoDB

0 likes · 11 min read

InnoDB Checkpoint Internals: Sync vs Fuzzy, Crash Recovery Detection, and Four Failure Scenarios

Programmer DD

Dec 29, 2019 · Databases

How InnoDB Buffer Pool Manages Pages and Flush Lists for Optimal Performance

This article explains the three InnoDB Buffer Pool page types—Free, Clean, and Dirty—their associated LRU, Flush, and Free linked lists, and how MySQL uses configurable parameters to balance memory usage, query speed, and data safety during flushing and checkpoint operations.

Buffer PoolInnoDBLRU

0 likes · 13 min read

How InnoDB Buffer Pool Manages Pages and Flush Lists for Optimal Performance