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

            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: