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

Optimize cache usage for update workload with history pinned

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 3.6.6, 4.0.0-rc5, WT3.1.0, 4.1.1
    • None
    • None
    • Storage Non-NYC 2018-06-04, Storage Non-NYC 2018-06-18

    Description

      Workloads that insert a large value, and then do many WT_CURSOR->modify operations to make many small updates to the value while holding the oldest transaction/timestamp pinned can generate very large pages in cache, and force us to regularly re-write the page via lookaside.

      Which leads to effectively pinning the cache full.

      We could do better by decreasing how often we instantiate a full value in such workloads, so there is less memory pinned in cache.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-4115 Valgrind error in est_wt4105_large_doc_small_upd

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is depended on by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-33191 Cache-full hangs on 3.6

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-36221 [3.6] Performance regression on small updates to large documents

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. WT-4107 Reduce lookaside usage in update heavy workloads where history is pinned

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              vamsi.krishna@mongodb.com Vamsi Boyapati
              alexander.gorrod@mongodb.com Alexander Gorrod
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: