What is fuzzy checkpoint?

An alternative to traditional cacheconsistent checkpoints involving less overhead but may require more restart work. In a fuzzy checkpoint, the recovery manager only writes the buffer pages since the previous checkpoint. Most of these pages should have already been written to disk before the checkpoint. At restart time, the recovery manager uses the two most recent fuzzy checkpoint records in the log.

Tags: Database, Education, Software

Related