What is incremental checkpoint?

An alternative to traditional cache-consistent checkpoints involving less overhead but may require more restart work. In an incremental checkpoint, no database pages are written to disk. Instead, dirty database pages are periodically written to disk in ascending age order. At checkpoint time, the log position of the oldest dirty data page is recorded to provide a starting point for recovery. The amount of restart work can be controlled by the frequency of writing dirty data pages.

Tags: Database, Education, Software

Related