Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:39fd48d263365fd8cbb7f47c920f3913 Secret

Created June 14, 2024 23:39
Show Gist options
  • Save mdcallag/39fd48d263365fd8cbb7f47c920f3913 to your computer and use it in GitHub Desktop.
Save mdcallag/39fd48d263365fd8cbb7f47c920f3913 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
At end of the l.i0 step (initial load)
- MyRocks 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 3/0 63.24 MB 0.8 0.0 0.0 0.0 39.8 39.8 0.0 1.0 0.0 73.1 557.59 519.17 1933 0.288 0 0 0.0 0.0
L4 12/0 252.92 MB 1.0 0.0 0.0 0.0 0.0 0.0 35.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 100/0 2.06 GB 1.0 0.0 0.0 0.0 0.0 0.0 39.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 1818/0 20.61 GB 0.0 37.4 37.4 0.0 20.6 20.6 0.0 0.6 50.9 28.0 751.97 717.71 1817 0.414 751M 0 0.0 0.0
Sum 1933/0 22.98 GB 0.0 37.4 37.4 0.0 60.4 60.4 74.0 1.5 29.2 47.2 1309.56 1236.88 3750 0.349 751M 0 0.0 0.0
- MyRocks 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 3/0 63.23 MB 0.8 0.0 0.0 0.0 39.8 39.8 0.0 1.0 0.0 69.3 588.31 554.05 1934 0.304 413K 0 0.0 0.0
L4 12/0 247.02 MB 1.0 34.9 0.0 34.9 34.1 -0.8 34.9 0.0 59.1 57.7 604.93 575.89 1697 0.356 702M 0 0.0 0.0
L5 102/0 2.05 GB 1.0 4.3 0.0 4.3 4.2 -0.1 38.2 0.0 59.1 57.7 74.87 70.86 210 0.357 86M 0 0.0 0.0
L6 1816/0 20.58 GB 0.0 36.5 36.5 0.0 20.6 20.6 0.0 0.6 49.4 27.8 756.44 726.84 1815 0.417 750M 0 0.0 0.0
Sum 1933/0 22.93 GB 0.0 75.8 36.5 39.3 98.7 59.4 73.1 2.5 38.3 49.9 2024.55 1927.64 5656 0.358 1540M 0 0.0 0.0
- MyRocks 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 63.25 MB 0.8 0.0 0.0 0.0 39.8 39.8 0.0 1.0 0.0 68.9 591.63 559.30 1934 0.306 413K 0 0.0 0.0
L4 12/0 247.01 MB 1.0 34.9 0.0 34.9 34.1 -0.8 34.9 0.0 58.0 56.7 616.45 588.64 1697 0.363 702M 0 0.0 0.0
L5 102/0 2.05 GB 1.0 4.3 0.0 4.3 4.2 -0.1 38.2 0.0 58.3 56.9 75.95 72.43 210 0.362 86M 0 0.0 0.0
L6 1816/0 20.58 GB 0.0 36.5 36.5 0.0 20.6 20.6 0.0 0.6 48.2 27.1 775.87 748.60 1815 0.427 750M 0 0.0 0.0
Sum 1933/0 22.93 GB 0.0 75.8 36.5 39.3 98.7 59.4 73.1 2.5 37.7 49.1 2059.90 1968.97 5656 0.364 1540M 0 0.0 0.0
- MyRocks 5.6.35
Uptime(secs): 10261.3 total, 61.2 interval
Flush(GB): cumulative 39.787, interval 0.226
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: 60.38 GB write, 6.02 MB/s write, 37.40 GB read, 3.73 MB/s read, 1309.6 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@0x7fae9eb9c330#579112 capacity: 8.00 GB seed: 607460531 usage: 1.17 GB table_size: 8192 occupancy: 5721 collections: 18 last_copies: 1 last_secs: 0.001304 secs_since: 61
Block cache entry stats(count,size,portion): DataBlock(10,5.81 KB,6.92904e-05%) FilterBlock(1948,961.06 MB,11.7317%) IndexBlock(3762,233.41 MB,2.84922%) Misc(1,0.00 KB,0%)
- MyRocks 8.0.28
Uptime(secs): 14074.6 total, 274.5 interval
Flush(GB): cumulative 39.787, interval 0.782
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: 98.70 GB write, 7.18 MB/s write, 75.77 GB read, 5.51 MB/s read, 2024.6 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, mem
table-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@0x7f33ccefc950#600588 capacity: 8.00 GB seed: 607460531 usage: 1.26 GB table_size: 9984 occupancy: 7504 collections: 24 last_copies: 1 last_secs: 0.001601 secs_since: 274
Block cache entry stats(count,size,portion): DataBlock(9,3.19 KB,3.7998e-05%) FilterBlock(1919,947.56 MB,11.5669%) IndexBlock(5575,347.01 MB,4.23598%) Misc(1,0.00 KB,0%)
- MyRocks 8.0.32
Uptime(secs): 14985.3 total, 585.2 interval
Flush(GB): cumulative 39.790, interval 1.544
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: 98.70 GB write, 6.74 MB/s write, 75.77 GB read, 5.18 MB/s read, 2059.9 seconds
Estimated pending compaction bytes: 0
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, mem
table-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@0x7faacd3e3990#623772 capacity: 8.00 GB seed: 607460531 usage: 1.23 GB table_size: 8704 occupancy: 7357 collections: 25 last_copies: 1 last_secs: 0.00154 secs_since: 585
Block cache entry stats(count,size,portion): DataBlock(9,3.19 KB,3.7998e-05%) FilterBlock(1882,918.87 MB,11.2167%) IndexBlock(5464,340.06 MB,4.15117%) Misc(1,0.00 KB,0%)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment