Created
June 22, 2023 23:38
-
-
Save mdcallag/bef0cecd41fea8e5b4f00a8d1f3df843 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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