Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created August 17, 2023 17:21
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/86a5d1716d723941a7c5158fb71ca52c to your computer and use it in GitHub Desktop.
Save mdcallag/86a5d1716d723941a7c5158fb71ca52c to your computer and use it in GitHub Desktop.
--- from 800m.fbmy5635_rel_202104072149.cy10a5_bee at the end of q1000
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 51.11 MB 0.8 2.1 0.0 2.1 64.7 62.6 0.0 0.7 1.9 57.6 1150.61 1095.60 3381 0.340 78M 0 0.0 0.0
L3 4/0 222.31 MB 0.9 80.4 22.8 57.6 79.0 21.4 0.0 3.5 54.3 53.3 1516.38 2465.19 214 7.086 3207M 2423K 0.0 0.0
L4 10/0 510.56 MB 1.0 43.2 18.9 24.3 43.0 18.7 37.6 2.3 35.7 35.5 1240.18 1223.20 294 4.218 1748M 0 0.0 0.0
L5 89/0 4.99 GB 1.0 86.4 19.9 66.5 85.7 19.2 39.9 4.3 33.3 33.0 2657.88 2617.22 311 8.546 3732M 0 0.0 0.0
L6 2241/0 49.99 GB 0.0 88.6 54.5 34.1 58.1 24.1 25.9 1.1 29.6 19.4 3067.83 2836.30 2556 1.200 2711M 303M 0.0 0.0
Sum 2347/0 55.75 GB 0.0 300.7 116.2 184.5 330.5 146.0 103.5 3.7 32.0 35.1 9632.88 10237.51 6756 1.426 11G 305M 0.0 0.0
Uptime(secs): 34998.5 total, 198.1 interval
Flush(GB): cumulative 62.710, interval 0.033
AddFile(GB): cumulative 25.921, interval 0.000
AddFile(Total Files): cumulative 280, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 2400300000, interval 0
Cumulative compaction: 330.53 GB write, 9.67 MB/s write, 300.70 GB read, 8.80 MB/s read, 9632.9 seconds
Interval compaction: 0.03 GB write, 0.17 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.8 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 pending_compaction_bytes, 0 memtable_compactio
n, 0 memtable_slowdown, interval 0 total count
--- from 800m.fbmy5635_rel_20230529_850.cy10a5_bee at the end of q1000
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 0/0 0.00 KB 0.0 2.7 0.0 2.7 65.3 62.6 0.0 0.7 2.3 54.7 1221.71 1165.84 3307 0.369 100M 0 0.0 0.0
L3 5/0 237.09 MB 0.9 93.4 22.8 70.5 92.0 21.5 0.0 4.0 55.1 54.3 1736.71 3321.83 225 7.719 3762M 0 0.0 0.0
L4 9/0 490.87 MB 1.0 27.3 14.9 12.4 27.1 14.7 41.7 1.8 27.5 27.3 1015.83 955.55 213 4.769 1111M 0 0.0 0.0
L5 76/0 4.96 GB 1.0 62.6 17.8 44.8 61.9 17.1 42.1 3.5 24.6 24.3 2601.73 2321.23 420 6.195 2657M 0 0.0 0.0
L6 2243/0 50.00 GB 0.0 81.0 54.6 26.4 50.4 24.1 25.9 0.9 24.1 15.0 3437.19 2898.91 2573 1.336 2014M 292M 0.0 0.0
Sum 2333/0 55.67 GB 0.0 267.0 110.2 156.8 296.7 140.0 109.8 3.3 27.3 30.3 10013.16 10663.37 6738 1.486 9646M 292M 0.0 0.0
Uptime(secs): 35746.8 total, 337.2 interval
Flush(GB): cumulative 62.694, interval 0.068
AddFile(GB): cumulative 25.918, interval 0.000
AddFile(Total Files): cumulative 280, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 2400300000, interval 0
Cumulative compaction: 296.72 GB write, 8.50 MB/s write, 266.96 GB read, 7.65 MB/s read, 10013.2 seconds
Interval compaction: 0.34 GB write, 1.03 MB/s write, 0.28 GB read, 0.84 MB/s read, 6.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, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 0
Block cache LRUCache@0x7f5be7183330#3162647 capacity: 8.00 GB seed: 607460531 usage: 7.99 GB table_size: 1048576 occupancy: 962114 collections: 60 last_copies: 1 last_secs: 0.250754 secs_since: 337
Block cache entry stats(count,size,portion): DataBlock(961292,7.43 GB,92.8153%) FilterBlock(115,279.63 MB,3.41343%) IndexBlock(709,212.26 MB,2.59105%) Misc(1,0.00 KB,0%)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment