Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
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