Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created July 14, 2023 21:22
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/7ce2830a817d55ac08ecb4df2bb4a1ae to your computer and use it in GitHub Desktop.
Save mdcallag/7ce2830a817d55ac08ecb4df2bb4a1ae to your computer and use it in GitHub Desktop.
--- base config
** 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 6/4 579.74 MB 0.5 251.9 0.0 251.9 536.3 284.4 0.0 1.3 43.1 91.8 5979.30 5684.60 17169 0.348 7575M 0 0.0 0.0
L2 7/7 789.64 MB 0.0 173.1 63.5 109.5 170.1 60.5 0.0 2.7 49.7 48.8 3568.07 3477.20 78 45.744 6159M 0 0.0 0.0
L3 8/3 887.02 MB 3.5 398.1 179.1 219.0 397.3 178.3 56.6 2.2 87.2 87.0 4675.66 4509.65 1057 4.424 8459M 0 0.0 0.0
L4 43/13 2.62 GB 0.8 303.9 158.6 145.3 303.0 157.7 115.1 1.9 72.2 72.0 4308.99 4156.10 1469 2.933 8149M 0 0.0 0.0
L5 406/2 25.37 GB 1.0 248.3 89.8 158.5 246.3 87.8 184.7 2.7 52.4 52.0 4848.59 4691.39 1194 4.061 9443M 986K 0.0 0.0
L6 4333/4 252.74 GB 0.0 374.7 247.5 127.1 247.6 120.4 132.3 1.0 55.8 36.9 6879.18 6593.07 3417 2.013 10G 1162M 0.0 0.0
Sum 4803/33 282.94 GB 0.0 1749.9 738.6 1011.4 1900.5 889.2 488.7 4.5 59.2 64.3 30259.79 29112.02 24384 1.241 50G 1163M 0.0 0.0
Int 0/0 0.00 KB 0.0 55.5 15.5 39.9 54.1 14.2 4.5 13.8 44.3 43.2 1283.34 1248.07 459 2.796 1985M 63M 0.0 0.0
--- c3 config that disables intra-L0 compaction
** 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 23/13 415.64 MB 25.0 0.0 0.0 0.0 289.3 289.3 0.0 0.7 0.0 111.8 2650.20 2503.21 14763 0.180 413K 0 0.0 0.0
L2 10/10 989.70 MB 0.0 439.8 70.1 369.7 433.5 63.8 0.0 6.2 52.6 51.9 8557.14 8360.04 355 24.105 17G 0 0.0 0.0
L3 1/0 134.90 MB 0.5 908.5 173.4 735.1 906.7 171.6 62.8 5.2 92.8 92.6 10023.29 9645.79 1142 8.777 20G 0 0.0 0.0
L4 41/0 2.50 GB 1.0 503.7 147.9 355.7 502.6 146.9 126.4 3.4 74.1 73.9 6960.95 6748.99 1465 4.752 14G 0 0.0 0.0
L5 505/0 24.44 GB 1.0 309.8 99.2 210.6 307.8 97.2 176.4 3.1 58.0 57.6 5472.60 5321.65 1454 3.764 11G 0 0.0 0.0
L6 4594/0 253.28 GB 0.0 395.9 249.6 146.3 267.4 121.1 132.2 1.1 56.1 37.9 7223.81 6913.99 3663 1.972 10G 1135M 0.0 0.0
Sum 5174/23 281.72 GB 0.0 2557.8 740.3 1817.5 2707.3 889.8 497.9 6.4 64.1 67.8 40888.00 39493.66 22842 1.790 74G 1135M 0.0 0.0
Int 0/0 0.00 KB 0.0 69.8 16.1 53.7 69.1 15.4 4.7 16.4 47.3 46.8 1512.23 1476.79 459 3.295 2753M 85M 0.0 0.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment