Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Last active November 22, 2016 14:45
  • 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/f661b8f5781c998cf67de812a11b1a30 to your computer and use it in GitHub Desktop.
Notes:
* All tests are for InnoDB from upstream MySQL 5.6.26
Legend:
* innodb.8t.1m.rr.ps0 - 8 tables, 1M rows/table, repeatable-read, performance_schema=0
* innodb.8t.1m.rr.ps1 - 8 tables, 1M rows/table, repeatable-read, performance_schema=1
* innodb.8t.1m.rc.ps0 - 8 tables, 10M rows/table, read-committed, performance_schema=0
* innodb.8t.1m.rc.ps1 - 8 tables, 10M rows/table, read-committed, performance_schema=1
--- QPS, update indexed
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
4366 9229 17684 30718 41584 44935 46025 45967 46349 46344 45946 45698 45693 innodb.8t.1m.rr.ps0
4391 9172 17117 29402 40450 43732 44435 45176 45123 45336 45108 44737 44728 innodb.8t.1m.rr.ps1
4491 9214 17793 30375 41513 44471 45866 46298 46133 45911 45906 45480 45353 innodb.8t.1m.rc.ps0
4405 9115 17279 29421 40488 44179 45110 45301 45721 45456 45067 44964 44793 innodb.8t.1m.rc.ps1
-
3568 7417 12863 18319 24114 26248 31430 35162 34460 34110 33559 33110 32064 innodb.8t.10m.rr.ps0
3613 7298 12626 18223 23669 25977 30725 34729 34025 33763 33356 33011 32038 innodb.8t.10m.rr.ps1
3115 7174 12646 18424 24097 28054 35739 34890 34439 34057 33447 32812 31758 innodb.8t.10m.rc.ps0
3297 6950 12228 18125 23751 26055 31899 34733 34214 33637 33139 32397 31641 innodb.8t.10m.rc.ps1
--- QPS, update non-indexed
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
6125 12086 23260 40693 52398 53622 54101 53979 53451 52594 52249 51785 51298 innodb.8t.1m.rr.ps0
6181 11750 22720 39027 50854 52129 52323 52592 52255 51398 50923 50691 50392 innodb.8t.1m.rr.ps1
5888 12354 23645 40909 52228 53493 54088 53959 53655 52531 51973 51489 51047 innodb.8t.1m.rc.ps0
5963 11649 22801 39548 50957 52245 52696 52742 52531 51664 50980 50613 50236 innodb.8t.1m.rc.ps1
-
5099 9640 16894 37057 50212 50814 51301 51025 50492 49561 48968 48610 48272 innodb.8t.10m.rr.ps0
4967 9248 16444 36460 48878 49973 50184 50095 49670 49007 48316 48154 47910 innodb.8t.10m.rr.ps1
5120 9461 16332 31640 50392 51233 51531 51383 50965 50044 49486 48958 48534 innodb.8t.10m.rc.ps0
5072 9421 16212 37829 49133 50238 50503 50426 49881 48949 48453 47918 47638 innodb.8t.10m.rc.ps1
--- QPS, read-write range=100
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
8314 16876 33480 66718 117444 153028 179296 197701 202166 200302 201786 202974 201475 innodb.8t.1m.rr.ps0
8270 16474 32204 63246 112527 145929 170619 187174 191269 190728 192687 191556 191020 innodb.8t.1m.rr.ps1
8427 16527 33321 65368 116757 149372 175584 191668 191315 187851 185517 174268 153715 innodb.8t.1m.rc.ps0
8302 16064 32385 64301 113177 143384 167114 182953 183534 179784 179243 169131 152041 innodb.8t.1m.rc.ps1
-
7517 15366 30478 59196 100328 121675 107992 104390 118222 143449 141285 142684 141407 innodb.8t.10m.rr.ps0
7263 14910 29438 57104 97890 119456 106621 103467 114564 140286 140281 138049 137810 innodb.8t.10m.rr.ps1
7092 14692 29471 56407 98184 121125 106968 104974 118237 142476 141486 138828 136226 innodb.8t.10m.rc.ps0
6950 14460 28603 55674 96293 119287 106570 102696 115666 138965 137608 135756 133867 innodb.8t.10m.rc.ps1
--- QPS, read-only range=10
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
6678 14425 31271 78457 156380 207340 247109 286902 321541 325513 325403 323809 327930 innodb.8t.1m.rr.ps0
6505 13804 29582 71948 143573 193773 231097 265486 296188 301727 303300 304557 303913 innodb.8t.1m.rr.ps1
6654 14358 30944 77333 151803 197363 231916 254382 241868 202093 174799 156131 118500 innodb.8t.1m.rc.ps0
6494 13693 29397 71486 140394 187313 219329 243007 236435 204960 180135 152991 121525 innodb.8t.1m.rc.ps1
-
7094 14365 27701 62898 147220 196154 235163 272451 302507 308191 308980 310977 312467 innodb.8t.10m.rr.ps0
6900 13698 26803 61192 135874 184973 219876 252769 280506 285490 287829 288788 290774 innodb.8t.10m.rr.ps1
6883 13447 25748 63748 142357 189276 222753 248668 240253 214605 185880 154681 119791 innodb.8t.10m.rc.ps0
6554 12874 25315 62399 132995 178623 210308 239212 245888 216249 197486 161896 127849 innodb.8t.10m.rc.ps1
--- QPS, read-only range=100
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
5514 11754 24200 57837 118183 159311 187715 215921 240846 243613 244607 243462 245357 innodb.8t.1m.rr.ps0
5361 11259 23245 53797 109077 150584 176817 202008 225970 227482 227588 228302 231183 innodb.8t.1m.rr.ps1
5490 11670 23874 57067 115080 154444 180064 205667 224934 209997 195375 173749 138791 innodb.8t.1m.rc.ps0
5352 11288 23184 53775 107615 146322 171430 192727 211105 206984 191422 176375 144019 innodb.8t.1m.rc.ps1
-
5267 11048 22834 53744 110504 149719 176852 204336 228590 228020 229353 231927 231467 innodb.8t.10m.rr.ps0
5110 10715 22096 50753 103003 142342 166854 192342 214608 216130 216183 216118 218079 innodb.8t.10m.rr.ps1
5232 11010 22721 53037 107870 146513 172084 195868 212674 205803 191408 176438 141268 innodb.8t.10m.rc.ps0
5100 10721 22030 50416 101758 139518 162895 184997 203779 198977 187488 175583 147264 innodb.8t.10m.rc.ps1
--- QPS, read-only range=1000
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
1969 3966 7944 16215 32967 46300 52910 59281 64400 63464 63743 63158 62454 innodb.8t.1m.rr.ps0
1889 3824 7655 15694 31651 44588 51121 56893 61632 60951 60709 60441 60456 innodb.8t.1m.rr.ps1
1953 3935 7914 16184 32731 46075 52791 58389 63949 63284 62899 62294 61740 innodb.8t.1m.rc.ps0
1883 3799 7639 15631 31488 44268 50696 56159 60988 60840 60175 59810 59496 innodb.8t.1m.rc.ps1
-
1816 3660 7344 14952 30427 43034 49660 55266 60388 59983 59614 59450 59143 innodb.8t.10m.rr.ps0
1756 3544 7131 14503 29312 41410 47850 53392 57710 57778 57373 57223 56977 innodb.8t.10m.rr.ps1
1819 3669 7336 14905 30246 42777 49279 55042 59477 59288 59126 58527 58299 innodb.8t.10m.rc.ps0
1762 3551 7097 14458 29245 41273 47598 53149 57828 57373 56604 56120 56246 innodb.8t.10m.rc.ps1
--- QPS, read-only range=10000
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
246 493 979 1936 3801 5192 5956 6546 6875 6766 6746 6725 6666 innodb.8t.1m.rr.ps0
241 481 954 1887 3708 5084 5826 6403 6676 6640 6589 6493 6496 innodb.8t.1m.rr.ps1
246 493 979 1939 3808 5209 5973 6591 6829 6773 6745 6738 6664 innodb.8t.1m.rc.ps0
241 480 951 1882 3698 5054 5751 6340 6629 6603 6515 6548 6502 innodb.8t.1m.rc.ps1
-
233 468 932 1847 3621 4908 5631 6215 6474 6450 6409 6381 6272 innodb.8t.10m.rr.ps0
228 456 909 1803 3527 4799 5513 6086 6250 6278 6252 6205 6151 innodb.8t.10m.rr.ps1
233 468 932 1853 3633 4927 5662 6222 6455 6451 6410 6370 6249 innodb.8t.10m.rc.ps0
227 456 910 1805 3539 4810 5523 6083 6303 6282 6231 6168 6151 innodb.8t.10m.rc.ps1
--- QPS, point-query
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
7382 15669 34916 94675 192132 252784 299646 346925 388394 400866 402500 403122 404918 innodb.8t.1m.rr.ps0
7192 15281 33383 87425 178670 237002 276261 320092 361250 372291 374374 376012 377175 innodb.8t.1m.rr.ps1
7383 15798 34766 95497 195914 252361 300687 346192 390782 401274 404413 402050 406306 innodb.8t.1m.rc.ps0
7194 15173 33556 87348 180118 237158 278993 320630 358987 372479 375859 378131 372449 innodb.8t.1m.rc.ps1
-
7178 15171 33366 87334 181537 239432 285659 331929 374868 376199 382512 380674 290054 innodb.8t.10m.rr.ps0
6954 14681 32025 82899 170120 223467 267445 308850 347555 353788 356700 357260 358753 innodb.8t.10m.rr.ps1
7124 15185 33270 88635 182363 240398 286694 333540 378016 381952 383097 384131 301032 innodb.8t.10m.rc.ps0
6954 14631 31880 82920 170385 224934 267406 309162 349537 354782 358016 358341 292210 innodb.8t.10m.rc.ps1
--- QPS, select
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
7478 15880 35084 95407 195121 254790 302353 347769 393154 403039 400394 407763 407154 innodb.8t.1m.rr.ps0
7224 15334 33682 88125 180420 235254 280710 322194 360958 369765 375347 377304 377245 innodb.8t.1m.rr.ps1
7451 15985 35334 96315 195555 255547 302520 349843 391155 402832 405974 402939 409165 innodb.8t.1m.rc.ps0
7239 15368 33706 88072 180638 237872 280463 322675 363271 373424 375410 373117 377331 innodb.8t.1m.rc.ps1
-
7182 15356 33502 88673 182517 240658 287205 333183 373989 379425 382685 386175 287335 innodb.8t.10m.rr.ps0
7001 14764 32281 82925 169487 225434 268373 310422 346927 356247 357611 359758 286786 innodb.8t.10m.rr.ps1
7201 15214 33695 89625 182985 241092 287693 333530 378721 383673 386552 387121 298788 innodb.8t.10m.rc.ps0
6997 14837 32052 82684 169675 225603 267647 311191 347228 357179 359371 359940 358523 innodb.8t.10m.rc.ps1
--- QPS, insert
1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine
5873 12220 35191 57462 64646 64090 64087 63342 62798 61716 59991 57683 53489 innodb.8t.1m.rr.ps0
5723 11751 34197 55303 62949 62658 62669 62114 61393 60485 58778 56523 52670 innodb.8t.1m.rr.ps1
5900 12414 35384 57458 64797 64342 64308 63689 63095 62057 60173 57674 53387 innodb.8t.1m.rc.ps0
5713 11752 34728 55859 63276 62847 63023 62272 61780 60613 58768 56416 52260 innodb.8t.1m.rc.ps1
-
6182 12058 33903 52251 59034 58616 57480 53676 51725 50246 48631 46767 43807 innodb.8t.10m.rr.ps0
5958 11615 32794 51042 57778 57501 56346 53298 50977 49660 48172 46566 43740 innodb.8t.10m.rr.ps1
6127 12345 33101 52615 59679 59294 58177 54230 52353 50591 49058 46948 43901 innodb.8t.10m.rc.ps0
5940 11738 32155 50922 58001 57660 56456 53617 50942 49587 47922 46144 42966 innodb.8t.10m.rc.ps1
@MarkLeith
Copy link

"* innodb.8t.1m.rc.ps0 - 8 tables, 10M rows/table, repeatable-read, performance_schema=0

  • innodb.8t.1m.rc.ps1 - 8 tables, 10M rows/table, repeatable-read, performance_schema=1"

Surely the ".rc." means "read-committed" for all of these results?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment