Skip to content

Instantly share code, notes, and snippets.

@iamnader

iamnader/mongostat

Created July 11, 2012 23:06
Show Gist options
  • Save iamnader/3094357 to your computer and use it in GitHub Desktop.
Save iamnader/3094357 to your computer and use it in GitHub Desktop.
Download ZIP
Slow Upserts on Indexed Data (though not all in RAM)
Raw
mongostat
insert query update delete getmore command flushes mapped vsize res locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 11 739 0 0 399 0 30.9g 64.4g 550m 43.9 0 0|0 0|1 183k 45k 10 16:03:25
0 5 423 0 0 232 0 30.9g 64.4g 549m 65.1 0 0|0 0|1 106k 26k 10 16:03:26
0 5 471 0 0 261 0 30.9g 64.4g 549m 58.9 0 0|0 0|0 119k 29k 10 16:03:27
0 6 666 0 0 371 0 30.9g 64.4g 548m 50.4 0 0|0 0|0 166k 40k 10 16:03:28
0 8 637 0 0 398 0 30.9g 64.4g 548m 43.8 0 0|0 0|0 167k 44k 10 16:03:29
0 7 727 0 0 419 0 30.9g 64.4g 549m 32.1 0 0|0 0|1 185k 45k 10 16:03:30
0 6 821 0 0 483 0 30.9g 64.4g 552m 41.9 0 0|0 0|1 209k 51k 10 16:03:31
0 4 379 0 0 234 0 30.9g 64.4g 549m 67.7 0 0|0 0|1 98k 25k 10 16:03:32
0 4 484 0 0 297 0 30.9g 64.4g 550m 54.7 0 0|0 0|1 125k 32k 10 16:03:33
0 5 550 0 0 324 0 30.9g 64.4g 549m 60.4 0 0|0 0|0 139k 35k 10 16:03:34
insert query update delete getmore command flushes mapped vsize res locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 8 639 0 0 359 0 30.9g 64.4g 551m 47.8 0 0|0 0|1 161k 40k 10 16:03:35
0 7 655 0 0 391 0 30.9g 64.4g 549m 49.7 0 0|0 0|1 169k 42k 10 16:03:36
0 12 763 0 0 447 0 30.9g 64.4g 551m 30.2 0 0|0 0|1 197k 50k 10 16:03:37
0 7 689 0 0 394 0 30.9g 64.4g 551m 54.4 0 0|0 0|1 174k 43k 10 16:03:38
0 12 864 0 0 443 0 30.9g 64.4g 554m 42.2 0 0|0 0|0 213k 50k 10 16:03:39
0 3 509 0 0 290 0 30.9g 64.4g 549m 57.3 0 0|0 0|0 128k 31k 10 16:03:40
0 10 783 0 0 438 0 30.9g 64.4g 550m 44.7 0 0|0 0|1 197k 48k 10 16:03:41
0 8 500 0 0 304 0 30.9g 64.4g 549m 43.5 0 0|0 0|1 130k 34k 10 16:03:42
0 6 845 0 0 478 0 30.9g 64.4g 551m 33.6 0 0|0 0|0 213k 51k 10 16:03:43
0 9 626 0 0 339 0 30.9g 64.4g 548m 38.7 0 0|0 0|1 155k 38k 10 16:03:44
insert query update delete getmore command flushes mapped vsize res locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 5 582 0 0 353 0 30.9g 64.4g 550m 59 0 0|0 0|1 150k 38k 10 16:03:45
0 7 441 0 0 232 0 30.9g 64.4g 550m 60.7 0 0|0 0|0 110k 27k 10 16:03:46
0 5 81 0 2 43 0 30.9g 64.4g 552m 17.8 0 0|0 0|1 27k 8m 10 16:03:47
0 5 439 0 0 250 0 30.9g 64.4g 549m 69.3 0 0|0 0|0 112k 28k 10 16:03:48
0 7 659 0 0 378 0 30.9g 64.4g 552m 36.4 0 0|0 0|1 167k 41k 10 16:03:49
0 10 807 0 0 413 0 30.9g 64.4g 555m 49.7 0 0|0 0|1 198k 46k 10 16:03:50
0 6 710 0 0 409 0 30.9g 64.4g 551m 47 0 0|0 1|0 179k 44k 10 16:03:51
0 8 518 0 0 252 0 30.9g 64.4g 551m 59.5 0 0|0 0|0 127k 29k 10 16:03:52
0 9 639 0 0 395 0 30.9g 64.4g 552m 47.7 0 0|0 0|0 167k 44k 10 16:03:53
0 5 479 0 0 293 0 30.9g 64.4g 548m 56.5 0 0|0 0|1 123k 32k 10 16:03:54
insert query update delete getmore command flushes mapped vsize res locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 4 461 0 0 223 0 30.9g 64.4g 551m 40.7 0 0|0 0|1 110k 25k 10 16:03:55
0 2 104 0 0 50 0 30.9g 64.4g 548m 102 0 0|0 0|0 25k 6k 10 16:03:56
0 5 513 0 0 297 0 30.9g 64.4g 552m 60.3 0 0|0 0|1 131k 32k 10 16:03:57
0 5 441 0 0 253 0 30.9g 64.4g 554m 53.3 0 0|0 0|0 112k 28k 10 16:03:58
0 5 533 0 0 288 1 30.9g 64.4g 552m 56.4 0 0|0 0|1 131k 31k 10 16:03:59
0 7 559 0 0 331 0 30.9g 64.4g 548m 58.1 0 0|0 0|1 143k 37k 10 16:04:00
0 8 662 0 0 392 0 30.9g 64.4g 550m 48.1 0 0|0 0|0 172k 43k 10 16:04:01
0 7 731 0 0 408 0 30.9g 64.4g 554m 42.5 0 0|0 0|1 183k 44k 10 16:04:02
0 7 591 0 0 356 0 30.9g 64.4g 552m 54.8 0 0|0 0|0 153k 39k 10 16:04:03
0 6 562 0 0 309 0 30.9g 64.4g 553m 58.9 0 0|0 0|0 140k 34k 10 16:04:04
insert query update delete getmore command flushes mapped vsize res locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 4 456 0 0 279 0 30.9g 64.4g 551m 61.4 0 0|0 0|1 118k 30k 10 16:04:05
0 8 409 0 0 244 0 30.9g 64.4g 550m 62.7 0 0|0 0|1 106k 28k 10 16:04:06
0 7 620 0 0 371 0 30.9g 64.4g 552m 47.5 0 0|0 0|0 160k 41k 10 16:04:07
0 9 689 0 0 394 0 30.9g 64.4g 552m 34.1 0 0|0 0|1 174k 43k 10 16:04:08
0 5 331 0 0 162 0 30.9g 64.4g 551m 84.7 0 0|0 0|0 82k 18k 10 16:04:09
0 9 616 0 0 359 0 30.9g 64.4g 553m 54.9 0 0|0 0|0 159k 40k 10 16:04:10
0 5 687 0 0 414 0 30.9g 64.4g 551m 49.2 0 0|0 0|0 176k 44k 10 16:04:11
0 12 674 0 0 358 0 30.9g 64.4g 550m 46.5 0 0|0 0|0 170k 42k 10 16:04:12
0 9 541 0 0 265 0 30.9g 64.4g 553m 50 0 1|0 1|1 131k 30k 10 16:04:13
0 8 501 0 0 272 0 30.9g 64.4g 554m 49 0 0|0 0|0 127k 31k 10 16:04:14
insert query update delete getmore command flushes mapped vsize res locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 4 529 0 0 308 0 30.9g 64.4g 552m 60.8 0 0|0 0|0 133k 33k 10 16:04:15
0 6 441 0 0 276 0 30.9g 64.4g 552m 58.1 0 0|0 0|0 117k 31k 10 16:04:16
0 8 853 0 0 506 0 30.9g 64.4g 552m 43.6 0 0|0 0|0 218k 54k 10 16:04:17
0 4 435 0 0 259 0 30.9g 64.4g 552m 32.4 0 1|0 1|1 111k 28k 10 16:04:18
0 6 840 0 0 514 0 30.9g 64.4g 555m 50.7 0 0|0 0|0 217k 54k 10 16:04:19
0 6 438 0 0 283 0 30.9g 64.4g 555m 42.6 0 0|0 0|0 116k 31k 10 16:04:20
0 5 242 0 0 116 0 30.9g 64.4g 551m 70 0 0|0 0|1 59k 14k 10 16:04:21
0 6 419 0 0 258 0 30.9g 64.4g 551m 68.9 0 0|0 0|0 109k 28k 10 16:04:22
0 9 643 0 0 363 0 30.9g 64.4g 551m 42.9 0 0|1 1|1 161k 137k 10 16:04:23
0 7 468 0 2 237 0 30.9g 64.4g 555m 22.2 0 0|0 0|1 122k 8m 10 16:04:24
insert query update delete getmore command flushes mapped vsize res locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 7 572 0 0 299 0 30.9g 64.4g 554m 51.8 0 0|0 0|0 141k 33k 10 16:04:25
0 4 415 0 0 245 0 30.9g 64.4g 554m 57.4 0 0|0 1|0 104k 26k 10 16:04:26
0 6 453 0 0 272 0 30.9g 64.4g 552m 52.4 0 0|0 0|1 119k 31k 10 16:04:27
0 4 635 0 0 363 0 30.9g 64.4g 553m 58.6 0 0|0 0|1 160k 39k 10 16:04:28
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment