Last active
August 31, 2017 16:04
-
-
Save mdcallag/87995eae29778a876582a0b745c1c8b6 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
| 1 table, 8M rows/table, 48 HW thread UDB server, new sysbench | |
| Typical command line: | |
| bash all.sh 1 8000000 180 300 180 rocksdb 1 0 /data/mysql/myrocks/bin/mysql none /data/mysql/sysbench10 | |
| binaries: | |
| * myrocks - MyRocks built on August 15, 2017 with githash 0d76ae and not using compression | |
| * inno5635 - InnoDB from upstream 5.6.35 | |
| * inno5717 - InnoDB from upstream 5.7.17 | |
| * inno802 - InnoDB from upstream 8.0.2 | |
| * toku5717 - TokuDB from Percona Server 5.7.17, not using compression | |
| configuration: | |
| * server has 256gb of RAM for database and OS page cache. MyRocks and TokuDB use 180gb block cache | |
| and buffered IO. InnoDB uses 180gb block cache and O_DIRECT. | |
| * server has 48 HW-threads and fast SSD | |
| * binlog is enabled, sync on commit is disabled for the binlog and database log | |
| * SSL is disabled | |
| * sysbench and mysqld share the server | |
| QPS ratio: | |
| * rocks = myrocks / inno5635 | |
| * inno = inno5717 / inno5635 | |
| * toku = toku5717 / inno5635 | |
| 1 connection | |
| rocks inno toku | |
| 0.460 0.946 0.195 update-inlist | |
| 0.862 0.906 0.278 update-one | |
| 1.496 1.239 0.569 update-index | |
| 0.674 0.906 0.248 update-nonindex | |
| 0.756 0.921 0.240 update-nonindex-special | |
| 0.793 0.866 0.319 delete-only | |
| 0.701 1.027 0.612 read-write.range100 | |
| 0.812 1.657 1.033 read-write.range10000 | |
| 0.701 1.089 0.737 read-only.range100 | |
| 0.804 1.676 1.281 read-only.range10000 | |
| 0.675 0.904 0.731 point-query | |
| 0.508 0.923 0.732 random-points | |
| 0.554 0.904 0.633 hot-points | |
| 0.760 0.857 0.257 insert-only | |
| ----- ----- ----- | |
| 0.754 1.059 0.562 average | |
| 8 connections | |
| rocks inno toku | |
| 0.968 1.587 0.293 update-inlist | |
| 1.014 0.843 0.190 update-one | |
| 1.837 2.183 0.608 update-index | |
| 0.879 1.090 0.307 update-nonindex | |
| 0.928 1.094 0.312 update-nonindex-special | |
| 0.968 1.068 0.340 delete-only | |
| 0.722 1.045 0.560 read-write.range100 | |
| 0.814 1.626 1.108 read-write.range10000 | |
| 0.714 1.126 0.825 read-only.range100 | |
| 0.811 1.639 1.255 read-only.range10000 | |
| 0.690 0.914 0.727 point-query | |
| 0.718 1.156 0.840 random-points | |
| 0.966 1.354 0.832 hot-points | |
| 0.859 1.104 0.310 insert-only | |
| ----- ----- ----- | |
| 0.921 1.274 0.608 average | |
| 48 connections | |
| rocks inno toku | |
| 1.679 3.087 0.788 update-inlist | |
| 0.982 0.979 0.231 update-one | |
| 1.222 1.986 0.606 update-index | |
| 1.379 1.947 0.886 update-nonindex | |
| 1.387 1.936 0.854 update-nonindex-special | |
| 1.189 1.876 0.578 delete-only | |
| 0.826 1.148 0.514 read-write.range100 | |
| 0.840 1.316 0.953 read-write.range10000 | |
| 0.743 1.112 0.740 read-only.range100 | |
| 0.850 1.342 1.034 read-only.range10000 | |
| 0.941 1.368 1.066 point-query | |
| 2.042 1.445 0.686 random-points | |
| 0.793 1.507 0.711 hot-points | |
| 1.820 1.605 0.692 insert-only | |
| ----- ----- ----- | |
| 1.192 1.618 0.739 average | |
| update-inlist | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 2301 4316 8358 15671 21209 21729 22279 22216 22237 22097 myrocks | |
| 4994 9152 13083 16177 16132 15039 14253 13714 13238 12517 inno5635 | |
| 4728 8605 16114 25679 36466 38098 39245 40788 40875 39911 inno5717 | |
| 3414 6409 12274 22583 33672 39013 39069 40144 40745 39930 inno802 | |
| 974 1521 2666 4751 8367 10014 10337 10506 10435 10072 toku5717 | |
| update-one | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 9072 17379 17746 17348 16539 15223 14353 13589 13055 11830 myrocks | |
| 10521 19529 20725 17092 17883 17080 16143 14975 13288 10476 inno5635 | |
| 9535 17838 17398 14411 14585 14301 14508 13995 13019 11550 inno5717 | |
| 8117 15054 14550 11927 11329 11920 11938 11721 11383 10006 inno802 | |
| 2926 3668 3364 3254 3231 3168 3058 3080 3077 2942 toku5717 | |
| update-index | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 6919 13225 25441 39023 48492 53824 56051 56375 56696 58210 myrocks | |
| 4625 9404 15150 21240 49399 50499 48911 47047 46362 45855 inno5635 | |
| 5731 12677 24569 46370 73877 85296 90958 91724 92084 93195 inno5717 | |
| 4998 10893 22988 45835 70772 81621 89703 92211 92335 92849 inno802 | |
| 2634 4376 7603 12916 21907 28538 29807 28685 28138 26975 toku5717 | |
| update-nonindex | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 6942 13332 25892 44580 57339 62224 66434 68525 69002 70918 myrocks | |
| 10295 19074 35146 50680 54151 53172 51637 50301 50034 50395 inno5635 | |
| 9332 17831 33751 55278 79098 91346 95277 96779 97425 98560 inno5717 | |
| 7783 14984 28658 48876 72932 85647 92576 94983 95971 97096 inno802 | |
| 2560 4764 8058 15585 26902 35250 40418 43110 44375 43063 toku5717 | |
| update-nonindex-special | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 7796 15290 28950 47061 58576 64917 69140 70067 70380 72479 myrocks | |
| 10300 19317 35459 50705 54513 53371 52312 50789 50713 51159 inno5635 | |
| 9493 17989 34068 55514 79435 91740 95534 97457 98201 99021 inno5717 | |
| 7866 15209 29032 48725 73719 86003 93186 95190 96466 97208 inno802 | |
| 2480 4738 8093 15843 28074 35181 39645 41899 43317 44323 toku5717 | |
| delete-only | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 16217 31396 60801 113868 148095 156579 165246 167627 167462 165759 myrocks | |
| 20430 38678 71144 117602 149154 149633 146991 143858 140740 134279 inno5635 | |
| 17695 35887 68924 125692 195543 236211 258180 262397 264089 268175 inno5717 | |
| 15237 30644 59075 110186 177388 220682 246775 252614 253873 255875 inno802 | |
| 6529 11479 21660 40049 67774 82441 84497 83337 81458 78304 toku5717 | |
| read-write --range-size=100 | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 8164 16185 32877 64901 119607 156716 180973 196766 203604 200854 myrocks | |
| 11633 23201 45905 89788 157206 203137 232611 240698 246432 245290 inno5635 | |
| 11952 24458 48559 93902 166097 216678 245451 268205 283114 291229 inno5717 | |
| 10809 21748 43438 84523 151361 203443 232233 253692 267743 268259 inno802 | |
| 7127 14164 26415 50349 90465 110264 120048 127106 126885 128553 toku5717 | |
| read-write --range-size=10000 | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 294 591 1165 2290 4417 6125 6999 7576 8042 8151 myrocks | |
| 362 722 1426 2813 5382 7426 8352 9164 9570 9504 inno5635 | |
| 600 1203 2352 4574 8568 11051 11792 12454 12598 12527 inno5717 | |
| 567 1126 2228 4365 8116 10568 11187 11879 12099 11973 inno802 | |
| 374 828 1583 3117 6134 8074 8498 8968 9125 8982 toku5717 | |
| read-only --range-size=100 | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 8164 16343 32765 64972 119583 165633 186866 205540 224231 232994 myrocks | |
| 11646 23422 46576 90884 166003 225117 258293 288470 301666 312809 inno5635 | |
| 12684 26071 52051 102339 180934 241747 275557 307649 335586 339477 inno5717 | |
| 11875 23929 47728 94463 165607 224161 254379 283600 311616 313518 inno802 | |
| 8594 19423 38855 75051 136750 176060 196662 212768 223518 225149 toku5717 | |
| read-only --range-size=10000 | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 234 465 925 1841 3595 4975 5598 6104 6510 6474 myrocks | |
| 291 580 1147 2268 4389 6018 6765 7442 7655 7722 inno5635 | |
| 488 974 1903 3719 6957 9068 9556 10106 10275 10171 inno5717 | |
| 462 922 1808 3565 6599 8651 9125 9615 9854 9701 inno802 | |
| 373 742 1461 2847 5365 7022 7368 7829 7919 7828 toku5717 | |
| point-query | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 13160 26945 53576 106401 183106 226210 261912 281902 301829 328243 myrocks | |
| 19487 38963 78170 153995 253241 306316 343593 343467 320470 261033 inno5635 | |
| 17621 35480 71477 140806 242233 311852 357012 400103 438582 448325 inno5717 | |
| 14999 30279 60492 121208 213311 276143 319159 361068 400539 408945 inno802 | |
| 14249 27996 56911 112088 198873 255699 289477 319660 341762 355781 toku5717 | |
| random-points | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 972 1927 3807 7411 14037 18839 21424 23500 25003 25104 myrocks | |
| 1910 3562 6542 10313 10659 10570 11156 11738 12239 12260 inno5635 | |
| 1764 3357 6451 11931 15866 15900 16731 17322 17690 17666 inno5717 | |
| 1680 3167 6108 10912 14043 13684 14629 15500 16288 16257 inno802 | |
| 1400 2681 5152 8669 9275 9121 8812 8561 8401 8376 toku5717 | |
| hot-points | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 1577 2911 5366 8489 9186 9056 8866 8773 8691 8714 myrocks | |
| 2845 4681 7022 8787 8800 9209 10245 10616 10947 10954 inno5635 | |
| 2574 4447 7543 11904 12909 12896 14389 15490 16505 16644 inno5717 | |
| 2432 4147 6805 10469 10963 10517 11316 12013 12618 12594 inno802 | |
| 1802 2952 5170 7318 7962 8053 7911 7836 7788 7825 toku5717 | |
| insert-only | |
| 1 2 4 8 16 24 32 40 48 64 concurrency/engine | |
| 9329 17257 33266 47629 58450 64565 67117 67239 67704 69184 myrocks | |
| 12273 22638 40334 55445 48569 43743 41125 38876 37180 34250 inno5635 | |
| 10529 19696 36743 61235 82296 70965 65771 62217 59690 56566 inno5717 | |
| 8827 16471 31359 54274 75361 70089 65973 63641 61067 57610 inno802 | |
| 3156 5911 8976 17193 25608 23215 21016 19613 25754 24497 toku5717 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment