Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created January 5, 2021 22:12
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/dee88d2d915a28c2d8a5391dce899ebb to your computer and use it in GitHub Desktop.
Save mdcallag/dee88d2d915a28c2d8a5391dce899ebb to your computer and use it in GitHub Desktop.
LSM tree shapes during the "Read-only after write-heavy" tests
LSM tree for 5.6.35
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
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.5 14.5 0.0 1.0 0.0 255.9 57.88 52.37 81 0.715 0 0
L5 17/0 1004.18 MB 1.0 29.7 13.4 16.3 22.7 6.4 0.0 1.7 242.1 184.9 125.45 111.21 19 6.603 181M 33M
L6 28/0 2.00 GB 0.0 16.1 4.7 11.4 11.5 0.1 1.9 2.4 214.0 152.6 77.19 71.02 74 1.043 136M 24M
Sum 45/0 2.98 GB 0.0 45.8 18.1 27.7 48.6 21.0 1.9 3.3 180.0 191.1 260.51 234.60 174 1.497 317M 57M
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0
LSM tree for 8.0.17
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
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 3/0 560.82 MB 0.8 0.0 0.0 0.0 12.2 12.2 0.0 1.0 0.0 224.9 55.68 46.86 68 0.819 0 0
L5 15/0 962.67 MB 0.9 22.9 10.6 12.3 17.5 5.2 0.0 1.7 218.0 166.8 107.67 86.91 15 7.178 142M 27M
L6 26/0 2.01 GB 0.0 12.4 3.6 8.8 8.9 0.1 1.9 2.5 190.7 137.0 66.61 54.45 57 1.169 112M 22M
Sum 44/0 3.50 GB 0.0 35.3 14.2 21.1 38.7 17.6 1.9 3.1 157.3 172.2 229.96 188.23 140 1.643 255M 50M
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment