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

Consider update structure overhead in split length calculation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: 4.4.0-rc12, 4.4.0-rc13
    • Fix Version/s: WT10.0.0, 4.4.2, 4.7.0
    • Component/s: None
    • Labels:
    • Story Points:
      13
    • Sprint:
      Storage - Ra 2020-07-27, Storage - Ra 2020-08-10, Storage - Ra 2020-08-24, Storage - Ra 2020-09-07
    • Backport Requested:
      v4.4

      Description

      For Linkbench with maxid=200M the database size in GB after 1 hour of transactions is:

      • 451, 382, and 367 for rc13, rc9 and 4.2.8 without Snappy compression
      • 233, 215 and 204 for rc13, rc9 and 4.2.8 with Snappy compression

      The regression started with rc12 although I didn't list the results for that above. Much more performance data is here. I don't see a significant regression in size for the insert benchmark. It is ~10% there.

      The biggest growth is from _id which is ~2X larger now in rc12 & rc13 compared to 4.2.8. That looks like a return of WT-6251

        Attachments

        1. 6487-dist-20.png
          6487-dist-20.png
          60 kB
        2. 6532-compare-11-12-mlock.png
          6532-compare-11-12-mlock.png
          357 kB
        3. compare-rc11-12.png
          compare-rc11-12.png
          422 kB
        4. compare-rc11-12-1.png
          compare-rc11-12-1.png
          422 kB
        5. compare-rc14-without-6487.png
          compare-rc14-without-6487.png
          632 kB
        6. file-specific.png
          file-specific.png
          436 kB
        7. ftdc.size.tar.gz
          126.96 MB
        8. repro.30m.tgz
          17.30 MB
        9. split-with-6487.png
          split-with-6487.png
          55 kB
        10. split-without-6487.png
          split-without-6487.png
          67 kB

          Issue Links

            Activity

              People

              Assignee:
              sulabh.mahajan Sulabh Mahajan
              Reporter:
              mark.callaghan Mark Callaghan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: