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

50% regression in single multi-update

    XMLWordPrintable

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

          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: