Created
September 5, 2017 14:56
-
-
Save mdcallag/8a0d6543e37a65b2985199f50fe71e49 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
bash all_small.sh 4 1000000 600 600 300 innodb 1 0 /orig802/bin/mysql none ~/sysbench10 /data | |
QPS ratio: | |
* rocks = QPS for MyRocks / QPS for InnoDB 5.6.35 | |
* inno = QPS for InnoDB 5.7.17 / QPS for InnoDB 5.6.35 | |
1 connection | |
rocks inno | |
0.391 0.966 update-inlist | |
0.723 0.911 update-one | |
0.965 1.042 update-index | |
0.592 0.908 update-nonindex | |
0.651 0.915 update-nonindex-special | |
0.700 0.893 delete-only | |
0.628 1.122 read-write.range100 | |
0.838 1.495 read-write.range10000 | |
0.680 1.155 read-only.range100 | |
0.826 1.438 read-only.range10000 | |
0.655 0.882 point-query | |
0.247 0.966 random-points | |
0.287 0.944 hot-points | |
0.696 0.884 insert-only | |
----- ----- | |
0.634 1.037 average | |
update-inlist | |
1 2 concurrency/engine | |
1688 3073 myrocks | |
4317 4891 inno5635 | |
4174 5058 inno5717 | |
3330 5116 inno802 | |
update-one | |
1 2 concurrency/engine | |
7725 13734 myrocks | |
10678 16999 inno5635 | |
9737 14516 inno5717 | |
8227 12531 inno802 | |
update-index | |
1 2 concurrency/engine | |
5640 9972 myrocks | |
5839 10002 inno5635 | |
6090 9214 inno5717 | |
5292 8561 inno802 | |
update-nonindex | |
1 2 concurrency/engine | |
6006 10738 myrocks | |
10133 15640 inno5635 | |
9209 13328 inno5717 | |
7890 11803 inno802 | |
update-nonindex-special | |
1 2 concurrency/engine | |
6742 12209 myrocks | |
10350 15990 inno5635 | |
9471 14207 inno5717 | |
8100 12450 inno802 | |
delete | |
1 2 concurrency/engine | |
13966 24390 myrocks | |
19940 29750 inno5635 | |
17823 26547 inno5717 | |
15360 23266 inno802 | |
read-write.range100 | |
1 2 concurrency/engine | |
7184 13218 myrocks | |
11437 18356 inno5635 | |
12838 18961 inno5717 | |
11358 17152 inno802 | |
read-write.range10000 | |
1 2 concurrency/engine | |
286 523 myrocks | |
341 618 inno5635 | |
510 886 inno5717 | |
494 852 inno802 | |
read-only.range100 | |
1 2 concurrency/engine | |
7539 14102 myrocks | |
11082 20900 inno5635 | |
12803 22929 inno5717 | |
11456 21715 inno802 | |
read-only.range10000 | |
1 2 concurrency/engine | |
228 421 myrocks | |
276 500 inno5635 | |
397 709 inno5717 | |
389 700 inno802 | |
point-query | |
1 2 concurrency/engine | |
13643 23955 myrocks | |
20817 36211 inno5635 | |
18365 32579 inno5717 | |
16966 29524 inno802 | |
random-points | |
1 2 concurrency/engine | |
814 1589 myrocks | |
3289 6189 inno5635 | |
3178 6312 inno5717 | |
3082 6138 inno802 | |
hot-points | |
1 2 concurrency/engine | |
1186 2347 myrocks | |
4122 7910 inno5635 | |
3893 7794 inno5717 | |
3764 7524 inno802 | |
insert | |
1 2 concurrency/engine | |
7713 13298 myrocks | |
11081 16548 inno5635 | |
9799 15518 inno5717 | |
8840 13754 inno802 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment