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

Performance Regression in Mongo-perf Commands.DistinctWithIndexAndQuery

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.1.7
    • Component/s: Querying
    • Labels:
    • Backwards Compatibility:
      Fully Compatible
    • Sprint:
      QuInt 8 08/28/15

      Description

      Seeing a regression on wiredTiger and MMAPv1 on Commands.DistinctWithIndexAndQuery on evergreen.

      MMAPv1 results
      WiredTiger results

      Regression starts on commit: f9904bc

      To recreate with mongo-perf:

      python benchrun.py -t 8 -f testcases/*.js --includeFilter Commands.DistinctWithIndexAndQuery --out perf.json
      

      To recreate with the mongo shell:

      pre = function( collection ) {
                  collection.drop();
                  var docs = [];
                  for ( var i = 0; i < 4800; i++ ) {
                      docs.push( { x : 1 } );
                      docs.push( { x : 2 } );
                      docs.push( { x : 3 } );
                  }
                  collection.insert(docs);
                  collection.ensureIndex( { x : 1 } );
              };
      use test0
      pre(db.test)
      benchRun({"ops":[{"op":"command","tags":["distinct","command","core"],"ns":"test0","command":{"distinct":"Commands_DistinctWithIndexAndQuery0","key":"x","query":{"x":1}},"safe":false,"w":0,"j":false,"writeCmd":true}],"seconds":5,"host":"127.0.0.1:27017","parallel":8})
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              david.storch David Storch
              Reporter:
              david.daly David Daly
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: