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

Skip in-memory deleted pages as part of the tree walk

    • Storage Engines
    • 8
    • 2023-04-04 Bibbidi-Bobbidi-Boo, 2023-06-27 Lord of the Sprints, 2023-07-11 WiredTractor, 2023-07-25 Absolute unit, StorEng - 2023-08-08, ASeasonTooMany-2023-08-22, BermudaTriangle- 2023-09-05, TheMoon-StorEng - 2023-09-19, 2023-11-28 - Anthill Tiger, 2023-12-12 - Heisenbug, 2024-01-09 - I Grew Tired, StorEng - 2024-01-23, 2024-02-06 tapioooooooooooooca, 2024-02-20_A_near-death_puffin, 2024-03-05 - Claronald
    • v7.3, v7.0, v6.0, v5.0

      Summary

      The issue discussed in this ticket is related to WT-10424 (where the reproducer in the ticket description did not consider timestamps). After modifying the test with timestamps and implementing the WT-10424 solution, a regression was observed, particularly when the oldest timestamp was pinned. These symptoms are observed in multiple customer issues as well.

      Acceptance criteria

      • Provide an explanation for why WT-10424 is effective in non-timestamp cases but not in cases that involve timestamps.
      • Find the root cause of this performance regression
      • Find solutions to fix the same

        1. a.png
          a.png
          277 kB
        2. after.png
          after.png
          149 kB
        3. b.png
          b.png
          157 kB
        4. before.png
          before.png
          145 kB
        5. mass_delete_regression_find.svg
          115 kB
        6. s.png
          s.png
          95 kB
        7. Screenshot 2023-11-03 at 7.16.42 AM.png
          Screenshot 2023-11-03 at 7.16.42 AM.png
          261 kB
        8. WiredTigerStat.11.04
          6.17 MB

            Assignee:
            haribabu.kommi@mongodb.com Haribabu Kommi
            Reporter:
            siddhartha.mahajan@mongodb.com Sid Mahajan
            Votes:
            0 Vote for this issue
            Watchers:
            27 Start watching this issue

              Created:
              Updated:
              Resolved: