Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created September 5, 2017 14:56
Show Gist options
  • Save mdcallag/8a0d6543e37a65b2985199f50fe71e49 to your computer and use it in GitHub Desktop.
Save mdcallag/8a0d6543e37a65b2985199f50fe71e49 to your computer and use it in GitHub Desktop.
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