Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:32f1f03c734ec5f7e485a84b933ef0cc Secret

Created February 15, 2022 20: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/32f1f03c734ec5f7e485a84b933ef0cc to your computer and use it in GitHub Desktop.
Save mdcallag/32f1f03c734ec5f7e485a84b933ef0cc to your computer and use it in GitHub Desktop.
Download ZIP
asc.b.c.a
Raw
gistfile1.txt
---> stats after inserts for asc.b
** DB Stats **
Uptime(secs): 40.0 total, 10.0 interval
Cumulative writes: 0 writes, 33M keys, 0 commit groups, 0.0 writes per commit group, ingest: 13.71 GB, 350.97 MB/s
Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 0 writes, 8333K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3464.88 MB, 346.48 MB/s
Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
2022/02/11-12:52:44 ... thread 0: (8279000,42049000) ops and (827821.9,840932.6) ops/second in (10.000943,50.002817) seconds
** 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 3/0 46.92 MB 0.8 0.0 0.0 0.0 16.7 16.7 0.0 1.0 0.0 291.8 58.75 57.51 1096 0.054 0 0 0.0 0.0
L4 4/0 62.56 MB 1.0 0.0 0.0 0.0 0.0 0.0 12.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 14/0 218.97 MB 0.9 0.0 0.0 0.0 0.0 0.0 16.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 119/0 1.82 GB 1.0 0.0 0.0 0.0 0.0 0.0 16.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L7 956/0 14.60 GB 0.0 0.0 0.0 0.0 0.0 0.0 14.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
Sum 1096/0 16.74 GB 0.0 0.0 0.0 0.0 16.7 16.7 59.2 1.0 0.0 291.8 58.75 57.51 1096 0.054 0 0 0.0 0.0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.3 3.3 12.7 1.0 0.0 294.8 11.46 11.22 216 0.053 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 16.7 16.7 0.0 0.0 0.0 291.8 58.75 57.51 1096 0.054 0 0 0.0 0.0
Blob file count: 0, total size: 0.0 GB
Uptime(secs): 50.0 total, 10.0 interval
Flush(GB): cumulative 16.740, interval 3.299
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: 16.74 GB write, 342.78 MB/s write, 0.00 GB read, 0.00 MB/s read, 58.7 seconds
Interval compaction: 3.30 GB write, 337.81 MB/s write, 0.00 GB read, 0.00 MB/s read, 11.5 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_compaction, 0 memtable_slowdown, interval 0 total count
Block cache LRUCache@0x7f77ec829470#2804382 capacity: 48.00 GB collections: 1 last_copies: 0 last_secs: 0.000111 secs_since: 50
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
---> stats after inserts for asc.c
** 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 3/0 46.92 MB 0.8 0.0 0.0 0.0 18.7 18.7 0.0 1.0 0.0 290.6 65.77 63.95 1222 0.054 0 0 0.0 0.0
L3 4/0 62.56 MB 1.0 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L4 4/0 62.56 MB 0.9 0.0 0.0 0.0 0.0 0.0 18.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 34/0 531.78 MB 1.0 0.0 0.0 0.0 0.0 0.0 18.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 276/1 4.22 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L7 2207/0 33.70 GB 0.0 0.0 0.0 0.0 0.0 0.0 16.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
Sum 2528/1 38.60 GB 0.0 0.0 0.0 0.0 18.7 18.7 73.9 1.0 0.0 290.6 65.77 63.95 1222 0.054 0 0 0.0 0.0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.0 3.0 13.5 1.0 0.0 293.6 10.60 10.28 199 0.053 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 18.7 18.7 0.0 0.0 0.0 290.6 65.77 63.95 1222 0.054 0 0 0.0 0.0
Blob file count: 0, total size: 0.0 GB
Uptime(secs): 60.1 total, 10.0 interval
Flush(GB): cumulative 18.665, interval 3.040
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: 18.66 GB write, 318.01 MB/s write, 0.00 GB read, 0.00 MB/s read, 65.8 seconds
Interval compaction: 3.04 GB write, 311.19 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.6 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_compaction, 0 memtable_slowdown, interval 0 total count
Block cache LRUCache@0x7fd7f3629470#2807514 capacity: 48.00 GB collections: 1 last_copies: 0 last_secs: 9.9e-05 secs_since: 60
Block cache entry stats(count,size,portion): FilterBlock(4,192.12 KB,0.000381718%) IndexBlock(4,192.31 KB,0.000382091%) Misc(1,0.00 KB,0%)
---> stats after inserts for asc.a
** 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 3/0 46.92 MB 0.8 0.0 0.0 0.0 18.4 18.4 0.0 1.0 0.0 289.9 65.06 63.52 1206 0.054 0 0 0.0 0.0
L3 4/0 50.21 MB 0.8 0.0 0.0 0.0 0.0 0.0 18.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L4 6/0 93.84 MB 0.9 0.0 0.0 0.0 0.0 0.0 18.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L5 52/0 813.31 MB 1.0 0.0 0.0 0.0 0.0 0.0 18.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L6 416/0 6.35 GB 1.0 0.0 0.0 0.0 0.0 0.0 18.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
L7 3337/0 50.96 GB 0.0 0.0 0.0 0.0 0.0 0.0 16.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0
Sum 3818/0 58.29 GB 0.0 0.0 0.0 0.0 18.4 18.4 89.6 1.0 0.0 289.9 65.06 63.52 1206 0.054 0 0 0.0 0.0
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.0 3.0 14.5 1.0 0.0 289.0 10.55 10.33 195 0.054 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 18.4 18.4 0.0 0.0 0.0 289.9 65.06 63.52 1206 0.054 0 0 0.0 0.0
Blob file count: 0, total size: 0.0 GB
Uptime(secs): 60.1 total, 10.0 interval
Flush(GB): cumulative 18.420, interval 2.978
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: 18.42 GB write, 313.60 MB/s write, 0.00 GB read, 0.00 MB/s read, 65.1 seconds
Interval compaction: 2.98 GB write, 304.96 MB/s write, 0.00 GB read, 0.00 MB/s read, 10.6 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_compaction, 0 memtable_slowdown, interval 0 total count
Block cache LRUCache@0x7f4b86029470#2811204 capacity: 48.00 GB collections: 1 last_copies: 0 last_secs: 0.000104 secs_since: 60
Block cache entry stats(count,size,portion): FilterBlock(4,192.12 KB,0.000381718%) IndexBlock(4,192.31 KB,0.000382091%) Misc(1,0.00 KB,0%)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment