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

Throttle concurrent index builds in WiredTiger

    • Type: Icon: Improvement Improvement
    • Resolution: Won't Fix
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Labels:
      None
    • Storage Execution

      Whenever the case occurs that an index build could occur simultaneously (initial sync, or via oplog using background indexes) applying to the same collection, MMAP builds the indexes in serial, while WiredTiger builds the indexes in parallel (no observed limit).

      This has performance implications in both directions.

      • MMAP does not make use of available hardware beyond the disk IO for a single index (despite the other indexes potentially requiring the same data).
      • WiredTiger can overrun the capacity of a lower powered machine (a hidden secondary for backup or analytic purposes) and end up thrashing to cause significant stalling.

      This ticket is to request a review of the WiredTiger behavior to consider if some feedback on the hardware can be taken into consideration when building indexes in parallel.

            Assignee:
            backlog-server-execution Backlog - Storage Execution Team
            Reporter:
            andrew.ryder@mongodb.com Andrew Ryder (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            17 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'slack.nextup.jira:slack-integration-plus'. Please contact your Jira administrators.