Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:4d07cff7c857f3cca27ce2020bb75323

Created June 5, 2020 14:31
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/4d07cff7c857f3cca27ce2020bb75323 to your computer and use it in GitHub Desktop.
Save mdcallag/4d07cff7c857f3cca27ce2020bb75323 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
--- without bloom filter
Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 2/0 72.04 MB 0.5 0.0 0.0 0.0 67.2 67.2 0.0 1.0 0.0 82.7 831.28 693.90 1913 0.435 0 0
L3 3/0 193.54 MB 0.8 71.4 31.4 40.0 69.5 29.5 0.0 2.2 54.7 53.2 1338.14 1128.07 132 10.137 2364M 0
L4 9/0 518.22 MB 0.9 129.3 55.9 73.3 126.9 53.5 4.9 2.3 48.7 47.7 2720.89 2047.27 457 5.954 4467M 0
L5 105/0 5.40 GB 1.0 244.9 60.7 184.2 243.9 59.7 1.0 4.0 30.5 30.4 8211.44 4343.12 944 8.699 9417M 0
L6 905/0 54.38 GB 0.0 193.4 55.6 137.9 192.2 54.4 0.0 3.5 27.8 27.6 7132.77 3516.67 906 7.873 7644M 0
Sum 1024/0 60.54 GB 0.0 639.1 203.7 435.4 699.6 264.2 5.9 10.4 32.3 35.4 20234.53 11729.03 4352 4.649 23G 0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0
Uptime(secs): 12926.5 total, 326.4 interval
Flush(GB): cumulative 67.166, interval 0.000
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 699.65 GB write, 55.42 MB/s write, 639.10 GB read, 50.63 MB/s read, 20234.5 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
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 pen
ding_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
--- with bloom filter, format_version=4
Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 2/0 74.69 MB 0.5 0.0 0.0 0.0 69.6 69.6 0.0 1.0 0.0 73.4 971.73 837.18 1913 0.508 0 0
L3 4/0 232.92 MB 0.9 80.9 22.4 58.5 79.3 20.8 0.0 3.5 34.0 33.4 2434.58 1580.71 60 40.576 1904M 0
L4 8/0 496.20 MB 0.9 192.3 57.3 135.0 189.1 54.1 4.9 3.3 35.7 35.1 5521.59 3640.09 273 20.226 4415M 0
L5 103/0 5.44 GB 1.0 143.4 56.9 86.5 142.6 56.1 6.9 2.5 28.2 28.0 5211.54 2891.10 726 7.178 4709M 0
L6 908/0 54.58 GB 0.0 161.9 57.8 104.1 158.6 54.6 0.0 2.7 27.3 26.7 6080.65 3061.20 808 7.526 6181M 0
Sum 1025/0 60.80 GB 0.0 578.5 194.5 384.0 639.3 255.3 11.9 9.2 29.3 32.4 20220.09 12010.28 3780 5.349 17G 0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 71.2 0.52 0.47 1 0.525 0 0
Uptime(secs): 16063.8 total, 463.7 interval
Flush(GB): cumulative 69.649, interval 0.036
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 639.28 GB write, 40.75 MB/s write, 578.48 GB read, 36.88 MB/s read, 20220.1 seconds
Interval compaction: 0.04 GB write, 0.08 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.5 seconds
Stalls(count): 2540 level0_slowdown, 2492 level0_slowdown_with_compaction, 31 level0_numfiles, 31 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
Cumulative stall: 01:03:33.776 H:M:S, 23.7 percent
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment