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

Perf degradation in query

    • Type: Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 2.8.0-rc0
    • Component/s: Performance
    • Fully Compatible
    • ALL

      Problem

      Appears to be a perf degradation caused by commit e8437d34eee926e5c6bb3eac4a74f8a1fdf19448

      e8437d34eee926e5c6bb3eac4a74f8a1fdf19448
      @@@START@@@
      Remove.v3.IntNonIdNoIndex
              1       1440.2860827436061
              2       1441.1362631578315
              4       1424.8497230369633
              8       901.6573578059949
      @@@END@@@
      
      2783e323051eb5eeaedee4a607934974177f74c2
      @@@START@@@
      Remove.v3.IntNonIdNoIndex
              1       1588.0643793020076
              2       1520.9383985954414
              4       1512.18813243067
              8       1156.9223116204623
      @@@END@@@
      

      Test cases affected

      {
      	"label" : "sanity-7bdca162807d6436d469a352a129226252cb451d-2014-11-13-mmapv1-c1 vs. sanity-def8f54bf6162317cc8b345e81c6e698d618ad96-2014-11-20-mmapv1-c1",
      	"test" : "Remove.v3.IntNonIdNoIndex",
      	"threads" : 8,
      	"a_median" : 1298.8725522515988,
      	"b_median" : 987.0579518907155,
      	"delta" : 75.9934414026725
      }
      {
      	"label" : "sanity-7bdca162807d6436d469a352a129226252cb451d-2014-11-13-mmapv1-c1 vs. sanity-def8f54bf6162317cc8b345e81c6e698d618ad96-2014-11-20-mmapv1-c1",
      	"test" : "Commands.v1.DistinctWithoutIndexAndQuery",
      	"threads" : 2,
      	"a_median" : 542.7118200235675,
      	"b_median" : 413.80021725510926,
      	"delta" : 76.24676706638522
      }
      {
      	"label" : "sanity-7bdca162807d6436d469a352a129226252cb451d-2014-11-13-mmapv1-c1 vs. sanity-def8f54bf6162317cc8b345e81c6e698d618ad96-2014-11-20-mmapv1-c1",
      	"test" : "Queries.v1.IntNonIdFindOne",
      	"threads" : 2,
      	"a_median" : 37729.83037525837,
      	"b_median" : 31039.0812431952,
      	"delta" : 82.26668642419692
      }
      {
      	"label" : "sanity-7bdca162807d6436d469a352a129226252cb451d-2014-11-13-mmapv1-c1 vs. sanity-def8f54bf6162317cc8b345e81c6e698d618ad96-2014-11-20-mmapv1-c1",
      	"test" : "Commands.v1.DistinctWithoutIndexAndQuery",
      	"threads" : 8,
      	"a_median" : 1463.518543163606,
      	"b_median" : 1209.2328484546715,
      	"delta" : 82.62504456149497
      }
      {
      	"label" : "sanity-7bdca162807d6436d469a352a129226252cb451d-2014-11-13-mmapv1-c1 vs. sanity-def8f54bf6162317cc8b345e81c6e698d618ad96-2014-11-20-mmapv1-c1",
      	"test" : "Queries.v1.FindProjectionThreeFields",
      	"threads" : 1,
      	"a_median" : 1214.8687941702296,
      	"b_median" : 1032.298568817905,
      	"delta" : 84.97202115747633
      }
      {
      	"label" : "sanity-7bdca162807d6436d469a352a129226252cb451d-2014-11-13-mmapv1-c1 vs. sanity-def8f54bf6162317cc8b345e81c6e698d618ad96-2014-11-20-mmapv1-c1",
      	"test" : "Update.v3.IncWithIndex",
      	"threads" : 2,
      	"a_median" : 26825.60596206352,
      	"b_median" : 22852.67785537977,
      	"delta" : 85.18979175231969
      }
      {
      	"label" : "sanity-7bdca162807d6436d469a352a129226252cb451d-2014-11-13-mmapv1-c1 vs. sanity-def8f54bf6162317cc8b345e81c6e698d618ad96-2014-11-20-mmapv1-c1",
      	"test" : "Update.MmsIncDeep1",
      	"threads" : 2,
      	"a_median" : 30913.080946469734,
      	"b_median" : 26569.949761607626,
      	"delta" : 85.95050686671173
      }
      

      Reproduce

      In the shell, use mongo-perf tests

      load ('./mongo-perf-current/util/utils.js')
      var tests=[]
      tests.push( { name: "Remove.v3.IntNonIdNoIndex",               tags: ['remove','sanity','daily','weekly','monthly'],               pre: function( collection ) {                   collection.drop();                   for ( var i = 0; i < 4800; i++ ) {                       collection.insert( { x : i } );                   }               },               ops: [                   { op: "let", target: "x", value: {"#RAND_INT_PLUS_THREAD": [0,100]}},                   { op:  "remove",                     query: { x : { "#VARIABLE" : "x" } } },                   { op:  "insert",                     doc: { x : { "#VARIABLE" : "x" } } },               ] } );
      runTests([1,2,4,8], 1, 1, 5, 1, 'server-xxx', 'sanity', '54.191.70.12', '27017');
      

            Assignee:
            alvin Alvin Richards (Inactive)
            Reporter:
            alvin Alvin Richards (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: