Guest User

Untitled

a guest
Nov 18th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.05 KB | None | 0 0
  1. EXPLAIN :
  2. > db.loadtestsharded.find({ "_id" : ObjectId("4e5677fcfb2317a3d2860220"), "hash" : 19051072}).explain()
  3. {
  4. "clusteredType" : "SerialServer",
  5. "shards" : {
  6. "127.0.0.1:27021" : [
  7. {
  8. "cursor" : "BtreeCursor hash_1__id_1",
  9. "nscanned" : 1,
  10. "nscannedObjects" : 1,
  11. "n" : 1,
  12. "millis" : 0,
  13. "nYields" : 0,
  14. "nChunkSkips" : 0,
  15. "isMultiKey" : false,
  16. "indexOnly" : false,
  17. "indexBounds" : {
  18. "hash" : [
  19. [
  20. 19051072,
  21. 19051072
  22. ]
  23. ],
  24. "_id" : [
  25. [
  26. ObjectId("4e5677fcfb2317a3d2860220"),
  27. ObjectId("4e5677fcfb2317a3d2860220")
  28. ]
  29. ]
  30. }
  31. }
  32. ]
  33. },
  34. "n" : 1,
  35. "nChunkSkips" : 0,
  36. "nYields" : 0,
  37. "nscanned" : 1,
  38. "nscannedObjects" : 1,
  39. "millisTotal" : 0,
  40. "millisAvg" : 0,
  41. "numQueries" : 1,
  42. "numShards" : 1
  43. }
  44.  
  45. CORE AFFINITY ASSIGNED (1 core per mongod, 1 core loadtest/mongos) :
  46. Connecting to 127.0.0.1:27017 using 8 threads
  47. Testing save operation, normal : 40690 operations/sec
  48. Testing save operation, sharded : 29617 operations/sec
  49. Added 1000 elements to candidate list for normal queries
  50. Added 1000 elements to candidate list for sharded queries
  51. Determining shard distribution of sample documents :
  52. Shard 0:346
  53. Shard 1:331
  54. Shard 2:323
  55. Testing find operation, normal : 14841 operations/sec
  56. Testing find operation, sharded : 17362 operations/sec
  57. Testing update operation, normal : 10167 operations/sec
  58. Testing update operation, sharded : 8564 operations/sec
  59.  
  60. NO CORE AFFINITY :
  61.  
  62. Connecting to 127.0.0.1:27017 using 8 threads
  63. Testing save operation, normal : 46881 operations/sec
  64. Testing save operation, sharded : 53581 operations/sec
  65. Added 1000 elements to candidate list for normal queries
  66. Added 1000 elements to candidate list for sharded queries
  67. Determining shard distribution of sample documents :
  68. Shard 0:321
  69. Shard 1:332
  70. Shard 2:347
  71. Testing find operation, normal : 20840 operations/sec
  72. Testing find operation, sharded : 20679 operations/sec
  73. Testing update operation, normal : 12413 operations/sec
  74. Testing update operation, sharded : 8897 operations/sec
Add Comment
Please, Sign In to add comment