Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-16602

Review WiredTiger default settings for engine and collections

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: 2.8.0-rc3
    • Fix Version/s: 2.8.0-rc5
    • Component/s: Storage
    • Labels:
    • Backwards Compatibility:
      Fully Compatible

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                12 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: