[SERVER-16276] Perf degradation in query Created: 21/Nov/14  Updated: 23/Jan/15  Resolved: 21/Jan/15

Status: Closed
Project: Core Server
Component/s: Performance
Affects Version/s: 2.8.0-rc0
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Alvin Richards (Inactive) Assignee: Alvin Richards (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: 28qa
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Related
is related to SERVER-16038 CanonicalQuery leaks in mr::MapReduce... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Participants:

 Description   

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');



 Comments   
Comment by Daniel Pasette (Inactive) [ 21/Nov/14 ]

these two commits are part of the fix for SERVER-16038.

Generated at Thu Feb 08 03:40:32 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.