Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
This lists sybench QPS for 1, 2 and 4 threads (see columns "1", "2" and "4". Results are listed for
all tests in the order in which they are run by my helper script (all_small.sh). For each test results
are listed for the slower server (nuc.i3 is 5th generation core i3 NUC) and faster server (nuc.i5 is
7th generation core i5 NUC). For the helper script and to see the options I use with sysbench see:
https://github.com/mdcallag/mytools/blob/master/bench/sysbench.lua/all_small.sh
https://github.com/mdcallag/mytools/blob/master/bench/sysbench.lua/run.sh
The setup here is 4 tables with 1M rows/table and all data is cached by InnoDB. The binlog is enabled
and fsync-on-commit is disabled.
Under the "concurrency" column is the version of MySQL that I used.
Finally the "vs 5.6.35 at 1 thread" column lists the ratio of QPS between new version and MySQL 5.6.35.
Note that a value less than 1 means that new MySQL is slower than 5.6.35.
Legend:
* in-5635.opt - InnoDB & MySQL 5.6.35
* in-5717.opt - InnoDB & MySQL 5.7.17
* in-801.opt - InnoDB & MySQL 8.0.1
* in-801.opt.latin - InnoDB & MySQL 8.0.1 with latin1 charset and latin1_bin collation
* in-801.opt.latin1sw - InnoDB & MySQL 8.0.1 with latin1 charset and latin1_swedish_ci collation
update-index
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
3616 6021 7393 in-5635.opt
3002 4653 5971 in-5717.opt 0.83
2703 4201 5371 in-801.opt
2635 4148 5274 in-801.opt.latin1sw 0.75
- nuc.i5
9549 15559 19024 in-5635.opt
6343 10669 13598 in-5717.opt 0.66
6906 11838 14196 in-801.opt
6980 12259 14180 in-801.opt.latin1sw 0.73
update-nonindex
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
8809 12240 15179 in-5635.opt
6010 8738 10988 in-5717.opt 0.68
4837 7116 8462 in-801.opt
4943 7254 8733 in-801.opt.latin1sw 0.56
- nuc.i5
16103 23903 28253 in-5635.opt
9164 14051 19850 in-5717.opt 0.57
9666 16341 19117 in-801.opt
9897 16355 19527 in-801.opt.latin1sw 0.61
delete
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
7819 in-5635.opt
5979 in-5717.opt 0.76
8534 12484 15703 in-801.opt
8616 12450 15884 in-801.opt.latin1sw 1.10
- nuc.i5
30153 44769 55864 in-5635.opt
17580 25020 34325 in-5717.opt 0.58
17225 27278 35099 in-801.opt
17416 27628 35671 in-801.opt.latin1sw 0.58
write-only
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
13076 17780 21097 in-5635.opt
9967 14344 16660 in-5717.opt 0.76
7503 11007 13829 in-801.opt
7512 11053 13852 in-801.opt.latin1sw 0.57
- nuc.i5
26455 38699 46983 in-5635.opt
16060 23040 30218 in-5717.opt 0.61
15157 23911 30500 in-801.opt
15347 24016 30971 in-801.opt.latin1sw 0.58
read-write.range100
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
10084 15236 20895 in-5635.opt
10252 15289 20600 in-5717.opt 1.02
5630 8967 11418 in-801.opt
5717 9573 12229 in-801.opt.latin1sw 0.57
- nuc.i5
18675 28933 39662 in-5635.opt
11070 16849 22268 in-5717.opt 0.59
9663 15760 21341 in-801.opt
10789 16685 22916 in-801.opt.latin1sw 0.58
read-write.range10000
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
278 523 684 in-5635.opt
455 790 890 in-5717.opt 1.64
122 219 257 in-801.opt
174 325 356 in-801.opt.latin1sw 0.63
- nuc.i5
516 921 1315 in-5635.opt
304 588 664 in-5717.opt 0.59
215 394 466 in-801.opt
300 578 653 in-801.opt.latin1sw 0.58
read-only.range10
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
15348 27860 42859 in-5635.opt
15308 25999 42872 in-5717.opt 1.00
9464 15903 19225 in-801.opt
9387 16206 19350 in-801.opt.latin1sw 0.61
- nuc.i5
27569 48455 79829 in-5635.opt
16879 29834 40095 in-5717.opt 0.61
16175 29511 38917 in-801.opt
15619 28796 40744 in-801.opt.latin1sw 0.57
read-only.range100
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
9847 18361 26953 in-5635.opt
11533 20802 30026 in-5717.opt 1.17
5609 10334 11271 in-801.opt
5758 9906 12213 in-801.opt.latin1sw 0.58
- nuc.i5
17911 32799 51344 in-5635.opt
10748 20427 24820 in-5717.opt 0.60
9818 18282 22425 in-801.opt
10180 18182 25071 in-801.opt.latin1sw 0.57
read-only.range1000
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
2216 4035 5436 in-5635.opt
3432 6136 7148 in-5717.opt 1.55
1079 1844 2093 in-801.opt
1462 2518 2770 in-801.opt.latin1sw 0.66
- nuc.i5
3994 7446 10591 in-5635.opt
2487 4652 5215 in-5717.opt 0.62
1738 3176 3642 in-801.opt
2529 4592 5255 in-801.opt.latin1sw 0.55
read-only.range10000
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
227 424 556 in-5635.opt
360 632 723 in-5717.opt 1.59
109 174 207 in-801.opt
155 253 286 in-801.opt.latin1sw 0.68
- nuc.i5
411 750 1063 in-5635.opt
246 465 538 in-5717.opt 0.60
178 312 374 in-801.opt
245 457 498 in-801.opt.latin1sw 0.60
point-query
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
18481 34911 43390 in-5635.opt
18144 31178 51046 in-5717.opt 0.98
11450 18639 22034 in-801.opt
10768 18602 22029 in-801.opt.latin1sw 0.58
- nuc.i5
31813 57071 84517 in-5635.opt
18979 33834 46224 in-5717.opt 0.60
18375 31927 44015 in-801.opt
17686 32609 45099 in-801.opt.latin1sw 0.56
insert
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
9712 12732 14917 in-5635.opt
8224 10713 11809 in-5717.opt 0.85
5614 7978 8808 in-801.opt
5897 8038 9008 in-801.opt.latin1sw 0.61
- nuc.i5
17059 25500 26545 in-5635.opt
11752 18547 22157 in-5717.opt 0.69
11054 17001 21241 in-801.opt
11378 17495 21591 in-801.opt.latin1sw 0.67
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment