Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
8 tables, 1M rows/table, sysbench
Typical command line:
bash all.sh 8 1000000 180 300 180 innodb 1 0 /data/mysql/orig5717/bin/mysql none /data/mysql/sysbench.new
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.476 0.959 0.201 update-inlist
0.828 0.923 0.278 update-one
1.146 1.090 0.458 update-index
0.648 0.901 0.243 update-nonindex
0.740 0.898 0.236 update-nonindex-special
0.836 0.917 0.347 delete-only
0.711 1.041 0.586 read-write.range100
0.809 1.671 1.038 read-write.range10000
0.664 1.096 0.753 read-only.range100
0.801 1.657 1.263 read-only.range10000
0.641 0.905 0.735 point-query
0.442 0.923 0.753 random-points
0.480 0.900 0.694 hot-points
0.742 0.855 0.259 insert-only
----- ----- -----
0.711 1.052 0.560 average of the above
8 connections
rocks inno toku
0.966 1.611 0.308 update-inlist
0.871 1.029 0.276 update-one
1.201 1.467 0.417 update-index
0.858 1.093 0.315 update-nonindex
0.898 1.090 0.314 update-nonindex-special
0.949 1.058 0.338 delete-only
0.710 1.039 0.534 read-write.range100
0.811 1.621 1.128 read-write.range10000
0.675 1.098 0.851 read-only.range100
0.810 1.639 1.263 read-only.range10000
0.648 0.910 0.746 point-query
0.541 1.097 0.931 random-points
0.754 1.317 1.037 hot-points
0.776 1.028 0.286 insert-only
----- ----- -----
0.819 1.221 0.625 average of the above
48 connections
rocks inno toku
1.649 3.127 0.922 update-inlist
0.760 1.193 0.372 update-one
1.316 2.236 0.700 update-index
1.360 1.982 0.937 update-nonindex
1.374 1.965 0.995 update-nonindex-special
1.126 1.845 0.566 delete-only
0.804 1.129 0.507 read-write.range100
0.838 1.310 0.956 read-write.range10000
0.711 1.098 0.866 read-only.range100
0.823 1.305 1.034 read-only.range10000
0.932 1.347 1.084 point-query
1.417 2.920 2.248 random-points
1.840 3.226 2.350 hot-points
1.096 1.927 0.567 insert-only
----- ----- -----
1.146 1.901 1.007 average of the above
update-inlist
1 2 4 8 16 24 32 40 48 64 threads
2338 4342 8463 15642 21325 21786 22294 22221 22080 22168 myrocks
4911 8999 13088 16188 16313 15125 14369 13824 13382 12693 inno5635
4713 8895 16519 26089 37170 38962 40004 41582 41858 41183 inno5717
3496 6537 12489 22987 34100 39368 39476 40525 41204 40475 inno802
988 1579 2783 4990 8997 10830 11188 11909 12344 12684 toku5717
update-one
1 2 4 8 16 24 32 40 48 64 threads
8672 16455 29709 43342 45244 43716 42340 40999 39902 36858 myrocks
10472 19450 34693 49717 52903 52726 52874 52718 52468 51669 inno5635
9670 18065 33074 51181 61612 63113 63091 62583 62626 61626 inno5717
8041 15256 27893 44659 56938 58724 59402 59580 59568 58930 inno802
2912 5380 8156 13736 18831 19840 19935 19754 19551 19005 toku5717
update-index
1 2 4 8 16 24 32 40 48 64 threads
6710 12709 24678 38321 47686 53181 55196 55727 56032 57565 myrocks
5852 12132 21290 31882 37974 41594 42381 42222 42547 44643 inno5635
6384 13627 27205 46794 73266 87185 93899 95239 95172 96117 inno5717
5479 11674 23273 41721 65436 81278 89090 90743 91298 92846 inno802
2681 4431 7689 13315 22202 28737 31313 30867 29821 28220 toku5717
update-nonindex
1 2 4 8 16 24 32 40 48 64 threads
6724 12970 25342 43528 56006 61218 65802 67631 68055 70041 myrocks
10364 19139 34995 50682 54394 53828 52117 50477 50023 50361 inno5635
9338 17788 33564 55419 79057 92364 96823 98637 99181 101286 inno5717
7799 15071 28419 48628 73301 86145 93374 95995 97353 98866 inno802
2525 4862 8128 15966 27075 36183 40596 43926 46911 46177 toku5717
update-nonindex-special
1 2 4 8 16 24 32 40 48 64 threads
7724 14830 28218 45834 57157 63016 67768 69225 69806 71705 myrocks
10429 19250 35213 50998 54703 54247 52970 51175 50789 51177 inno5635
9374 18006 33837 55621 79343 92622 97113 98954 99840 101178 inno5717
7797 15131 28723 48803 73653 86206 93556 96040 97257 99034 inno802
2462 4765 8153 16015 28846 37847 43444 47260 50566 48494 toku5717
delete-only
1 2 4 8 16 24 32 40 48 64 threads
15890 30955 60276 113548 147051 155725 163545 166639 165679 164195 myrocks
19003 38426 71276 119584 154642 157329 154021 150183 147098 140342 inno5635
17429 35566 69012 126597 196799 238134 261676 268174 271487 275581 inno5717
14742 30440 59366 110327 177119 219247 243332 246728 250510 255379 inno802
6600 11721 21946 40527 67908 83698 85788 84984 83260 79742 toku5717
read-write --range-size=100
1 2 4 8 16 24 32 40 48 64 threads
8125 16076 32396 63869 117134 154769 179025 193793 200629 197306 myrocks
11421 23095 46019 89853 157319 204745 232398 245375 249434 248442 inno5635
11891 23990 48424 93409 164986 215558 244507 265224 281641 288103 inno5717
10645 21988 43669 84440 149353 203156 230759 254393 266476 265854 inno802
6703 13756 25317 48020 86744 107981 120052 126417 126704 129512 toku5717
read-write --range-size=10000
1 2 4 8 16 24 32 40 48 64 threads
293 588 1160 2296 4600 6370 6974 7612 8114 7970 myrocks
362 725 1431 2828 5436 7463 8366 9245 9681 9522 inno5635
605 1198 2354 4586 8617 11126 11806 12504 12686 12539 inno5717
571 1143 2244 4396 8193 10664 11265 11982 12127 12056 inno802
376 849 1637 3190 6222 8183 8700 9132 9260 9143 toku5717
read-only --range-size=100
1 2 4 8 16 24 32 40 48 64 threads
7792 15693 31447 62540 115943 160299 181879 197784 216450 223130 myrocks
11728 23555 46874 92553 166592 226378 259233 287783 304232 311822 inno5635
12864 25781 51588 101684 180752 243302 275822 307160 334086 335159 inno5717
11883 24057 47818 93912 165425 223105 253942 283014 311435 315116 inno802
8835 19932 40335 78842 144159 193617 217573 240263 263674 266401 toku5717
read-only --range-size=10000
1 2 4 8 16 24 32 40 48 64 threads
234 470 930 1848 3600 4988 5559 6049 6464 6401 myrocks
292 583 1147 2280 4403 6057 6808 7486 7845 7612 inno5635
484 980 1919 3739 6980 9100 9612 10133 10239 10132 inno5717
465 930 1832 3593 6688 8714 9139 9723 9899 9773 inno802
369 744 1476 2880 5476 7212 7541 8026 8115 7982 toku5717
point-query
1 2 4 8 16 24 32 40 48 64 threads
12647 25486 50522 100385 176211 225193 255659 278927 305807 330286 myrocks
19720 40141 79015 154722 255860 309502 348191 352490 328098 253324 inno5635
17859 35689 71519 140854 241915 312706 357463 400908 442165 450368 inno5717
14973 30434 60906 120423 211355 277608 319744 362890 403084 412184 inno802
14513 28785 57776 115468 203347 258892 297100 328561 355790 371174 toku5717
random-points
1 2 4 8 16 24 32 40 48 64 threads
897 1801 3544 6871 12965 17283 19788 21799 23189 22907 myrocks
2028 3899 7370 12693 12545 12467 13903 15055 16358 16268 inno5635
1872 3641 7193 13925 26301 35570 40525 44371 47773 47763 inno5717
1767 3488 6830 13317 25431 34618 39222 42966 46517 46369 inno802
1529 3018 6038 11824 22817 30479 32886 35494 36786 38033 toku5717
hot-points
1 2 4 8 16 24 32 40 48 64 threads
1376 2725 5370 10256 18895 24168 26153 27898 28762 29809 myrocks
2863 5324 9592 13588 11683 11888 13248 14410 15630 15538 inno5635
2579 4987 9584 17899 31808 41077 44830 47331 50430 50136 inno5717
2450 4750 9102 16982 30547 39607 43423 46586 49634 49566 inno802
1989 3876 7479 14091 25153 31403 33428 35183 36737 38039 toku5717
insert-only
1 2 4 8 16 24 32 40 48 64 threads
9144 17011 32631 46466 56765 62769 65000 64747 65777 67564 myrocks
12317 22901 40808 59811 63745 62366 61896 60946 59971 58607 inno5635
10539 19592 36899 61522 88947 100587 108602 113350 115598 118252 inno5717
8956 16873 31906 54951 82342 94692 102549 107226 109730 113442 inno802
3199 5944 9424 17164 30488 37316 39505 36039 34043 29659 toku5717
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment