Last active
May 30, 2017 16:17
-
-
Save mdcallag/fc2042fa91f074d44d861d66477a3659 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
| 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