Created
June 21, 2018 17:15
-
-
Save mdcallag/9cfd27ad1f200a3f2602472c661f47f7 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
| scan | |
| pre post pre post pre post | |
| secs secs Mrps Mrps Mcpu/o Mcpu/o engine | |
| 29 33 2.758 2.424 1.050 1.325 myrocks.8may18.none | |
| 28 35 2.857 2.285 1.150 1.400 myrocks.8may18.none.fix | |
| 17 16 4.705 5.000 1.375 1.275 inno.o5717.ahi | |
| 17 17 4.705 4.705 1.550 1.250 inno.o5717.noahi | |
| update-inlist | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 2250 3944 7312 13566 19644 19856 19946 19395 19009 19273 myrocks.8may18.none | |
| 2231 3943 7404 13601 19691 19936 20076 19583 19333 19368 myrocks.8may18.none.fix | |
| 5048 8984 16691 24905 29423 29288 29327 28387 28035 27958 inno.o5717.ahi | |
| 4548 8170 15640 24953 29525 29538 29225 28688 28055 27877 inno.o5717.noahi | |
| * inno 2x faster at low, mid and 1.5x faster at high | |
| update-inlist.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 1556 2878 5449 10142 16983 18119 18513 17985 17474 16847 myrocks.8may18.none | |
| 1606 2987 5711 10712 17827 18700 18684 18246 17756 17278 myrocks.8may18.none.fix | |
| 1600 2980 5688 10735 17943 18751 18774 18209 17675 17223 myrocks.8may18.none.fix | |
| 4265 7193 13069 21368 27495 28213 25514 23637 22561 21525 inno.o5717.ahi | |
| 3246 5898 11127 19954 27621 28035 25269 22904 21682 20668 inno.o5717.noahi | |
| * inno 2x faster at low, mid and 1.5x faster at high | |
| update-one | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 9752 17350 17551 17261 16696 15136 14069 13121 12458 10547 myrocks.8may18.none | |
| 10048 18381 17963 17586 16923 15308 14220 13318 12611 10777 myrocks.8may18.none.fix | |
| 9847 18405 17535 13242 12844 13198 13033 12782 12464 10755 inno.o5717.ahi | |
| 9706 17720 17801 13310 13246 13111 13112 12705 12270 10531 inno.o5717.noahi | |
| update-one.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 7449 13984 14418 13544 12183 10252 8865 7867 7056 5337 myrocks.8may18.none | |
| 7608 14152 14499 13670 12308 10306 8929 7897 7154 5302 myrocks.8may18.none.fix | |
| 7608 14198 14420 13659 12243 10253 8855 7851 7102 5321 myrocks.8may18.none.fix | |
| 8839 16349 16382 12222 11622 11253 11476 10868 10677 9140 inno.o5717.ahi | |
| 8885 16013 15859 12419 11451 11297 11393 10851 10457 9205 inno.o5717.noahi | |
| update-index | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 6991 13066 24575 39325 49153 53181 53426 52529 52118 53389 myrocks.8may18.none | |
| 7145 13300 25210 39810 49691 53989 54315 53627 52970 54465 myrocks.8may18.none.fix | |
| 3813 7695 24536 48442 71010 83148 87738 88620 87951 88222 inno.o5717.ahi | |
| 3791 7724 24504 48125 71287 83761 87894 88427 88148 87811 inno.o5717.noahi | |
| * myrocks is 2x faster at low, inno 1.2x faster at mid and 1.5x faster at high | |
| update-index.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 5544 10360 20040 35843 45648 49619 51250 50741 49778 50719 myrocks.8may18.none | |
| 5658 10654 20560 36233 45821 50189 52098 51207 50485 51359 myrocks.8may18.none.fix | |
| 5648 10564 20451 36197 45879 50059 52019 51481 50808 51497 myrocks.8may18.none.fix | |
| 3960 8091 20072 44041 65463 77372 80639 80206 79280 78606 inno.o5717.ahi | |
| 3902 8051 20227 43965 65592 77427 81066 80947 79499 79129 inno.o5717.noahi | |
| * myrocks almost 1.5x faster at low, inno faster at mid and 1.5x faster at high | |
| update-nonindex | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 7151 13450 25857 43908 56600 61345 63327 62812 61820 62697 myrocks.8may18.none | |
| 7292 13827 26429 44434 57127 62393 64066 64005 62860 63659 myrocks.8may18.none.fix | |
| 9710 18208 34502 56547 78973 89632 92291 92405 92174 93359 inno.o5717.ahi | |
| 9409 17688 33683 55984 78544 89253 90720 91815 92315 92264 inno.o5717.noahi | |
| * inno up to 1.5x faster | |
| update-nonindex.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 5601 10804 20912 38244 51763 57083 59740 59883 59100 59574 myrocks.8may18.none | |
| 5723 10702 21170 38656 52557 57679 60007 60621 59920 60350 myrocks.8may18.none.fix | |
| 5675 10931 21319 38550 52534 57811 60436 61155 60067 60606 myrocks.8may18.none.fix | |
| 8215 15465 29603 50284 72110 82818 84220 84548 83987 83889 inno.o5717.ahi | |
| 8040 15279 29530 49902 71850 83086 84639 84602 84573 84525 inno.o5717.noahi | |
| * inno up to 1.5x faster | |
| delete | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 17079 32451 63590 115926 145576 159058 163763 164722 166214 164935 myrocks.8may18.none | |
| 17386 33365 64198 117226 147758 158211 166396 166872 169437 168371 myrocks.8may18.none.fix | |
| 16422 33235 64576 114134 177252 206976 234204 252037 248887 257093 inno.o5717.ahi | |
| 18426 35748 69923 127194 199183 244957 265735 271567 272125 273967 inno.o5717.noahi | |
| * inno 1.3x faster at high | |
| delete.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 12630 23741 46148 86649 116308 120252 130403 130225 134813 130390 myrocks.8may18.none | |
| 12940 24212 46953 87343 116245 122860 131000 130506 133377 132086 myrocks.8may18.none.fix | |
| 12833 24181 47034 87117 117783 122903 129577 131922 134467 131308 myrocks.8may18.none.fix | |
| 3135 4872 5104 4919 4892 145699 183571 169389 159839 164262 inno.o5717.ahi | |
| 7101 12402 15081 70526 156266 190882 181413 177298 178394 173568 inno.o5717.noahi | |
| * inno is odd here | |
| read-write range=100 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 8827 17490 34763 69121 130699 177611 216323 240733 257696 257419 myrocks.8may18.none | |
| 9059 18037 35748 70720 133880 181639 221245 244019 264338 262205 myrocks.8may18.none.fix | |
| 12497 25476 50427 98015 175853 239970 279690 310018 332494 359480 inno.o5717.ahi | |
| 12398 25039 49824 96788 177980 245256 288592 325401 349657 375514 inno.o5717.noahi | |
| * inno is about 1.3x faster | |
| read-write range=100.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 2937 6159 11638 22973 42544 56866 66723 74661 81654 85878 myrocks.8may18.none | |
| 3202 6529 12436 22964 42920 58620 67184 75086 82009 86951 myrocks.8may18.none.fix | |
| 3158 6156 12010 23019 42514 57697 66651 74891 82142 87440 myrocks.8may18.none.fix | |
| 5369 11613 22566 36713 81773 103922 115166 118299 116682 117702 inno.o5717.ahi | |
| 4946 9884 19731 37005 61454 78366 91121 99523 106335 109294 inno.o5717.noahi | |
| * inno is at least 1.3x faster | |
| read-write range=10000 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 302 604 1217 2390 4647 6662 7739 8357 8934 9167 myrocks.8may18.none | |
| 305 616 1229 2418 4716 6713 7841 8396 9027 9302 myrocks.8may18.none.fix | |
| 550 1097 2169 4221 7915 10700 11712 12198 12176 12447 inno.o5717.ahi | |
| 548 1094 2160 4193 7861 10659 11697 12141 12215 12340 inno.o5717.noahi | |
| * inno is at least 1.5x faster | |
| read-write range=10000.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 50 94 187 355 672 920 1058 1153 1254 1320 myrocks.8may18.none | |
| 46 87 171 329 679 950 1089 1180 1284 1336 myrocks.8may18.none.fix | |
| 45 88 173 333 724 984 1124 1218 1334 1392 myrocks.8may18.none.fix | |
| 178 326 606 1050 1450 1513 1509 1506 1496 1465 inno.o5717.ahi | |
| 102 175 334 609 910 991 1057 1139 1208 1258 inno.o5717.noahi | |
| * inno is > 2x faster at low, mid and 1.5x faster at high | |
| read-only range=100 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 8840 17730 35515 70358 134759 186789 233566 260102 286624 313981 myrocks.8may18.none | |
| 8997 17795 35469 70155 135156 186959 233716 260129 285949 314317 myrocks.8may18.none.fix | |
| 13531 27419 54388 108043 201504 275132 339867 384492 419175 458256 inno.o5717.ahi | |
| 13205 26500 53066 105045 197882 268497 335168 375458 415986 452974 inno.o5717.noahi | |
| * inno is 1.5x faster | |
| read-only range=100.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 2630 5029 10022 19428 36391 50915 60094 66849 73336 78742 myrocks.8may18.none | |
| 2768 5362 10526 20292 38074 52743 62553 69905 76556 81737 myrocks.8may18.none.fix | |
| 2745 5355 10483 20364 38280 53206 63054 70385 77000 82204 myrocks.8may18.none.fix | |
| 7183 13714 26721 50581 87973 106369 112160 113519 113830 112007 inno.o5717.ahi | |
| 5199 9638 18389 34895 60423 72737 79219 85836 91523 95770 inno.o5717.noahi | |
| * inno is about 2x faster | |
| read-only.pre range=10000 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 257 513 1021 2022 3953 5645 6532 6997 7515 7648 myrocks.8may18.none | |
| 262 525 1039 2053 4003 5713 6628 7109 7610 7692 myrocks.8may18.none.fix | |
| 446 888 1757 3411 6414 8709 9463 9827 9823 10021 inno.o5717.ahi | |
| 444 884 1750 3405 6429 8706 9393 9847 9893 10029 inno.o5717.noahi | |
| * inno is about 1.5x faster | |
| read-only.pre range=10000.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 60 118 230 436 757 904 924 926 904 897 myrocks.8may18.none | |
| 61 121 234 439 741 861 879 867 859 855 myrocks.8may18.none.fix | |
| 57 115 226 427 764 976 1025 1020 1032 1014 myrocks.8may18.none.fix | |
| 203 349 632 1034 1256 1278 1305 1344 1363 1349 inno.o5717.ahi | |
| 126 196 335 529 673 725 776 836 887 922 inno.o5717.noahi | |
| * inno is up to 2x faster with ahi | |
| read-only range=10000 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 246 492 974 1917 3753 5384 6282 6719 7210 7427 myrocks.8may18.none | |
| 247 497 990 1948 3800 5428 6292 6734 7281 7459 myrocks.8may18.none.fix | |
| 446 890 1759 3421 6453 8768 9475 9794 9800 10041 inno.o5717.ahi | |
| 444 886 1745 3414 6433 8692 9462 9841 9723 9997 inno.o5717.noahi | |
| * inno is 1.5x faster | |
| read-only range=10000.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 37 73 144 273 510 712 833 914 993 1049 myrocks.8may18.none | |
| 40 73 149 283 525 729 850 931 1011 1072 myrocks.8may18.none.fix | |
| 39 74 151 291 539 750 879 963 1047 1109 myrocks.8may18.none.fix | |
| 148 264 488 848 1165 1211 1211 1210 1201 1177 inno.o5717.ahi | |
| 83 141 267 489 732 792 846 910 967 1009 inno.o5717.noahi | |
| * inno is about 2x faster | |
| point-query.pre | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 16666 33320 66745 131357 245791 323432 388040 424585 461965 475616 myrocks.8may18.none | |
| 17667 35022 69663 138044 252609 336098 401946 438387 477299 480343 myrocks.8may18.none.fix | |
| 19759 41072 82147 161547 300961 397935 491818 573952 656151 728192 inno.o5717.ahi | |
| 19205 38459 76796 152427 283796 381087 471311 549279 626940 697008 inno.o5717.noahi | |
| * inno is about 1.2x faster | |
| point-query.pre.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 8823 17735 35213 69401 131275 177997 214846 239004 265717 289014 myrocks.8may18.none | |
| 9129 18141 35973 70748 133307 180611 219145 244333 269607 292486 myrocks.8may18.none.fix | |
| 9183 17907 35980 70893 133666 181660 219528 246867 273006 295663 myrocks.8may18.none.fix | |
| 13344 26930 53308 104082 197289 266435 325653 378653 429586 470398 inno.o5717.ahi | |
| 13268 26438 52484 102277 192944 262346 322403 368685 415875 463679 inno.o5717.noahi | |
| * inno is about 1.5x faster | |
| point-query | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 15407 30672 61413 121558 226826 298663 360379 400940 436960 463764 myrocks.8may18.none | |
| 15640 31245 61914 121204 229293 304396 366085 407104 449245 473380 myrocks.8may18.none.fix | |
| 20113 40534 80569 160017 297898 398759 489062 572700 655976 732735 inno.o5717.ahi | |
| 18829 38202 76793 151915 286407 380032 466897 548362 625104 699168 inno.o5717.noahi | |
| * inno is about 1.3x faster | |
| point-query.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 7938 15552 31151 61674 116815 160304 194449 219185 243750 261330 myrocks.8may18.none | |
| 8432 16588 32786 65304 123339 166192 201701 224113 240021 246542 myrocks.8may18.none.fix | |
| 8320 16214 32326 63705 118276 155961 177214 180634 177562 173618 myrocks.8may18.none.fix | |
| 13535 26925 52638 104252 196843 265982 325839 377728 433196 475139 inno.o5717.ahi | |
| 13225 26236 52303 103141 193423 261923 321812 367576 416440 464686 inno.o5717.noahi | |
| * inno is about 1.5x faster | |
| random-points.pre | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 1088 2238 4473 8820 17379 25422 30890 34780 38210 41284 myrocks.8may18.none | |
| 1150 2317 4602 9117 17888 26057 31527 35577 39195 41226 myrocks.8may18.none.fix | |
| 2695 5055 9662 18202 30160 32612 32838 33858 34521 31968 inno.o5717.ahi | |
| 1523 2845 5521 10607 17370 18602 19951 21525 23088 24472 inno.o5717.noahi | |
| * inno is up to 2x faster | |
| random-points.pre.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 448 822 1598 2941 4641 5190 5372 5372 5356 5345 myrocks.8may18.none | |
| 484 942 1875 3659 6998 10015 11718 12841 13772 14569 myrocks.8may18.none.fix | |
| 477 922 1820 3589 6903 9904 11679 12857 13947 14796 myrocks.8may18.none.fix | |
| 1098 2496 4934 9717 17890 23364 25784 27016 24958 27600 inno.o5717.ahi | |
| 865 1593 3070 5881 10557 13569 15312 16746 18000 18928 inno.o5717.noahi | |
| * inno is 2x faster | |
| * MyRocks fix for iterators helps | |
| random-points | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 818 1575 3115 6025 11280 15755 18707 20993 23109 24540 myrocks.8may18.none | |
| 774 1485 2916 5649 10640 14821 17718 19907 21927 23379 myrocks.8may18.none.fix | |
| 2686 5093 9752 18450 30519 32396 32696 32616 32598 33365 inno.o5717.ahi | |
| 1515 2843 5520 10604 17432 18672 19902 21528 23179 24397 inno.o5717.noahi | |
| * inno is more than 2x faster | |
| random-points.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 316 602 1180 2274 4223 5761 6557 6951 7162 7216 myrocks.8may18.none | |
| 343 661 1298 2518 4759 6751 8060 9031 9900 10626 myrocks.8may18.none.fix | |
| 317 614 1205 2349 4463 6374 7577 8464 9399 10037 myrocks.8may18.none.fix | |
| 1272 2441 4805 9403 17210 22249 24426 25454 22492 25757 inno.o5717.ahi | |
| 842 1545 3011 5805 10687 14124 15983 17490 18812 19868 inno.o5717.noahi | |
| * inno is more than 2x faster | |
| hot-points | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 1359 2409 4278 6786 8183 8591 8643 8633 8623 8659 myrocks.8may18.none | |
| 1439 2585 4588 7298 8726 9067 9036 8993 8943 8920 myrocks.8may18.none.fix | |
| 4370 8146 13898 24424 34290 36817 39137 42216 45524 50429 inno.o5717.ahi | |
| 2515 4280 7126 11528 14655 15708 16994 18285 19336 20317 inno.o5717.noahi | |
| * inno is more than 2x faster | |
| hot-points.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 534 992 1881 3517 5712 6534 6731 6815 6887 7027 myrocks.8may18.none | |
| 690 1289 2569 4960 9348 12645 13935 14412 14779 15269 myrocks.8may18.none.fix | |
| 655 1254 2449 4813 9133 12706 14303 15058 15863 16416 myrocks.8may18.none.fix | |
| 2513 4285 6917 10009 10549 10989 11030 11127 11188 11782 inno.o5717.ahi | |
| 1446 2266 4120 7084 10478 11193 12217 12627 12926 12865 inno.o5717.noahi | |
| * inno is more than 2x faster | |
| insert | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 9537 17105 32731 44936 54826 57411 58395 57217 57380 59293 myrocks.8may18.none | |
| 9623 17898 33254 45665 55606 58515 59347 58555 58433 60457 myrocks.8may18.none.fix | |
| 10588 19394 35820 58715 77565 67204 62114 59212 57660 55673 inno.o5717.ahi | |
| 11014 19981 37803 61355 81446 70544 65336 62413 60246 57906 inno.o5717.noahi | |
| * inno is faster at mid, high concurrency | |
| insert.pk0 | |
| 1 2 4 8 16 24 32 40 48 64 | |
| 9047 16768 31704 42807 51150 53108 53659 53078 53847 55141 myrocks.8may18.none | |
| 9224 17049 32131 43131 51201 53967 54244 53500 54132 55789 myrocks.8may18.none.fix | |
| 9263 16769 31774 43061 51092 54207 54384 53967 54030 55845 myrocks.8may18.none.fix | |
| 10284 18255 34447 56741 74988 66544 59611 56737 54787 51990 inno.o5717.ahi | |
| 10405 18595 35757 59665 79229 70436 63146 60036 58199 55807 inno.o5717.noahi | |
| * inno is faster | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment