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

50% regression in single multi-update

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Done
    • 4.4.8, 5.0.2
    • None
    • None
    • ALL
    • Repl 2021-09-20, Replication 2021-12-13, Replication 2021-12-27, Repl 2022-03-21, Repl 2022-04-04, Repl 2022-04-18, Repl 2022-05-02, Repl 2022-05-16, Repl 2022-05-30, Repl 2022-06-13, Repl 2022-06-27

    Description

      Insert 1M documents like so into a collection:

      {x: 'x'.repeat(100), modified: false}

      Then update like so:

      db.c.updateMany({}, {$set: {modified: true}}, {writeConcern: {w: "majority"}})

      Timings are as follows:

      4.2.15: 56s
      		 
      4.4.8:  82s
      		 
      5.0.5:  86s

      PMP profiling shows this seems to be accounted for by contention on the replication coordinator mutex in setMyLastAppliedOpTimeAndWallTimeForward.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-48522 Regression after mass deletion

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-31694 17% throughput regression in insert workload

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-53667 High rate of journal flushes on secondary in 4.4

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-57407 Avoid taking ReplicationCoordinator mutex when deciding to gossip cluster times with external clients

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-66809 Move BSON serialization out of the lock in prepareReplMetadata

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-66810 Pull expensive calls like _wakeReadyWaiters out of the replSetUpdatePosition inner loop

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-55606 Majority writes with j: false perform worse than j: true

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-62193 Improve insert_vector secondary performance

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-65725 Mutex stats counters can use relaxed mode atomics

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-65054 Avoid slow insert batches blocking replication

          • Major - P3 - Major loss of function.
          • In Progress

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-65657 Reduce calls to the cappedInsertNotifier for the oplog

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-65671 Use _termShadow in updateTerm and processReplSetMetadata

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-65938 Collection haveCappedWaiters should check actual waiters, not potential waiters

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-66023 Do not constantly reset election and liveness timers

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

          Question - SERVER-54939 Investigate secondary batching behavior in v4.4

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

          Page Loading...

          Activity

            People

              matthew.russotto@mongodb.com Matthew Russotto
              bruce.lucas@mongodb.com Bruce Lucas
              Votes:
              0 Vote for this issue
              Watchers:
              23 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: