Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-7089

Don't skip checkpointing objects that have obsolete pages

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: WT10.0.0, 4.9.0, 4.4.4
    • Component/s: None
    • Labels:
      None
    • Story Points:
      3
    • Sprint:
      Storage - Ra 2021-01-25, Storage - Ra 2021-02-08

      Description

      As part of a HELP-21209 ticket discussion, we observed that history store file size doesn't get reduced in PSA architecture once the standby catches up with the primary after a crash.

      As part of the checkpoint, the checkpoint garbage collection removes the obsolete pages that are part of any table and later these removed pages will be cleared and space gets reclaimed. WiredTiger checkpoint process skips the tables as part of the checkpoint that doesn't have any modifications since the last checkpoint (exceptions are there).

      The test that is described in the help ticket doesn't let any modifications happen to the WiredTiger history store table once the standby catches up with the primary. As part of WT checkpoint, the history store file is always skipped to be part of the checkpoint as there are no modifications and it led to never removal of obsolete pages that are part of the history store table.

        Attachments

          Activity

            People

            Assignee:
            haribabu.kommi Haribabu Kommi
            Reporter:
            haribabu.kommi Haribabu Kommi
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: