Created
October 17, 2017 19:13
-
-
Save mdcallag/74f3646bdbed129a51560ce49e2318df 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
| Test is modern sysbench with 8 tables, 1M rows per table. Database is cached. | |
| Server has fast SSD, 24 real cores and 48 HW threads with HT enabled. | |
| Tests are described at http://smalldatum.blogspot.com/2017/02/using-modern-sysbench-to-compare.html | |
| Each test has 4 groups of results: | |
| group 1) binlog on, sync_binlog=0, flush_log_at_trx_commit=2 | |
| group 2) binlog off, flush_log_at_trx_commit=2 | |
| group 3) binlog off, flush_log_at_trx_commit=1 | |
| group 4) binlog on, sync_binlog=1, flush_log_at_trx_commit=1 | |
| Performance summary: | |
| group 1) 803labs performance is lousy | |
| group 2) 803labs performance is lousy | |
| group 3) 803labs helps at 16 or more threads except for insert-only | |
| group 4) 803labs is close but usually worse | |
| update-inlist | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 3459 6502 12482 23106 34014 39263 39338 40258 40665 39924 inno803 | |
| 1425 2001 2035 2716 5630 7457 9306 9068 10863 14036 inno803labs | |
| - | |
| 5548 10534 20022 36295 53724 54830 48438 41598 38150 37471 inno803.nobl | |
| 1655 1660 1935 3058 6945 9116 11400 12228 13642 15290 inno803labs.nobl | |
| - | |
| 3514 6896 13105 23332 36981 47813 49452 45966 41034 37618 inno803.nobl.trx1 | |
| 3336 6525 12729 24122 44032 59124 66697 65484 63784 64026 inno803labs.nobl.trx1 | |
| - | |
| 1724 3497 7229 12688 20926 27395 31182 33380 34771 37331 inno803.bl1.trx1 | |
| 1749 3395 6514 11964 19964 25906 30087 31367 31987 35360 inno803labs.bl1.trx1 | |
| update-one | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 8049 15294 28037 44916 56810 58665 59378 59442 55427 54238 inno803 | |
| 368 4332 4711 3557 5513 5818 5290 5509 3787 4930 inno803labs | |
| - | |
| 11025 21531 41689 76037 111228 110632 104671 99804 84065 71577 inno803.nobl | |
| 370 1040 2532 7128 6813 7129 6601 5726 5458 6452 inno803labs.nobl | |
| - | |
| 5749 11216 18375 33883 59374 75003 82072 83473 82007 70572 inno803.nobl.trx1 | |
| 5520 9640 18691 36261 64632 87212 98475 98930 94954 71406 inno803labs.nobl.trx1 | |
| - | |
| 2540 4802 8753 13434 17496 19007 19895 20210 20290 20429 inno803.bl1.trx1 | |
| 2494 4648 8133 12136 15549 17116 17817 18080 18158 18413 inno803labs.bl1.trx1 | |
| update-index | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 5502 11652 23392 41951 66038 80980 87953 90272 90716 92197 inno803 | |
| 869 1089 1835 4438 8815 11484 13692 12936 11507 14657 inno803labs | |
| - | |
| 6969 15384 31630 60026 119884 145091 157539 159870 163354 169561 inno803.nobl | |
| 822 1141 2891 6175 9723 17725 47727 32560 54400 33250 inno803labs.nobl | |
| - | |
| 4033 8461 15658 29136 51825 69868 83412 89152 91125 91575 inno803.nobl.trx1 | |
| 3956 8139 16110 31146 57891 84628 103818 117025 126365 138123 inno803labs.nobl.trx1 | |
| - | |
| 2074 4533 8963 16796 30777 40861 48638 54609 59463 66991 inno803.bl1.trx1 | |
| 2118 4354 8223 15360 27379 37023 44418 49602 54384 62661 inno803labs.bl1.trx1 | |
| update-nonindex | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 7787 15047 28541 48851 73622 86060 93109 95534 96982 98445 inno803 | |
| 3208 7897 13413 17697 24481 32524 36677 42151 48260 57741 inno803labs | |
| - | |
| 10719 21076 40964 77181 127736 157415 175184 179129 180202 179379 inno803.nobl | |
| 6197 11408 21115 33850 54569 84670 96601 107867 114675 122134 inno803labs.nobl | |
| - | |
| 5657 10990 18511 33632 59008 76591 87990 93981 96673 95430 inno803.nobl.trx1 | |
| 4860 9533 18590 36252 67379 94373 115565 128674 134829 128991 inno803labs.nobl.trx1 | |
| - | |
| 2577 5015 9821 18181 31839 44169 52825 59561 65561 73792 inno803.bl1.trx1 | |
| 2517 4849 9150 16617 27810 37770 46729 53623 59585 68234 inno803labs.bl1.trx1 | |
| delete-only | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 15533 30959 60358 112220 180255 221392 246569 252382 253091 258293 inno803 | |
| 6813 9986 10566 11364 17215 40708 44695 58023 57950 61223 inno803labs | |
| - | |
| 19991 39274 76353 145016 249380 318683 355936 387948 406516 386721 inno803.nobl | |
| 10946 7443 12564 19230 27664 47657 68818 62132 70539 72314 inno803labs.nobl | |
| - | |
| 12703 25567 49443 92780 157607 203465 238827 251614 256291 256879 inno803.nobl.trx1 | |
| 12525 24267 47550 91075 164561 222396 260710 281738 302181 333967 inno803labs.nobl.trx1 | |
| - | |
| 7373 14749 30566 56017 98867 131230 154395 169928 187630 208159 inno803.bl1.trx1 | |
| 7428 14182 27358 50271 87484 118107 138017 158809 172449 193425 inno803labs.bl1.trx1 | |
| read-write --range-size=100 | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 10849 22097 43847 84949 152275 208403 236919 259390 272925 272959 inno803 | |
| 8942 19895 27269 47439 72905 97535 104216 110924 128656 104031 inno803labs | |
| - | |
| 11548 23174 45720 89822 162011 221018 251499 282774 304921 306828 inno803.nobl | |
| 7980 13710 27328 48889 65748 81569 90366 98612 126051 158166 inno803labs.nobl | |
| - | |
| 10190 20699 42196 83683 153294 202121 236306 259785 275805 278817 inno803.nobl.trx1 | |
| 10584 21163 42355 82155 144407 194647 224552 241577 258020 283129 inno803labs.nobl.trx1 | |
| - | |
| 9077 18149 36777 73558 135320 177528 208140 225822 238186 248461 inno803.bl1.trx1 | |
| 9029 18364 36624 71201 125195 167980 199086 214142 227135 240889 inno803labs.bl1.trx1 | |
| insert-only | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 9041 16896 32063 55355 82403 94475 102205 106211 108623 112468 inno803 | |
| 3753 5574 4615 7002 7622 6766 7398 6533 7749 6749 inno803labs | |
| - | |
| 12339 24028 46020 86712 142446 171427 189404 193692 192130 191645 inno803.nobl | |
| 4313 8448 9895 8372 8394 6764 7418 7702 9529 6171 inno803labs.nobl | |
| - | |
| 5816 10301 18927 36844 68278 95675 117590 136617 149027 164396 inno803.nobl.trx1 | |
| 6028 11494 19929 35369 61727 79614 90250 95976 97727 97734 inno803labs.nobl.trx1 | |
| - | |
| 2387 5120 9481 18331 34176 46887 56848 64115 70375 80088 inno803.bl1.trx1 | |
| 2431 4722 9011 16816 29420 39647 49609 57568 63777 72968 inno803labs.bl1.trx1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment