Review WiredTiger default settings for engine and collections

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Done
    • Priority: Major - P3
    • 2.8.0-rc5
    • Affects Version/s: 2.8.0-rc3
    • Component/s: Storage
    • Fully Compatible
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      The current setting for memory_page_max in WiredTiger collections is 100MB. This helped with throughput on insert heavy workloads.

      We have recently made enhancements to WiredTiger to lessen the benefit of a large memory_page_max setting. We should consider switching to the default setting (5MB).

      There are cases where an application thread writes a page to disk after it reaches the memory_page_max setting - having this value large can cause operations to experience high latency.

      I've run a few workloads locally and see equivalent performance with a smaller memory_page_max, and generally significantly smaller values in the profiling of slow operations.

            Assignee:
            Alexander Gorrod
            Reporter:
            Alexander Gorrod
            Votes:
            0 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated:
              Resolved: