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

Skip obsolete leaf pages without having to read them

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • WT10.0.1, 5.0.4, 4.4.10, 5.1.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • 13
    • Storage - Ra 2021-07-12, Storage - Ra 2021-07-26, Storage - Ra 2021-08-09, Storage - Ra 2021-09-06, Storage - Ra 2021-09-20, Storage - Ra 2021-10-04

      SERVER-47855 resulted in several regressions, see attached BF for the details. This particular ticket is to investigate a 410% regression in genny workload that repeatedly deletes and reinserts documents in a long-running transaction.

        1. DeleteAndReinsert.Crud.png
          DeleteAndReinsert.Crud.png
          70 kB
        2. compare.png
          compare.png
          244 kB
        3. newstats.png
          newstats.png
          555 kB
        4. re-run.png
          re-run.png
          167 kB
        5. perf-improv.png
          perf-improv.png
          504 kB
        6. 7757-2.png
          7757-2.png
          156 kB
        7. reduced-regress.png
          reduced-regress.png
          80 kB
        8. regress-gone.png
          regress-gone.png
          62 kB
        9. Screen Shot 2021-07-19 at 10.42.32 AM.png
          Screen Shot 2021-07-19 at 10.42.32 AM.png
          73 kB
        10. Screenshot 2021-07-20 at 22.03.02.png
          Screenshot 2021-07-20 at 22.03.02.png
          33 kB
        11. comp1.png
          comp1.png
          1.08 MB
        12. comp2.png
          comp2.png
          106 kB
        13. comp3.png
          comp3.png
          74 kB
        14. Screen Shot 2021-07-19 at 7.43.48 PM.png
          Screen Shot 2021-07-19 at 7.43.48 PM.png
          49 kB
        15. Screen Shot 2021-07-20 at 8.54.58 PM.png
          Screen Shot 2021-07-20 at 8.54.58 PM.png
          38 kB
        16. comp4.png
          comp4.png
          49 kB
        17. more -changes.png
          more -changes.png
          114 kB
        18. wt-7757-last.png
          wt-7757-last.png
          104 kB
        19. test_index_inconsistency.py
          5 kB

            Assignee:
            sulabh.mahajan@mongodb.com Sulabh Mahajan
            Reporter:
            sulabh.mahajan@mongodb.com Sulabh Mahajan
            Votes:
            0 Vote for this issue
            Watchers:
            15 Start watching this issue

              Created:
              Updated:
              Resolved: