Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:bef0cecd41fea8e5b4f00a8d1f3df843 Secret

Created June 22, 2023 23:38
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/bef0cecd41fea8e5b4f00a8d1f3df843 to your computer and use it in GitHub Desktop.
Save mdcallag/bef0cecd41fea8e5b4f00a8d1f3df843 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
lz4 for all levels
--- leveled
** Compaction Stats [default] **
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 29.70 MB 0.2 0.0 0.0 0.0 6.3 6.3 0.0 1.0 0.0 87.3 73.48 58.57 216 0.340 0 0 0.0 0.0
L4 5/0 148.50 MB 0.6 0.0 0.0 0.0 0.0 0.0 3.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 17/0 504.91 MB 0.9 0.0 0.0 0.0 0.0 0.0 5.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 193/0 5.60 GB 0.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
Sum 216/0 6.26 GB 0.0 0.0 0.0 0.0 6.3 6.3 14.9 1.0 0.0 87.3 73.48 58.57 216 0.340 0 0 0.0 0.0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.2 6.2 14.9 1.0 0.0 87.3 73.14 58.30 215 0.340 0 0 0.0 0.0
** Compaction Stats [default] **
Priority 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)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.3 6.3 0.0 0.0 0.0 87.3 73.48 58.57 216 0.340 0 0 0.0 0.0
Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0
Uptime(secs): 419.9 total, 416.9 interval
Flush(GB): cumulative 6.265, interval 6.236
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: 6.26 GB write, 15.28 MB/s write, 0.00 GB read, 0.00 MB/s read, 73.5 seconds
Interval compaction: 6.24 GB write, 15.32 MB/s write, 0.00 GB read, 0.00 MB/s read, 73.1 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-sts0
Block cache LRUCache@0x7f304a027290#1950476 capacity: 32.00 MB seed: 571812302 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 1 last_copies: 1 last_secs: 0.000153 secs_since: 419
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
** File Read Latency Histogram By Level [default] **
** DB Stats **
Uptime(secs): 419.9 total, 416.9 interval
Cumulative writes: 100M writes, 100M keys, 100M commit groups, 1.0 writes per commit group, ingest: 12.20 GB, 29.75 MB/s
Cumulative WAL: 100M writes, 0 syncs, 100000000.00 writes per sync, written: 12.20 GB, 29.75 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 99M writes, 99M keys, 99M commit groups, 1.0 writes per commit group, ingest: 12409.57 MB, 29.77 MB/s
Interval WAL: 99M writes, 0 syncs, 99331122.00 writes per sync, written: 12.12 GB, 29.77 MB/s
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
Write Stall (count): write-buffer-manager-limit-stops: 0
--- universal without trivial move
** Compaction Stats [default] **
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 8/0 237.60 MB 2.5 0.0 0.0 0.0 6.3 6.3 0.0 1.0 0.0 80.2 79.97 63.92 216 0.370 0 0 0.0 0.0
L2 2/0 111.94 MB 0.0 1.5 1.5 0.0 1.4 1.4 0.0 0.9 76.3 71.9 20.23 20.12 21 0.964 23M 0 0.0 0.0
L3 9/9 531.74 MB 0.0 11.9 3.3 8.6 11.8 3.1 0.0 3.6 72.0 71.2 168.91 167.03 68 2.484 198M 0 0.0 0.0
L4 7/7 447.77 MB 0.0 3.3 2.0 1.3 3.2 2.0 0.0 1.6 72.8 71.7 46.07 45.51 18 2.560 54M 0 0.0 0.0
L5 11/11 643.67 MB 0.0 3.1 2.4 0.6 3.0 2.4 0.0 1.2 75.2 73.4 41.59 41.21 8 5.198 50M 0 0.0 0.0
L6 64/0 3.99 GB 0.0 6.9 4.0 2.9 6.9 4.0 0.0 1.7 72.7 72.6 96.74 95.32 5 19.348 115M 0 0.0 0.0
Sum 101/27 5.92 GB 0.0 26.6 13.2 13.4 32.5 19.1 0.0 5.2 60.0 73.4 453.51 433.11 336 1.350 442M 0 0.0 0.0
Int 0/0 0.00 KB 0.0 26.6 13.2 13.4 32.5 19.1 0.0 5.2 60.1 73.4 453.16 432.82 335 1.353 442M 0 0.0 0.0
** Compaction Stats [default] **
Priority 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)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Low 0/0 0.00 KB 0.0 26.6 13.2 13.4 26.2 12.9 0.0 0.0 72.9 71.9 373.54 369.19 120 3.113 442M 0 0.0 0.0
High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.3 6.3 0.0 0.0 0.0 80.2 79.97 63.92 216 0.370 0 0 0.0 0.0
Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0
Uptime(secs): 457.6 total, 454.6 interval
Flush(GB): cumulative 6.265, interval 6.236
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: 32.50 GB write, 72.73 MB/s write, 26.59 GB read, 59.49 MB/s read, 453.5 seconds
Interval compaction: 32.47 GB write, 73.15 MB/s write, 26.59 GB read, 59.89 MB/s read, 453.2 seconds
Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-o0
interval: 12 total count
Block cache LRUCache@0x7f9b00227290#1981184 capacity: 32.00 MB seed: 993519253 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 1 last_copies: 1 last_secs: 0.000115 secs_since: 457
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
** File Read Latency Histogram By Level [default] **
** DB Stats **
Uptime(secs): 457.6 total, 454.6 interval
Cumulative writes: 100M writes, 100M keys, 100M commit groups, 1.0 writes per commit group, ingest: 12.20 GB, 27.30 MB/s
Cumulative WAL: 100M writes, 0 syncs, 100000000.00 writes per sync, written: 12.20 GB, 27.30 MB/s
Cumulative stall: 00:00:26.714 H:M:S, 5.8 percent
Interval writes: 99M writes, 99M keys, 99M commit groups, 1.0 writes per commit group, ingest: 12407.42 MB, 27.29 MB/s
Interval WAL: 99M writes, 0 syncs, 99313949.00 writes per sync, written: 12.12 GB, 27.29 MB/s
Interval stall: 00:00:26.714 H:M:S, 5.9 percent
Write Stall (count): write-buffer-manager-limit-stops: 0
--- universal with trivial move
** Compaction Stats [default] **
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 29.70 MB 0.8 0.0 0.0 0.0 6.3 6.3 0.0 1.0 0.0 85.8 74.78 59.74 216 0.346 0 0 0.0 0.0
L4 32/0 950.42 MB 0.0 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 63/0 1.83 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 120/0 3.48 GB 0.0 0.0 0.0 0.0 0.0 0.0 3.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
Sum 216/0 6.26 GB 0.0 0.0 0.0 0.0 6.3 6.3 10.2 1.0 0.0 85.8 74.78 59.74 216 0.346 0 0 0.0 0.0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.2 6.2 10.2 1.0 0.0 85.8 74.45 59.48 215 0.346 0 0 0.0 0.0
** Compaction Stats [default] **
Priority 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)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.3 6.3 0.0 0.0 0.0 85.8 74.78 59.74 216 0.346 0 0 0.0 0.0
Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0
Uptime(secs): 423.2 total, 420.2 interval
Flush(GB): cumulative 6.265, interval 6.236
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: 6.26 GB write, 15.16 MB/s write, 0.00 GB read, 0.00 MB/s read, 74.8 seconds
Interval compaction: 6.24 GB write, 15.20 MB/s write, 0.00 GB read, 0.00 MB/s read, 74.5 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-sts0
Block cache LRUCache@0x7fd5a5027290#2017644 capacity: 32.00 MB seed: 1452542778 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 1 last_copies: 1 last_secs: 0.00015 secs_since: 423
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
** File Read Latency Histogram By Level [default] **
** DB Stats **
Uptime(secs): 423.2 total, 420.2 interval
Cumulative writes: 100M writes, 100M keys, 100M commit groups, 1.0 writes per commit group, ingest: 12.20 GB, 29.52 MB/s
Cumulative WAL: 100M writes, 0 syncs, 100000000.00 writes per sync, written: 12.20 GB, 29.52 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 99M writes, 99M keys, 99M commit groups, 1.0 writes per commit group, ingest: 12405.12 MB, 29.52 MB/s
Interval WAL: 99M writes, 0 syncs, 99295474.00 writes per sync, written: 12.11 GB, 29.52 MB/s
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
Write Stall (count): write-buffer-manager-limit-stops: 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment