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