Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created June 19, 2017 16:39
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/8a2c79bdacbf40bb306a725bd28d9d54 to your computer and use it in GitHub Desktop.
Save mdcallag/8a2c79bdacbf40bb306a725bd28d9d54 to your computer and use it in GitHub Desktop.
legend:
* inno5635 - InnoDB in MySQL 5.6.35 with performance_schema=1
* inno5635.ps0 - InnoDB in MySQL 5.6.35 with performance_schema=0
* inno5717 - InnoDB in MySQL 5.7.17 with performance_schema=1
* inno5717.ps0 - InnoDB in MySQL 5.7.17 with performance_schema=0
* inno801.latin1sw - InnoDB in MySQL 8.0.1 with performance_schema=1, latin1 charset, latin1_swedish_ci collation
* inno801.latin1sw.ps0 - InnoDB in MySQL 8.0.1 with performance_schema=0, latin1 charset, latin1_swedish_ci collation
update-index
1 2 4 concurrency/release
9549 15559 19024 inno5635
9773 15912 19397 inno5635.ps0
6343 10669 13598 inno5717
6510 10978 14259 inno5717.ps0
6980 12259 14180 inno801.latin1sw
7248 12438 14616 inno801.latin1sw.ps0
update-nonindex
1 2 4 concurrency/release
16103 23903 28253 inno5635
16484 24714 29137 inno5635.ps0
9164 14051 19850 inno5717
9456 14494 20620 inno5717.ps0
9897 16355 19527 inno801.latin1sw
10349 17143 20221 inno801.latin1sw.ps0
delete
1 2 4 concurrency/release
30153 44769 55864 inno5635
30924 46327 58097 inno5635.ps0
17580 25020 34325 inno5717
18460 26060 35698 inno5717.ps0
17416 27628 35671 inno801.latin1sw
18244 29049 37468 inno801.latin1sw.ps0
write-only
1 2 4 concurrency/release
26455 38699 46983 inno5635
26934 39604 48254 inno5635.ps0
16060 23040 30218 inno5717
16643 23923 31137 inno5717.ps0
15347 24016 30971 inno801.latin1sw
15838 25211 32653 inno801.latin1sw.ps0
read-write.range100
1 2 4 concurrency/release
18675 28933 39662 inno5635
19297 29811 39964 inno5635.ps0
11070 16849 22268 inno5717
11307 17354 22541 inno5717.ps0
10789 16685 22916 inno801.latin1sw
11114 17091 23506 inno801.latin1sw.ps0
read-write.range10000
1 2 4 concurrency/release
516 921 1315 inno5635
532 941 1315 inno5635.ps0
304 588 664 inno5717
303 589 668 inno5717.ps0
300 578 653 inno801.latin1sw
301 586 660 inno801.latin1sw.ps0
read-only.range10
1 2 4 concurrency/release
27569 48455 79829 inno5635
28928 50561 83302 inno5635.ps0
16879 29834 40095 inno5717
16886 30933 41651 inno5717.ps0
15619 28796 40744 inno801.latin1sw
16464 30780 41009 inno801.latin1sw.ps0
read-only.range100
1 2 4 concurrency/release
17911 32799 51344 inno5635
18472 34254 53654 inno5635.ps0
10748 20427 24820 inno5717
10544 19977 25728 inno5717.ps0
10180 18182 25071 inno801.latin1sw
10536 17137 25459 inno801.latin1sw.ps0
read-only.range1000
1 2 4 concurrency/release
3994 7446 10591 inno5635
4078 7751 10910 inno5635.ps0
2487 4652 5215 inno5717
2545 4670 5308 inno5717.ps0
2529 4592 5255 inno801.latin1sw
2549 4623 5278 inno801.latin1sw.ps0
read-only.range10000
1 2 4 concurrency/release
411 750 1063 inno5635
424 770 1064 inno5635.ps0
246 465 538 inno5717
248 466 535 inno5717.ps0
245 457 498 inno801.latin1sw
245 463 533 inno801.latin1sw.ps0
point-query
1 2 4 concurrency/release
31813 57071 84517 inno5635
33486 60662 90018 inno5635.ps0
18979 33834 46224 inno5717
18786 34889 49380 inno5717.ps0
17686 32609 45099 inno801.latin1sw
18967 34759 47958 inno801.latin1sw.ps0
insert
1 2 4 concurrency/release
17059 25500 26545 inno5635
17339 23668 23372 inno5635.ps0
11752 18547 22157 inno5717
12484 19279 21601 inno5717.ps0
11378 17495 21591 inno801.latin1sw
11605 18030 22012 inno801.latin1sw.ps0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment