Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:791f0a07e46caf6c7cdc

Created February 9, 2016 15:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/791f0a07e46caf6c7cdc to your computer and use it in GitHub Desktop.
Save mdcallag/791f0a07e46caf6c7cdc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
*************************** 1. row ***************************
Type: DBSTATS
Name: rocksdb
Status:
** DB Stats **
Uptime(secs): 302101.6 total, 360.5 interval
Cumulative writes: 3742M writes, 19G keys, 3280M batches, 1.1 writes per batch, ingest: 1545.50 GB, 5.24 MB/s
Cumulative WAL: 3742M writes, 17 syncs, 207918666.61 writes per sync, written: 1545.50 GB, 5.24 MB/s
Cumulative compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 4940K writes, 11M keys, 4376K batches, 1.1 writes per batch, ingest: 1014.25 MB, 2.81 MB/s
Interval WAL: 4940K writes, 0 syncs, 4940514.00 writes per sync, written: 0.99 MB, 2.81 MB/s
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
*************************** 2. row ***************************
Type: CF_COMPACTION
Name: __system__
Status:
** Compaction Stats [__system__] **
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) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.3 1 383 0.004 0 0
L6 1/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.3 6.6 1.9 0 96 0.001 3815 1415
Sum 1/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.4 0.4 0.4 2 479 0.003 3815 1415
Int 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.5 3.4 1.5 0 2 0.001 41 16
Flush(GB): cumulative 0.000, interval 0.000
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 3. row ***************************
Type: CF_COMPACTION
Name: cf_count_pk
Status:
** Compaction Stats [cf_count_pk] **
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) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 1/0 83.13 0.2 0.0 0.0 0.0 82.9 82.9 0.0 0.0 0.0 76.2 1114 1021 1.092 0 0
L4 5/0 130.13 0.9 92.0 92.0 0.0 89.4 89.4 0.0 1.0 59.8 58.1 1575 237 6.647 2134M 45M
L5 66/0 1360.54 1.0 203.7 53.6 150.1 199.8 49.7 26.0 3.7 45.0 44.2 4631 1684 2.750 4721M 78M
L6 460/0 13699.75 0.0 355.4 70.6 284.9 293.8 8.9 4.5 4.2 7.5 6.2 48468 2160 22.439 28G 539M
Sum 532/0 15273.55 0.0 651.1 216.1 435.0 666.0 231.0 30.4 8.0 12.0 12.2 55789 5102 10.935 35G 664M
Int 0/0 0.00 0.0 0.0 0.0 0.0 0.1 0.1 0.0 1.0 0.0 72.9 1 1 1.140 0 0
Flush(GB): cumulative 82.923, interval 0.081
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 4. row ***************************
Type: CF_COMPACTION
Name: cf_link_pk
Status:
** Compaction Stats [cf_link_pk] **
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) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 2/0 144.43 0.5 0.0 0.0 0.0 322.9 322.9 0.0 0.0 0.0 93.0 3555 4534 0.784 0 0
L3 3/0 98.62 1.0 228.5 228.5 0.0 221.8 221.8 0.0 1.0 71.4 69.3 3279 697 4.704 4400M 110M
L4 51/0 1009.35 1.0 582.4 241.4 341.1 575.1 234.1 70.9 2.4 61.2 60.4 9744 4499 2.166 11G 120M
L5 477/0 10160.98 1.0 979.4 201.3 778.1 871.1 93.0 108.6 4.3 14.0 12.5 71603 6214 11.523 32G 464M
L6 3341/0 101824.12 0.0 548.8 174.0 374.8 458.8 84.1 15.6 2.6 12.5 10.4 45059 3791 11.886 23G 406M
Sum 3874/0 113237.49 0.0 2339.1 845.2 1493.9 2449.7 955.8 195.0 7.6 18.0 18.8 133239 19735 6.751 71G 1100M
Int 0/0 0.00 0.0 4.7 0.9 3.8 4.6 0.9 0.0 32.8 16.7 16.4 290 23 12.595 149M 3520K
Flush(GB): cumulative 322.926, interval 0.141
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 5. row ***************************
Type: CF_COMPACTION
Name: cf_node_pk
Status:
** Compaction Stats [cf_node_pk] **
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) KeyIn KeyDrop
------------------------------------------------------------------------------------------------------------------------------------------------------------------
---
L0 1/0 113.57 0.2 0.0 0.0 0.0 494.1 494.1 0.0 0.0 0.0 244.5 2069 4435 0.466 0 0
L3 6/0 193.91 1.0 358.4 358.4 0.0 355.9 355.9 148.4 1.0 173.0 171.8 2121 597 3.553 1705M 9905K
L4 136/0 2004.39 1.0 337.5 183.5 154.1 335.8 181.8 302.3 1.8 131.8 131.1 2622 5570 0.471 1657M 6897K
L5 1028/0 20254.48 1.0 2061.6 407.5 1654.1 1956.7 302.6 79.6 4.8 25.7 24.4 82284 9804 8.393 10G 97M
L6 6773/0 202696.97 0.0 2021.1 228.7 1792.4 1856.0 63.6 134.3 8.1 21.7 19.9 95296 6436 14.807 12G 904M
Sum 7944/0 225263.33 0.0 4778.6 1178.0 3600.5 4998.6 1398.0 664.6 10.1 26.5 27.8 184392 26842 6.870 25G 1018M
Int 0/0 0.00 0.0 6.4 1.5 4.9 6.4 1.5 0.3 19.3 28.7 28.7 228 33 6.923 34M 1482K
Flush(GB): cumulative 494.055, interval 0.333
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0
slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 6. row ***************************
Type: CF_COMPACTION
Name: default
Status:
** 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) KeyIn KeyDrop
------------------------------------------------------------------------------------------------------------------------------------------------------------------
---
Sum 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Int 0/0 0.00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 0.000 0 0
Flush(GB): cumulative 0.000, interval 0.000
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0
slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 7. row ***************************
Type: CF_COMPACTION
Name: rev:cf_link_id1_type
Status:
** Compaction Stats [rev:cf_link_id1_type] **
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) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 3/0 218.12 0.8 0.0 0.0 0.0 392.6 392.6 0.0 0.0 0.0 81.1 4958 5419 0.915 0 0
L3 5/0 123.58 1.0 361.0 361.0 0.0 348.2 348.2 0.0 1.0 67.9 65.5 5442 1007 5.404 6890M 107M
L4 60/0 1231.95 1.0 861.1 273.5 587.6 844.8 257.2 106.3 3.1 57.0 56.0 15458 6434 2.403 16G 141M
L5 581/0 12575.78 1.0 1413.7 268.7 1145.0 1268.1 123.1 93.2 4.7 12.8 11.5 113189 8241 13.735 42G 463M
L6 4183/0 125847.61 0.0 656.9 154.3 502.6 575.8 73.2 49.8 3.7 11.6 10.2 57978 4822 12.024 24G 425M
Sum 4832/0 139997.04 0.0 3292.7 1057.5 2235.2 3429.4 1194.2 249.3 8.7 17.1 17.8 197025 25923 7.600 90G 1137M
Int 0/0 0.00 0.0 4.4 0.9 3.4 4.4 1.0 0.0 15.6 16.8 17.0 266 23 11.582 117M 1795K
Flush(GB): cumulative 392.631, interval 0.284
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
*************************** 8. row ***************************
Type: Memory_Stats
Name: rocksdb
Status:
** Compaction Stats [rev:cf_link_id1_type] **
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) KeyIn KeyDrop
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 3/0 218.12 0.8 0.0 0.0 0.0 392.6 392.6 0.0 0.0 0.0 81.1 4958 5419 0.915 0 0
L3 5/0 123.58 1.0 361.0 361.0 0.0 348.2 348.2 0.0 1.0 67.9 65.5 5442 1007 5.404 6890M 107M
L4 60/0 1231.95 1.0 861.1 273.5 587.6 844.8 257.2 106.3 3.1 57.0 56.0 15458 6434 2.403 16G 141M
L5 581/0 12575.78 1.0 1413.7 268.7 1145.0 1268.1 123.1 93.2 4.7 12.8 11.5 113189 8241 13.735 42G 463M
L6 4183/0 125847.61 0.0 656.9 154.3 502.6 575.8 73.2 49.8 3.7 11.6 10.2 57978 4822 12.024 24G 425M
Sum 4832/0 139997.04 0.0 3292.7 1057.5 2235.2 3429.4 1194.2 249.3 8.7 17.1 17.8 197025 25923 7.600 90G 1137M
Int 0/0 0.00 0.0 4.4 0.9 3.4 4.4 1.0 0.0 15.6 16.8 17.0 266 23 11.582 117M 1795K
Flush(GB): cumulative 392.631, interval 0.284
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
MemTable Total: 235468048
MemTable Unflushed: 214372944
Table Readers Total: 0
Cache Total: 85899284436
Default Cache Capacity: 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment