Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
for n in 10000000 100000000 1000000000; do echo $n 32 10; bash pp.sh $n 32 10; done
Notes:
* rr = readrandom response time, fillseq/overwrite are response times for those tests
* test was repeated 3 times, median time is listed
* ratio column has value for 5143 / 42
* 42, 547, 575, 5142, 5143 are release nubmers - 4.2, 5.4.7, 5.7.5, 5.14.2, 5.14.3
* nopin/pin is test with pin_l0_filter_and_index_blocks_in_cache set to 0 and 1
* L0 = 1, 2, 4 is value for level0_file_num_compaction_trigger
readrandom was run after fillseq and then again after overwrite. There is more work on a read after overwrite because
overwrite "fragments" LSM tree while fillseq leaves it nicely ordered
The 3 values prior to each table are: Nkeys, key size, value size
10000000 32 10
42 547 575 5142 5143 ratio notes
1.324 1.425 1.656 1.731 1.689 1.276 fillseq
3.138 3.089 3.145 3.453 3.647 1.162 rr,nopin,L0=4
NA 3.161 3.259 3.568 3.569 0.000 rr,pin,L0=4
3.085 3.202 3.129 3.493 3.531 1.145 rr,nopin,L0=2
NA 3.098 3.235 3.465 3.691 0.000 rr,pin,L0=2
3.062 3.011 3.099 3.401 3.639 1.188 rr,nopin,L0=1
NA 3.116 3.399 3.485 3.488 0.000 rr,pin,L0=1
2.926 2.999 3.141 3.129 3.021 1.032 overwrite
3.012 3.181 3.044 3.601 3.672 1.219 rr,nopin,L0=4
NA 3.027 3.315 3.352 3.471 0.000 rr,pin,L0=4
3.032 3.105 3.136 3.351 3.418 1.127 rr,nopin,L0=2
NA 2.955 3.148 3.456 3.356 0.000 rr,pin,L0=2
2.919 3.113 3.171 3.216 3.416 1.170 rr,nopin,L0=1
NA 2.985 3.043 3.409 3.475 0.000 rr,pin,L0=1
100000000 32 10
42 547 575 5142 5143 ratio notes
1.324 1.414 1.630 1.704 1.655 1.250 fillseq
4.236 4.312 4.280 4.697 4.579 1.081 rr,nopin,L0=4
NA 4.218 4.645 4.602 4.998 0.000 rr,pin,L0=4
4.245 4.188 4.262 4.400 4.549 1.072 rr,nopin,L0=2
NA 4.102 4.127 4.842 4.696 0.000 rr,pin,L0=2
4.280 4.329 4.151 4.830 4.635 1.083 rr,nopin,L0=1
NA 4.171 4.237 4.573 4.389 0.000 rr,pin,L0=1
3.038 3.143 3.127 3.171 3.159 1.040 overwrite
4.338 4.585 4.511 5.058 5.160 1.189 rr,nopin,L0=4
NA 4.443 4.468 4.891 4.883 0.000 rr,pin,L0=4
4.263 4.488 4.684 4.666 4.883 1.145 rr,nopin,L0=2
NA 4.419 4.706 5.039 4.910 0.000 rr,pin,L0=2
4.276 4.403 4.541 5.277 4.766 1.115 rr,nopin,L0=1
NA 4.460 4.662 4.890 4.944 0.000 rr,pin,L0=1
1000000000 32 10
42 547 575 5142 5143 ratio notes
1.342 1.422 1.634 1.757 1.662 1.238 fillseq
7.882 8.293 8.086 8.961 8.746 1.110 rr,nopin,L0=4
NA 8.182 8.425 8.776 8.977 0.000 rr,pin,L0=4
7.725 8.309 8.025 8.655 8.665 1.122 rr,nopin,L0=2
NA 8.142 8.147 9.133 8.993 0.000 rr,pin,L0=2
8.017 8.070 8.197 8.400 8.714 1.087 rr,nopin,L0=1
NA 8.182 8.034 8.653 8.060 0.000 rr,pin,L0=1
3.403 3.237 3.172 3.247 3.217 0.945 overwrite
7.702 8.933 8.802 9.441 9.276 1.204 rr,nopin,L0=4
NA 8.590 8.718 9.626 9.166 0.000 rr,pin,L0=4
7.607 8.682 9.119 9.891 9.239 1.215 rr,nopin,L0=2
NA 8.788 9.069 9.487 9.399 0.000 rr,pin,L0=2
7.260 8.686 8.896 9.621 9.384 1.293 rr,nopin,L0=1
NA 8.724 8.880 9.440 9.493 0.000 rr,pin,L0=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.