Download as PDF, PPTX
![{
"cursor" : "BtreeCursor _id_ reverse",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 227756,
"nscanned" : 227756,
"nscannedObjectsAllPlans" : 227756,
"nscannedAllPlans" : 227756,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1779,
"nChunkSkips" : 0,
"millis" : 461,
"indexBounds" : {
"_id" : [
[
{
"$maxElement" : 1
},
{
"$minElement" : 1
}
]
]
},
"server" : "Jaroussky.local:27017",
"filterSet" : false
}](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/85/Mongodb-debugging-performance-problems-20-320.jpg)
![{ "cursor" :
"BtreeCursor _id_ reverse",
"nscanned" : 227756,
"indexBounds" : {"_id" : [
[{"$maxElement" : 1},
{"$minElement" : 1}]
]
}
}](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/85/Mongodb-debugging-performance-problems-21-320.jpg)
![{"cursor" : "BtreeCursor
project_id_1__id_1",
"nscanned" : 6,
"indexBounds" : {
"project_id" : [[
ObjectId(x),ObjectId(x)
]],
"_id" : [[
{"$minElement" : 1},
{"$maxElement" : 1}
]]
}}](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/85/Mongodb-debugging-performance-problems-24-320.jpg)
![db.stats()['indexSize']
= 3852071824
= 3932614656
free -b (m3.medium)](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/85/Mongodb-debugging-performance-problems-42-320.jpg)
![db.stats()['indexSize']
= 3852071824
= 15775363072
free -b (r3.large)](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/85/Mongodb-debugging-performance-problems-44-320.jpg)
![{
"cursor" : "BtreeCursor _id_ reverse",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 227756,
"nscanned" : 227756,
"nscannedObjectsAllPlans" : 227756,
"nscannedAllPlans" : 227756,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 1779,
"nChunkSkips" : 0,
"millis" : 461,
"indexBounds" : {
"_id" : [
[
{
"$maxElement" : 1
},
{
"$minElement" : 1
}
]
]
},
"server" : "Jaroussky.local:27017",
"filterSet" : false
}](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/75/Mongodb-debugging-performance-problems-20-2048.jpg)
![{ "cursor" :
"BtreeCursor _id_ reverse",
"nscanned" : 227756,
"indexBounds" : {"_id" : [
[{"$maxElement" : 1},
{"$minElement" : 1}]
]
}
}](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/75/Mongodb-debugging-performance-problems-21-2048.jpg)
![{"cursor" : "BtreeCursor
project_id_1__id_1",
"nscanned" : 6,
"indexBounds" : {
"project_id" : [[
ObjectId(x),ObjectId(x)
]],
"_id" : [[
{"$minElement" : 1},
{"$maxElement" : 1}
]]
}}](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/75/Mongodb-debugging-performance-problems-24-2048.jpg)
![db.stats()['indexSize']
= 3852071824
= 3932614656
free -b (m3.medium)](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/75/Mongodb-debugging-performance-problems-42-2048.jpg)
![db.stats()['indexSize']
= 3852071824
= 15775363072
free -b (r3.large)](https://image.slidesharecdn.com/mongodb-debugging-performance-problems-141212092643-conversion-gate02/75/Mongodb-debugging-performance-problems-44-2048.jpg)
Uploaded byMongoDB
Mongodb debugging-performance-problems
The document discusses strategies for improving MongoDB performance, emphasizing the importance of application speed over database speed. Key solutions include denormalization, indexing, sharding, and scaling the database. Various performance metrics and query execution plans are provided to illustrate and support the suggested solutions.
More Related Content
Similar to Mongodb debugging-performance-problems
![MongoDB .local San Francisco 2020: Powering the new age data demands [Infosys]](https://cdn.slidesharecdn.com/ss_thumbnails/315pminfosysfinalsfoversionvocalpart1-200120221508-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
![UiPath Automation Suite Installation (Hands-On) [2/3]](https://cdn.slidesharecdn.com/ss_thumbnails/automationsuitecommunitysession2-251015095633-a6d862f1-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
Mongodb debugging-performance-problems
- 1. MongoDB Debugging PerformanceProblems @ConradIrwin
- 3. 50M crashes/day 4TBdata / 100GB index 15 nodes / 3* availability zones
- 4. I don't careif MongoDB is slow I care if my app is slow
- 5. How to makeapp fast again it's slow because of the way I'm
- 6. What does slowmean?
- 8.
- 9.
- 11.
- 14.
- 16.
- 17.
- 18. db.errors. find({project_id: x}). sort({ _id: -1}). limit(30)
- 19. db.errors. find({project_id: x}). sort({ _id: -1}). limit(30). explain()
- 20. { "cursor" :"BtreeCursor _id_ reverse", "isMultiKey" : false, "n" : 0, "nscannedObjects" : 227756, "nscanned" : 227756, "nscannedObjectsAllPlans" : 227756, "nscannedAllPlans" : 227756, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 1779, "nChunkSkips" : 0, "millis" : 461, "indexBounds" : { "_id" : [ [ { "$maxElement" : 1 }, { "$minElement" : 1 } ] ] }, "server" : "Jaroussky.local:27017", "filterSet" : false }
- 21. { "cursor" : "BtreeCursor _id_ reverse", "nscanned" : 227756, "indexBounds" : {"_id" : [ [{"$maxElement" : 1}, {"$minElement" : 1}] ] } }
- 22.
- 23. db.errors.ensureIndex( {project_id: 1,_id: -1} )
- 24. {"cursor" : "BtreeCursor project_id_1__id_1", "nscanned" : 6, "indexBounds" : { "project_id" : [[ ObjectId(x),ObjectId(x) ]], "_id" : [[ {"$minElement" : 1}, {"$maxElement" : 1} ]] }}
- 25.
- 26.
- 27. Only 1 query... Indexed properly...
- 28.
- 29. insert query updatedelete getmore command flushes mapped 5 97 57 *0 95 127|0 0 320g 5 98 61 *0 113 146|0 0 320g 8 94 61 *0 95 137|0 0 320g vsize res faults locked db idx miss % qr|qw ar|aw 641g 8.65g 7 bugsnag:47.7% 0 0|0 0|0 641g 8.66g 2 bugsnag:21.0% 0 0|0 0|0 641g 8.64g 3 bugsnag:23.4% 0 0|0 0|0 netIn netOut conn set repl time 47k 73k 145 bugsnag1 PRI 06:34:05 63k 99k 146 bugsnag1 PRI 06:34:06 98k 124k 146 bugsnag1 PRI 06:34:07
- 30. command locked dbtime 127|0 bugsnag:47.7% 06:34:05 146|0 bugsnag:21.0% 06:34:06 137|0 bugsnag:23.4% 06:34:07
- 32.
- 34. sh.shardCollection("errors" { project_id:1, _id: -1 })
- 35. command locked dbtime 83|0 bugsnag:3.1% 06:46:12 69|0 bugsnag:4.1% 06:46:13 73|0 bugsnag:2.4% 06:46:14
- 36.
- 37.
- 38. Only 1 query... Indexed properly... Lock % ok...
- 39.
- 40. Device: rrqm/s wrqm/sr/s w/s rkB/s wkB/s avgrq-sz xvdi 0.00 2.00 15.00 743.00 436.00 7905.50 22.01 xvdi 0.00 2.00 0.00 663.00 0.00 6706.00 20.23 xvdi 0.00 1.00 0.00 726.00 0.00 5593.50 15.41 avgqu-sz await r_await w_await svctm %util 11.02 14.54 5.33 14.73 0.60 45.60 8.04 12.12 0.00 12.12 0.51 33.60 13.01 17.92 0.00 17.92 0.50 36.40
- 41. rkB/s wkB/s await%util 7660 138 14.73 83.60 2248 2043 12.12 65.20 7905 436 17.92 45.60
- 42. db.stats()['indexSize'] = 3852071824 = 3932614656 free -b (m3.medium)
- 43.
- 44. db.stats()['indexSize'] = 3852071824 = 15775363072 free -b (r3.large)
- 45.
- 46.
- 47. Main query seemsfine... "Quick" queries sometimes slow...
- 48.
- 49. ns total readwrite 20 14-06-22T19:11:35 bugsnag.events 95ms 0ms 95ms bugsnag.errors 80ms 6ms 74ms bugsnag.system.namespaces 26ms 26ms 0ms bugsnag.projects 12ms 5ms 7ms bugsnag.users 15ms 2ms 13ms bugsnag.error_aggregates 4ms 0ms 4ms bugsnag.deploys 4ms 3ms 1ms bugsnag.event_tallies 3ms 0ms 3ms
- 50. ns tot rw bugsnag.events 95 0 95 bugsnag.errors 80 6 74 bugsnag.projects 12 5 7 bugsnag.users 15 7 8
- 52. Solution 5 Tagshards
- 54.
- 55.
- 56.
- 57.
- 58.
- 59. Solution 5 Tagshards
- 60.
- 61. NewRelic / Skylight explain() mongostat iostat mongotop ...
- 62. It will beslow
- 63. You can speedit up
- 64.