Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created July 14, 2023 21:50
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/076a7a4d73f004252e629d883f7705a8 to your computer and use it in GitHub Desktop.
Save mdcallag/076a7a4d73f004252e629d883f7705a8 to your computer and use it in GitHub Desktop.
--- base with max_subcompactions=1 (disabled)
** 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
--- c4 config with level0_slowdown_writes_trigger and level0_stop_writes_trigger reduced
** 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 69.31 MB 0.2 149.2 0.0 149.2 437.1 287.8 0.0 1.0 35.1 102.7 4358.63 4154.88 16594 0.263 3918M 0 0.0 0.0
L2 5/0 358.49 MB 11.0 216.5 67.8 148.7 211.8 63.0 0.0 3.1 51.8 50.7 4278.90 4181.32 420 10.188 8465M 0 0.0 0.0
L3 5/1 349.65 MB 0.9 456.4 194.3 262.1 454.9 192.8 44.2 2.3 88.4 88.1 5284.77 5107.30 1585 3.334 10G 0 0.0 0.0
L4 48/9 2.79 GB 0.9 495.1 182.4 312.7 493.4 180.6 93.9 2.7 66.3 66.0 7651.70 7444.33 2822 2.711 15G 0 0.0 0.0
L5 530/0 24.46 GB 1.0 299.1 87.9 211.2 297.0 85.8 187.9 3.4 52.4 52.0 5846.17 5695.58 1658 3.526 11G 295K 0.0 0.0
L6 4866/0 253.43 GB 0.0 395.5 249.7 145.8 266.9 121.1 132.3 1.1 55.4 37.4 7315.57 6990.64 4150 1.763 11G 1142M 0.0 0.0
Sum 5455/10 281.43 GB 0.0 2011.8 782.1 1229.7 2160.9 931.2 458.2 5.1 59.3 63.7 34735.74 33574.05 27229 1.276 61G 1142M 0.0 0.0
Int 0/0 0.00 KB 0.0 72.2 19.9 52.3 72.0 19.7 3.0 15.0 46.7 46.6 1582.83 1546.61 599 2.642 2759M 68M 0.0 0.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment