Skip to content

Instantly share code, notes, and snippets.

@mdcallag

mdcallag/gist:eede54ce8133ae9574a5e8c920cf5577

Created May 27, 2017 16:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/eede54ce8133ae9574a5e8c920cf5577 to your computer and use it in GitHub Desktop.
Save mdcallag/eede54ce8133ae9574a5e8c920cf5577 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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 40M rows/table and all data is not cached by InnoDB. The tests are
IO-bound. 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
552 687 810 in-5635.opt
563 678 752 in-5717.opt 1.02
557 666 781 in-801.opt
558 668 779 in-801.opt.latin1sw 1.01
- nuc.i5
1703 2138 2570 in-5635.opt
1425 1783 2245 in-5717.opt 0.84
1362 1782 2163 in-801.opt
1458 1807 2234 in-801.opt.latin1sw 0.86
update-nonindex
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
2887 3835 4364 in-5635.opt
2586 3273 3840 in-5717.opt 0.90
2258 3028 3597 in-801.opt
2316 3069 3692 in-801.opt.latin1sw 0.80
- nuc.i5
7675 10944 15644 in-5635.opt
5052 6880 10380 in-5717.opt 0.66
5286 7341 10125 in-801.opt
5349 7368 10358 in-801.opt.latin1sw 0.70
delete
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
1077 in-5635.opt
1057 in-5717.opt 0.98
1996 2688 3569 in-801.opt
1998 2677 3609 in-801.opt.latin1sw 1.86
- nuc.i5
7490 10546 12933 in-5635.opt
5604 7408 12260 in-5717.opt 0.75
5606 7589 12230 in-801.opt
5686 7763 12344 in-801.opt.latin1sw 0.76
write-only
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
1886 2158 2644 in-5635.opt
1793 2105 2340 in-5717.opt 0.95
1831 2137 2446 in-801.opt
1848 2178 2497 in-801.opt.latin1sw 0.98
- nuc.i5
6528 8085 10998 in-5635.opt
5054 5736 7790 in-5717.opt 0.77
4986 5949 7704 in-801.opt
5044 6033 8527 in-801.opt.latin1sw 0.77
read-write.range=100
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
3370 4729 5555 in-5635.opt
3534 4674 5469 in-5717.opt 1.05
2719 3872 4795 in-801.opt
2808 3982 4924 in-801.opt.latin1sw 0.83
- nuc.i5
9486 13743 16959 in-5635.opt
6124 9004 12119 in-5717.opt 0.65
6003 9062 11767 in-801.opt
6080 9310 12359 in-801.opt.latin1sw 0.64
read-write.range=10000
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
241 425 596 in-5635.opt
370 599 782 in-5717.opt 1.54
121 206 249 in-801.opt
170 301 345 in-801.opt.latin1sw 0.71
- nuc.i5
477 883 1283 in-5635.opt
307 567 658 in-5717.opt 0.64
215 387 464 in-801.opt
301 561 656 in-801.opt.latin1sw 0.63
read-only.range=10
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
11219 19683 27638 in-5635.opt
11299 19230 26507 in-5717.opt 1.01
7366 12594 17138 in-801.opt
7513 12963 17306 in-801.opt.latin1sw 0.67
- nuc.i5
23964 44606 71554 in-5635.opt
16451 28320 35850 in-5717.opt 0.69
15965 26582 34411 in-801.opt
15856 27548 34657 in-801.opt.latin1sw 0.66
read-only.range=100
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
7455 13236 19261 in-5635.opt
8270 14290 20241 in-5717.opt 1.11
4538 7632 10969 in-801.opt
4692 7988 11939 in-801.opt.latin1sw 0.63
- nuc.i5
16048 30583 47707 in-5635.opt
10048 17295 22057 in-5717.opt 0.63
8972 15829 20364 in-801.opt
9699 16682 21538 in-801.opt.latin1sw 0.60
read-only.range=1000
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
1779 3269 4742 in-5635.opt
2566 4505 6048 in-5717.opt 1.44
922 1637 1972 in-801.opt
1285 2165 2631 in-801.opt.latin1sw 0.72
- nuc.i5
3760 7292 10367 in-5635.opt
2377 4393 5307 in-5717.opt 0.63
1727 3113 3562 in-801.opt
2351 4306 5231 in-801.opt.latin1sw 0.63
read-only.range=10000
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
208 378 524 in-5635.opt
320 522 683 in-5717.opt 1.54
103 168 202 in-801.opt
141 245 281 in-801.opt.latin1sw 0.68
- nuc.i5
403 744 1058 in-5635.opt
259 465 536 in-5717.opt 0.64
182 313 375 in-801.opt
256 459 529 in-801.opt.latin1sw 0.64
point-query
1 2 4 concurrency vs 5.6.35 at 1 thread
- nuc.i3
12944 23440 33489 in-5635.opt
12557 21862 30755 in-5717.opt 0.97
8193 15006 19780 in-801.opt
8502 15003 19706 in-801.opt.latin1sw 0.66
- nuc.i5
28209 52799 87226 in-5635.opt
18879 32764 41261 in-5717.opt 0.67
18816 30295 38841 in-801.opt
17984 31100 39225 in-801.opt.latin1sw 0.64
insert
- nuc.i3
1 2 4 concurrency vs 5.6.35 at 1 thread
2356 4437 4540 in-5635.opt
2057 4429 4614 in-5717.opt 0.87
1943 4382 4710 in-801.opt
1940 4304 4770 in-801.opt.latin1sw 0.64
- nuc.i5
8563 12079 12692 in-5635.opt
7501 12863 13582 in-5717.opt 0.87
6703 10166 13521 in-801.opt
7234 10310 13539 in-801.opt.latin1sw 0.82
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment