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

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

              Created:
              Updated:
              Resolved: