Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created July 20, 2022 23:18
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/cf09a8afb12a3fc4244f315a644d4e9d to your computer and use it in GitHub Desktop.
Save mdcallag/cf09a8afb12a3fc4244f315a644d4e9d to your computer and use it in GitHub Desktop.
** 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/2 120.67 MB 0.2 54.4 0.0 54.4 159.4 105.0 0.0 1.5 105.8 310.0 526.54 468.09 7921 0.066 135M 2399 0.0 0.0
L2 10/10 147.66 MB 0.0 310.0 104.9 205.1 309.9 104.8 0.0 3.0 308.1 308.0 1030.45 985.49 877 1.175 774M 46K 0.0 0.0
L3 31/5 482.55 MB 9.5 120.5 63.7 56.8 120.5 63.7 41.0 1.9 300.9 300.8 410.08 378.34 3112 0.132 301M 24K 0.0 0.0
L4 134/18 1.75 GB 0.9 419.7 104.4 315.3 373.1 57.8 0.0 3.6 118.2 105.1 3634.21 3542.36 6691 0.543 1680M 479K 0.0 0.0
L5 1032/3 13.79 GB 9.7 321.3 57.6 263.6 320.3 56.7 0.0 5.6 105.6 105.3 3115.45 3046.76 4028 0.773 1448M 3841K 0.0 0.0
L6 8261/18 109.61 GB 1.0 293.9 54.6 239.3 288.1 48.9 1.5 5.3 104.9 102.9 2868.43 2791.05 3785 0.758 1326M 25M 0.0 0.0
L7 57492/36 876.63 GB 0.0 133.5 17.0 116.5 115.3 -1.2 29.8 6.8 109.9 94.9 1244.08 1193.18 1215 1.024 607M 75M 0.0 0.0
Sum 66963/92 1002.52 GB 0.0 1653.3 402.3 1251.0 1686.7 435.7 72.3 16.1 132.0 134.6 12829.23 12405.25 27629 0.464 6274M 105M 0.0 0.0
Int 0/0 0.00 KB 0.0 20.7 4.9 15.9 20.8 4.9 0.2 18.8 127.6 127.7 166.41 158.98 346 0.481 80M 2771K 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 1653.3 402.3 1251.0 1581.6 330.6 0.0 0.0 135.7 129.8 12477.88 12106.46 20502 0.609 6274M 105M 0.0 0.0
High 0/0 0.00 KB 0.0 0.0 0.0 0.0 105.0 105.0 0.0 0.0 0.0 306.2 351.34 298.79 7126 0.049 0 0 0.0 0.0
User 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 271.9 0.01 0.00 1 0.011 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): 1782.1 total, 20.0 interval
Flush(GB): cumulative 105.049, interval 1.106
Cumulative compaction: 1686.66 GB write, 969.14 MB/s write, 1653.30 GB read, 949.98 MB/s read, 12829.2 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
** DB Stats **
Uptime(secs): 1782.1 total, 20.0 interval
Cumulative writes: 262M writes, 262M keys, 262M commit groups, 1.0 writes per commit group, ingest: 106.41 GB, 61.14 MB/s
Cumulative WAL: 262M writes, 0 syncs, 262066000.00 writes per sync, written: 106.41 GB, 61.14 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
num-running-compactions: 12
num-running-flushes: 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment