Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
for n in 1000000 10000000 100000000; do echo $n 8 400; bash pp.sh $n 8 400; 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
1000000 8 400
42 547 575 5142 5143 ratio notes
1.930 1.840 2.001 2.082 2.028 1.051 fillseq
2.885 2.641 2.872 3.283 3.195 1.107 rr,nopin,L0=4
NA 2.657 2.676 2.978 3.129 0.000 rr,pin,L0=4
2.621 2.730 2.731 2.976 3.228 1.232 rr,nopin,L0=2
NA 2.638 2.841 2.966 3.156 0.000 rr,pin,L0=2
2.664 2.734 2.758 3.146 2.948 1.107 rr,nopin,L0=1
NA 2.730 2.822 3.057 3.085 0.000 rr,pin,L0=1
3.149 3.123 3.268 3.218 3.238 1.028 overwrite
2.908 2.889 2.843 3.208 3.146 1.082 rr,nopin,L0=4
NA 2.732 2.883 3.055 3.121 0.000 rr,pin,L0=4
2.751 2.765 2.886 2.962 3.015 1.096 rr,nopin,L0=2
NA 2.824 2.803 3.133 3.164 0.000 rr,pin,L0=2
2.649 2.721 2.911 3.020 3.097 1.169 rr,nopin,L0=1
NA 2.681 2.854 3.041 3.049 0.000 rr,pin,L0=1
10000000 8 400
42 547 575 5142 5143 ratio notes
1.876 1.824 1.963 2.039 1.996 1.064 fillseq
4.016 3.925 4.078 4.211 4.490 1.118 rr,nopin,L0=4
NA 3.939 3.874 4.451 4.425 0.000 rr,pin,L0=4
3.957 3.971 4.094 4.177 4.336 1.096 rr,nopin,L0=2
NA 3.678 4.098 4.493 4.433 0.000 rr,pin,L0=2
3.938 4.020 3.750 4.355 4.200 1.067 rr,nopin,L0=1
NA 3.843 3.930 4.418 4.460 0.000 rr,pin,L0=1
4.271 3.255 3.301 3.474 3.343 0.783 overwrite
3.962 4.230 4.401 4.646 4.697 1.186 rr,nopin,L0=4
NA 4.045 3.880 4.526 4.458 0.000 rr,pin,L0=4
3.870 3.786 4.201 4.704 4.656 1.203 rr,nopin,L0=2
NA 4.222 4.391 4.431 4.360 0.000 rr,pin,L0=2
3.793 3.947 4.120 4.609 4.489 1.183 rr,nopin,L0=1
NA 4.313 4.239 4.666 4.663 0.000 rr,pin,L0=1
100000000 8 400
42 547 575 5142 5143 ratio notes
1.871 1.808 1.982 2.032 2.066 1.104 fillseq
6.274 7.249 6.986 8.057 7.976 1.271 rr,nopin,L0=4
NA 7.052 7.330 7.933 8.161 0.000 rr,pin,L0=4
6.859 7.226 7.371 7.857 7.923 1.155 rr,nopin,L0=2
NA 7.268 7.239 7.391 7.440 0.000 rr,pin,L0=2
6.816 7.026 7.206 7.973 7.879 1.156 rr,nopin,L0=1
NA 6.923 6.838 7.904 7.946 0.000 rr,pin,L0=1
8.128 3.373 3.407 3.544 3.481 0.428 overwrite
6.709 8.051 8.272 8.952 8.829 1.316 rr,nopin,L0=4
NA 7.885 8.183 8.896 8.842 0.000 rr,pin,L0=4
6.644 7.524 7.793 8.606 8.670 1.305 rr,nopin,L0=2
NA 8.009 7.751 8.799 8.722 0.000 rr,pin,L0=2
6.651 7.734 8.258 8.635 8.840 1.329 rr,nopin,L0=1
NA 7.531 8.156 8.927 8.682 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.