Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Last active May 10, 2017 23:21
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save mdcallag/de5d1793e90c59321ab598872c9a4ae1 to your computer and use it in GitHub Desktop.
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.latin1bin - 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
552 687 810 in-5635.opt
563 678 752 in-5717.opt
557 666 781 in-801.opt
554 670 777 in-801.opt.latin1bin
558 668 779 in-801.opt.latin1sw
update-nonindex
1 2 4 concurrency
2887 3835 4364 in-5635.opt
2586 3273 3840 in-5717.opt
2258 3028 3597 in-801.opt
2297 3052 3584 in-801.opt.latin1bin
2316 3069 3692 in-801.opt.latin1sw
write-only
1 2 4 concurrency
1886 2158 2644 in-5635.opt
1793 2105 2340 in-5717.opt
1831 2137 2446 in-801.opt
2021 2687 3601 in-801.opt.latin1bin
1998 2677 3609 in-801.opt.latin1sw
read-write.range=100
1 2 4 concurrency
3370 4729 5555 in-5635.opt
3534 4674 5469 in-5717.opt
2719 3872 4795 in-801.opt
2911 4027 4938 in-801.opt.latin1bin
2808 3982 4924 in-801.opt.latin1sw
read-write.range=10000
1 2 4 concurrency
241 425 596 in-5635.opt
370 599 782 in-5717.opt
121 206 249 in-801.opt
174 303 349 in-801.opt.latin1bin
170 301 345 in-801.opt.latin1sw
read-only.range=10
1 2 4 concurrency
11219 19683 27638 in-5635.opt
11299 19230 26507 in-5717.opt
7366 12594 17138 in-801.opt
7550 13037 17509 in-801.opt.latin1bin
7513 12963 17306 in-801.opt.latin1sw
read-only.range=100
1 2 4 concurrency
7455 13236 19261 in-5635.opt
8270 14290 20241 in-5717.opt
4538 7632 10969 in-801.opt
4743 8237 12214 in-801.opt.latin1bin
4692 7988 11939 in-801.opt.latin1sw
read-only.range=1000
1 2 4 concurrency
1779 3269 4742 in-5635.opt
2566 4505 6048 in-5717.opt
922 1637 1972 in-801.opt
1291 2168 2658 in-801.opt.latin1bin
1285 2165 2631 in-801.opt.latin1sw
read-only.range=10000
1 2 4 concurrency
208 378 524 in-5635.opt
320 522 683 in-5717.opt
103 168 202 in-801.opt
139 247 284 in-801.opt.latin1bin
141 245 281 in-801.opt.latin1sw
point-query
1 2 4 concurrency
12944 23440 33489 in-5635.opt
12557 21862 30755 in-5717.opt
8193 15006 19780 in-801.opt
8560 15174 19850 in-801.opt.latin1bin
8502 15003 19706 in-801.opt.latin1sw
insert
1 2 4 concurrency
2356 4437 4540 in-5635.opt
2057 4429 4614 in-5717.opt
1943 4382 4710 in-801.opt
1940 4301 4738 in-801.opt.latin1bin
1940 4304 4770 in-801.opt.latin1sw
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment