Skip to content

Instantly share code, notes, and snippets.

@vadimtk
Created October 12, 2015 16:49
Show Gist options
  • Save vadimtk/84523a2d56a7382e0a53 to your computer and use it in GitHub Desktop.
Save vadimtk/84523a2d56a7382e0a53 to your computer and use it in GitHub Desktop.
MongoRocks - metricbench
> db.serverStatus()["rocksdb"]
{
"stats" : [
"",
"** Compaction Stats [default] **",
"Level Files Size(MB) Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) Comp(cnt) Avg(sec) Stall(cnt) KeyIn KeyDrop",
"---------------------------------------------------------------------------------------------------------------------------------------------------------------------",
" L0 9/7 788 0.5 0.0 0.0 0.0 158.5 158.5 0.0 0.0 0.0 21.4 7581 1846 4.107 6 0 0",
" L4 7/7 972 0.0 308.1 308.1 0.0 312.8 312.8 0.0 1.0 15.4 15.7 20455 322 63.526 41 23G 7132K",
" L5 79/4 12520 1.0 865.2 178.5 686.7 866.5 179.7 0.3 4.9 17.0 17.0 52073 797 65.336 1 57G 946K",
" L6 556/30 119198 0.0 1141.9 154.5 987.4 1107.8 120.4 0.0 7.2 10.0 9.7 116596 621 187.755 0 126G 108K",
" Sum 651/48 133477 0.0 2315.2 641.1 1674.1 2445.6 771.5 0.3 15.4 12.1 12.7 196705 3586 54.854 48 207G 8187K",
" Int 0/0 0 0.0 0.0 0.0 0.0 0.2 0.2 0.0 1.0 0.0 20.8 8 2 4.205 0 0 0",
"Flush(GB): cumulative 158.462, interval 0.171",
"Stalls(count): 6 level0_slowdown, 0 level0_numfiles, 0 memtable_compaction, 42 leveln_slowdown_soft, 0 leveln_slowdown_hard",
"",
"** DB Stats **",
"Uptime(secs): 60761.5 total, 62.5 interval",
"Cumulative writes: 2057M writes, 12G keys, 718M batches, 2.9 writes per batch, ingest: 416.11 GB, 7.01 MB/s",
"Cumulative WAL: 2057M writes, 718M syncs, 2.86 writes per sync, written: 416.11 GB, 7.01 MB/s",
"Cumulative compaction: 2445.56 GB write, 41.21 MB/s write, 2315.21 GB read, 39.02 MB/s read, 196705.1 seconds",
"Cumulative stall: 00:08:58.908 H:M:S, 0.9 percent",
"Interval writes: 2086K writes, 12M keys, 735K batches, 2.8 writes per batch, ingest: 435.33 MB, 6.97 MB/s",
"Interval WAL: 2086K writes, 735K syncs, 2.84 writes per sync, written: 0.43 MB, 6.97 MB/s",
"Interval compaction: 0.17 GB write, 2.80 MB/s write, 0.00 GB read, 0.00 MB/s read, 8.4 seconds",
"Interval stall: 00:00:0.000 H:M:S, 0.0 percent"
],
"num-immutable-mem-table" : "0",
"mem-table-flush-pending" : "0",
"compaction-pending" : "0",
"background-errors" : "0",
"cur-size-active-mem-table" : "299MB",
"cur-size-all-mem-tables" : "299MB",
"num-entries-active-mem-table" : "5109969",
"num-entries-imm-mem-tables" : "0",
"estimate-table-readers-mem" : "15502MB",
"num-snapshots" : "15",
"oldest-snapshot-time" : "1444668553",
"num-live-versions" : "2",
"total-live-recovery-units" : 19,
"block-cache-usage" : "12287MB",
"transaction-engine-keys" : NumberLong(100),
"transaction-engine-snapshots" : NumberLong(14),
"thread-status" : [
{
"type" : "Compaction",
"time_elapsed" : "01:15.736 M:S",
"job_id" : 5636,
"input_level" : 5,
"output_level" : 6,
"manual" : 0,
"bytes_read" : "729MB",
"bytes_written" : "845MB",
"total_bytes" : "2336MB",
"read_throughput" : "9865KB/s",
"write_throughput" : "11426KB/s"
},
{
"type" : "Compaction",
"time_elapsed" : "01:15.736 M:S",
"job_id" : 5635,
"input_level" : 0,
"output_level" : 4,
"manual" : 0,
"bytes_read" : "943MB",
"bytes_written" : "1056MB",
"total_bytes" : "1584MB",
"read_throughput" : "12759KB/s",
"write_throughput" : "14277KB/s"
},
{
"type" : "Compaction",
"time_elapsed" : "01:15.736 M:S",
"job_id" : 5638,
"input_level" : 5,
"output_level" : 6,
"manual" : 0,
"bytes_read" : "767MB",
"bytes_written" : "772MB",
"total_bytes" : "2329MB",
"read_throughput" : "10383KB/s",
"write_throughput" : "10439KB/s"
},
{
"type" : "Compaction",
"time_elapsed" : "01:15.736 M:S",
"job_id" : 5637,
"input_level" : 5,
"output_level" : 6,
"manual" : 0,
"bytes_read" : "766MB",
"bytes_written" : "755MB",
"total_bytes" : "2413MB",
"read_throughput" : "10360KB/s",
"write_throughput" : "10217KB/s"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment