Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created December 31, 2023 23:57
Show Gist options
  • Save mdcallag/9253a472cac70e6e94f3d811d432c870 to your computer and use it in GitHub Desktop.
Save mdcallag/9253a472cac70e6e94f3d811d432c870 to your computer and use it in GitHub Desktop.
--- 5.6.35
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 Rblob(GB) Wblob(GB)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 1/0 16.94 MB 0.2 80.3 0.0 80.3 362.5 282.2 0.0 1.2 10.0 45.0 8244.10 8220.26 17708 0.466 2811M 0 0.0 0.0
L3 8/0 393.54 MB 14.4 1050.3 258.4 791.9 1042.7 250.7 0.0 4.0 124.7 123.7 8627.97 32582.67 1677 5.145 41G 0 0.0 0.0
L4 9/4 576.44 MB 0.8 139.5 78.3 61.2 139.3 78.2 190.7 1.8 52.5 52.4 2721.21 3371.41 599 4.543 4509M 0 0.0 0.0
L5 61/18 3.20 GB 0.7 951.6 261.5 690.1 949.8 259.7 11.4 3.6 34.9 34.9 27891.63 27954.79 3372 8.272 37G 0 0.0 0.0
L6 609/0 31.27 GB 0.0 1528.7 268.5 1260.2 1274.2 14.0 17.3 4.7 29.8 24.8 52541.98 52446.59 17400 3.020 76G 9430M 0.0 0.0
Sum 688/22 35.43 GB 0.0 3750.3 866.7 2883.7 3768.5 884.8 219.5 12.5 38.4 38.6 100026.91 124575.71 40756 2.454 163G 9430M 0.0 0.0
--- 8.0.28
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 Rblob(GB) Wblob(GB)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 2/0 33.92 MB 0.5 92.9 0.0 92.9 374.9 281.9 0.0 1.2 10.8 43.6 8808.08 8780.26 17866 0.493 3251M 0 0.0 0.0
L3 4/0 314.68 MB 10.9 1025.6 258.1 767.5 1018.2 250.7 0.0 3.9 117.9 117.0 8910.33 33425.45 1593 5.593 40G 0 0.0 0.0
L4 8/1 570.36 MB 10.5 133.7 74.5 59.2 133.5 74.3 194.9 1.8 51.3 51.2 2668.84 3359.32 551 4.844 4279M 0 0.0 0.0
L5 77/5 3.25 GB 0.9 937.4 259.6 677.8 935.6 257.8 13.4 3.6 33.2 33.2 28890.09 28932.99 3320 8.702 37G 0 0.0 0.0
L6 598/0 31.27 GB 0.0 1525.3 268.4 1256.9 1270.8 14.0 17.3 4.7 27.1 22.6 57618.39 57519.34 16916 3.406 76G 9429M 0.0 0.0
Sum 689/6 35.42 GB 0.0 3714.9 860.5 2854.4 3733.0 878.6 225.7 12.4 35.6 35.8 106895.73 132017.36 40246 2.656 162G 9429M 0.0 0.0
--- 8.0.32
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 Rblob(GB) Wblob(GB)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 3/0 50.93 MB 0.8 88.3 0.0 88.3 370.3 282.0 0.0 1.2 10.6 44.6 8506.04 8478.16 17810 0.478 3088M 0 0.0 0.0
L3 8/0 407.45 MB 13.3 1033.7 258.1 775.6 1026.3 250.7 0.0 4.0 121.0 120.2 8744.76 32825.84 1632 5.358 40G 0 0.0 0.0
L4 6/2 413.92 MB 0.9 142.2 78.6 63.6 142.0 78.4 190.7 1.8 51.5 51.4 2829.32 3546.67 572 4.946 4586M 0 0.0 0.0
L5 72/15 3.09 GB 0.7 919.1 260.0 659.0 917.3 258.2 13.0 3.5 33.9 33.8 27779.04 27820.90 3337 8.325 36G 0 0.0 0.0
L6 622/3 31.27 GB 0.0 1520.5 268.7 1251.9 1265.8 14.0 17.3 4.7 27.7 23.1 56233.63 56122.17 17288 3.253 76G 9438M 0.0 0.0
Sum 711/20 35.21 GB 0.0 3703.8 865.4 2838.4 3721.7 883.3 221.0 12.4 36.4 36.6 104092.79 128793.73 40639 2.561 161G 9438M 0.0 0.0
--- 5.6.35
Uptime(secs): 22267.7 total, 33.4 interval
Flush(GB): cumulative 283.664, interval 0.267
AddFile(GB): cumulative 17.307, interval 0.000
AddFile(Total Files): cumulative 216, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 1440007200, interval 0
Cumulative compaction: 3768.47 GB write, 173.30 MB/s write, 3750.34 GB read, 172.46 MB/s read, 100026.9 seconds
Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pend
ing-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0
Block cache LRUCache@0x7fcf25990330#1805539 capacity: 180.00 GB seed: 363166142 usage: 179.94 GB table_size: 16777216 occupancy: 8801760 collections: 15 last_copies: 7 last_secs: 3.95843 secs_since: 1833
Block cache entry stats(count,size,portion): DataBlock(8673499,66.95 GB,37.1948%) FilterBlock(53172,99.55 GB,55.3068%) IndexBlock(75162,12.65 GB,7.02979%) Misc(2,8.09 KB,4.28822e-06%)
--- 8.0.28
Uptime(secs): 21989.5 total, 353.7 interval
Flush(GB): cumulative 283.579, interval 3.017
AddFile(GB): cumulative 17.305, interval 0.000
AddFile(Total Files): cumulative 216, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 1440007200, interval 0
Cumulative compaction: 3733.04 GB write, 173.84 MB/s write, 3714.93 GB read, 173.00 MB/s read, 106895.7 seconds
Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pend
ing-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0
Block cache LRUCache@0x7f063b5f68b0#4193641 capacity: 180.00 GB seed: 363166142 usage: 179.95 GB table_size: 16777216 occupancy: 8740243 collections: 15 last_copies: 7 last_secs: 4.60107 secs_since: 2153
Block cache entry stats(count,size,portion): DataBlock(8612227,66.48 GB,36.9325%) FilterBlock(52925,99.95 GB,55.528%) IndexBlock(74676,12.75 GB,7.08426%) Misc(13,97.12 KB,5.14587e-05%)
--- 8.0.32
Uptime(secs): 22065.4 total, 428.2 interval
Flush(GB): cumulative 283.582, interval 3.621
AddFile(GB): cumulative 17.305, interval 0.000
AddFile(Total Files): cumulative 216, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 1440007200, interval 0
Cumulative compaction: 3721.71 GB write, 172.71 MB/s write, 3703.80 GB read, 171.88 MB/s read, 104092.8 seconds
Interval compaction: 57.26 GB write, 136.94 MB/s write, 57.30 GB read, 137.03 MB/s read, 1686.7 seconds
Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 0, pending-compaction-bytes-delays: 0, pend
ing-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0
Block cache LRUCache@0x7f55b71f97b0#2364682 capacity: 180.00 GB seed: 363166142 usage: 179.95 GB table_size: 16777216 occupancy: 8858965 collections: 15 last_copies: 5 last_secs: 4.4371 secs_since: 1628
Block cache entry stats(count,size,portion): DataBlock(8729259,67.38 GB,37.434%) FilterBlock(52716,99.14 GB,55.0753%) IndexBlock(74749,12.65 GB,7.03025%) Misc(6,40.47 KB,2.14411e-05%)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment