Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:c123a1d1fc9367bf1d07945155ef31ed 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/c123a1d1fc9367bf1d07945155ef31ed to your computer and use it in GitHub Desktop.
Save mdcallag/c123a1d1fc9367bf1d07945155ef31ed to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
No compression
--- 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 53.56 MB 0.2 0.0 0.0 0.0 11.3 11.3 0.0 1.0 0.0 199.3 58.04 40.52 216 0.269 0 0 0.0 0.0
L4 1/0 53.56 MB 0.2 0.0 0.0 0.0 0.0 0.0 8.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 17/0 910.53 MB 0.9 0.0 0.0 0.0 0.0 0.0 10.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 197/0 10.30 GB 0.0 0.0 0.0 0.0 0.0 0.0 10.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
Sum 216/0 11.30 GB 0.0 0.0 0.0 0.0 11.3 11.3 29.9 1.0 0.0 199.3 58.04 40.52 216 0.269 0 0 0.0 0.0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.2 11.2 29.9 1.0 0.0 199.3 57.78 40.34 215 0.269 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 11.3 11.3 0.0 0.0 0.0 199.3 58.04 40.52 216 0.269 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): 429.7 total, 426.7 interval
Flush(GB): cumulative 11.298, interval 11.245
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: 11.30 GB write, 26.93 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.0 seconds
Interval compaction: 11.25 GB write, 26.99 MB/s write, 0.00 GB read, 0.00 MB/s read, 57.8 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@0x7f2a5e027290#1838875 capacity: 32.00 MB seed: 1413271124 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 1 last_copies: 1 last_secs: 0.000159 secs_since: 429
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
** File Read Latency Histogram By Level [default] **
** DB Stats **
Uptime(secs): 429.7 total, 426.7 interval
Cumulative writes: 100M writes, 100M keys, 100M commit groups, 1.0 writes per commit group, ingest: 12.20 GB, 29.08 MB/s
Cumulative WAL: 100M writes, 0 syncs, 100000000.00 writes per sync, written: 12.20 GB, 29.08 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: 12404.31 MB, 29.07 MB/s
Interval WAL: 99M writes, 0 syncs, 99289051.00 writes per sync, written: 12.11 GB, 29.07 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 1/0 53.56 MB 1.0 0.0 0.0 0.0 11.3 11.3 0.0 1.0 0.0 183.5 63.04 43.92 216 0.292 0 0 0.0 0.0
L2 2/0 107.11 MB 0.0 1.7 1.7 0.0 1.7 1.7 0.0 1.0 180.1 180.1 9.51 9.24 15 0.634 14M 0 0.0 0.0
L3 10/10 642.71 MB 0.0 28.3 6.2 22.1 28.3 6.2 0.0 4.5 177.0 177.0 163.67 158.52 86 1.903 249M 0 0.0 0.0
L4 10/10 589.18 MB 0.0 6.7 4.2 2.5 6.7 4.2 0.0 1.6 173.9 173.9 39.72 38.21 21 1.891 59M 0 0.0 0.0
L5 45/0 2.77 GB 0.0 8.2 5.6 2.5 8.2 5.6 0.0 1.4 177.4 177.4 47.10 45.28 10 4.710 71M 0 0.0 0.0
L6 115/0 7.17 GB 0.0 12.8 7.2 5.6 12.8 7.2 0.0 1.8 171.7 171.7 76.11 72.67 5 15.222 112M 0 0.0 0.0
Sum 183/20 11.30 GB 0.0 57.6 24.9 32.7 68.9 36.2 0.0 6.1 147.9 176.9 399.15 367.85 353 1.131 507M 0 0.0 0.0
Int 0/0 0.00 KB 0.0 57.6 24.9 32.7 68.9 36.2 0.0 6.1 148.0 176.8 398.90 367.67 352 1.133 507M 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 57.6 24.9 32.7 57.6 24.9 0.0 0.0 175.6 175.6 336.11 323.92 137 2.453 507M 0 0.0 0.0
High 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.3 11.3 0.0 0.0 0.0 183.5 63.04 43.92 216 0.292 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): 444.7 total, 441.7 interval
Flush(GB): cumulative 11.298, interval 11.245
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: 68.94 GB write, 158.75 MB/s write, 57.64 GB read, 132.73 MB/s read, 399.1 seconds
Interval compaction: 68.89 GB write, 159.71 MB/s write, 57.64 GB read, 133.64 MB/s read, 398.9 seconds
Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-sts1
interval: 7 total count
Block cache LRUCache@0x7f60f3e27290#1879530 capacity: 32.00 MB seed: 1844130227 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 1 last_copies: 1 last_secs: 0.000126 secs_since: 444
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
** File Read Latency Histogram By Level [default] **
** DB Stats **
Uptime(secs): 444.7 total, 441.7 interval
Cumulative writes: 100M writes, 100M keys, 100M commit groups, 1.0 writes per commit group, ingest: 12.20 GB, 28.09 MB/s
Cumulative WAL: 100M writes, 0 syncs, 100000000.00 writes per sync, written: 12.20 GB, 28.09 MB/s
Cumulative stall: 00:00:13.382 H:M:S, 3.0 percent
Interval writes: 99M writes, 99M keys, 99M commit groups, 1.0 writes per commit group, ingest: 12410.29 MB, 28.10 MB/s
Interval WAL: 99M writes, 0 syncs, 99336879.00 writes per sync, written: 12.12 GB, 28.10 MB/s
Interval stall: 00:00:13.382 H:M:S, 3.0 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 53.56 MB 0.8 0.0 0.0 0.0 11.3 11.3 0.0 1.0 0.0 208.9 55.39 38.14 216 0.256 0 0 0.0 0.0
L4 32/0 1.67 GB 0.0 0.0 0.0 0.0 0.0 0.0 6.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 63/0 3.30 GB 0.0 0.0 0.0 0.0 0.0 0.0 6.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 120/0 6.28 GB 0.0 0.0 0.0 0.0 0.0 0.0 6.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
Sum 216/0 11.30 GB 0.0 0.0 0.0 0.0 11.3 11.3 18.5 1.0 0.0 208.9 55.39 38.14 216 0.256 0 0 0.0 0.0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 11.2 11.2 18.5 1.0 0.0 208.8 55.15 37.97 215 0.257 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 11.3 11.3 0.0 0.0 0.0 208.9 55.39 38.14 216 0.256 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): 426.8 total, 423.8 interval
Flush(GB): cumulative 11.298, interval 11.245
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: 11.30 GB write, 27.10 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.4 seconds
Interval compaction: 11.25 GB write, 27.17 MB/s write, 0.00 GB read, 0.00 MB/s read, 55.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@0x7f2535a27290#1919994 capacity: 32.00 MB seed: 143317164 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 1 last_copies: 1 last_secs: 0.000141 secs_since: 426
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
** File Read Latency Histogram By Level [default] **
** DB Stats **
Uptime(secs): 426.8 total, 423.8 interval
Cumulative writes: 100M writes, 100M keys, 100M commit groups, 1.0 writes per commit group, ingest: 12.20 GB, 29.27 MB/s
Cumulative WAL: 100M writes, 0 syncs, 100000000.00 writes per sync, written: 12.20 GB, 29.27 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: 12400.62 MB, 29.26 MB/s
Interval WAL: 99M writes, 0 syncs, 99259494.00 writes per sync, written: 12.11 GB, 29.26 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