Enchance checkpoint to scrub evict cleaned pages

XMLWordPrintableJSON

    • Storage Engines, Storage Engines - Transactions
    • 669.723
    • SE Transactions - 2026-08-14
    • 3

      At the moment, when checkpoint reconciles a page it will always leave the in-memory page in place with the original set of updates. It can often mark the page clean.

      Those pages with updates that just hang out cause the cache to be in a less optimal state.

      We should add code that will attempt to swap the page with updates, with an equivalent disk-image that was just generated by reconciliation. That process would be equivalent to scrub-evicting a page that was dirty. It requires that checkpoint tries to get exclusive access to the page, if it succeeds it will proceed with the scrub eviction.

        1. image-2026-08-03-10-17-13-013.png
          143 kB
          Alana Huang
        2. image-2026-08-03-10-17-45-744.png
          142 kB
          Alana Huang
        3. Screenshot 2026-07-17 at 4.52.42 pm.png
          60 kB
          Alexander Gorrod
        4. Screenshot 2026-07-23 at 8.36.10 pm.png
          205 kB
          Alexander Gorrod
        5. Screenshot 2026-07-23 at 8.40.06 pm.png
          233 kB
          Alexander Gorrod
        6. Screenshot 2026-07-23 at 8.48.20 pm.png
          159 kB
          Alexander Gorrod

            Assignee:
            Alana Huang
            Reporter:
            Alexander Gorrod
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: