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

Performance Regression in Mongo-perf Commands.DistinctWithIndexAndQuery

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 3.1.7
    • Querying
    • Fully Compatible
    • 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

              david.storch@mongodb.com David Storch
              david.daly@mongodb.com David Daly
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: