Created
August 25, 2017 23:12
-
-
Save mdcallag/dc2948c407e1c791f33c5bf5598d7cc8 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
sysbench: 1 tables, 800M rows/table | |
server: 48 HW threads, 50gb RAM, fast SSD | |
Typical command line: | |
bash all.sh 1 800000000 180 300 180 innodb 1 0 /data/mysql/orig5717/bin/mysql none /data/mysql/sysbench.new | |
binaries: | |
* myrocks.none - MyRocks built on August 15, 2017 with githash 0d76ae and not using compression | |
* myrocks.zstd - MyRocks built on August 15, 2017 with githash 0d76ae using zstd compression for | |
the max level of the LSM tree | |
* inno5635 - InnoDB from upstream 5.6.35 | |
* inno5717 - InnoDB from upstream 5.7.17 | |
* inno802 - InnoDB from upstream 8.0.2 | |
* toku5717.none - TokuDB from Percona Server 5.7.17, compression disabled | |
* toku5717.zlib - TokuDB from Percona Server 5.7.17, zlib compression enabled | |
configuration: | |
* server has 50gb of RAM for database and OS page cache. MyRocks and TokuDB use 10gb block cache | |
and buffered IO. InnoDB uses 35gb 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.none / inno5635 | |
* inno = inno5717 / inno5635 | |
* toku = toku5717.none / inno5635 | |
1 connection | |
rocks inno toku engine/test | |
1.765 1.306 0.995 update-index | |
1.049 1.122 0.421 update-nonindex | |
0.842 1.020 0.351 update-nonindex-special | |
4.415 1.821 1.111 delete-only | |
0.988 1.166 0.329 read-write.range100 | |
1.189 1.300 1.339 read-write.range10000 | |
0.910 1.092 0.358 read-only.range100 | |
0.980 0.966 1.246 read-only.range10000 | |
0.862 0.950 0.257 point-query | |
0.949 0.949 0.271 random-points | |
0.515 0.885 0.606 hot-points | |
0.963 0.991 0.324 insert-only | |
8 connections | |
rocks inno toku engine/test | |
5.958 2.644 2.782 update-index | |
1.513 1.434 0.473 update-nonindex | |
1.289 1.422 0.365 update-nonindex-special | |
1.542 0.995 0.275 delete-only | |
1.206 1.306 0.253 read-write.range100 | |
1.002 1.288 1.159 read-write.range10000 | |
1.017 1.083 0.329 read-only.range100 | |
0.871 1.069 1.191 read-only.range10000 | |
0.862 0.855 0.204 point-query | |
0.915 0.859 0.208 random-points | |
0.890 1.194 0.758 hot-points | |
0.951 1.149 0.353 insert-only | |
48 connections | |
rocks inno toku engine/test | |
3.836 2.340 1.492 update-index | |
2.425 2.520 0.312 update-nonindex | |
2.112 2.981 0.557 update-nonindex-special | |
3.028 1.950 0.306 delete-only | |
1.790 1.643 0.122 read-write.range100 | |
1.488 1.883 0.768 read-write.range10000 | |
0.820 1.005 0.093 read-only.range100 | |
0.903 1.219 0.579 read-only.range10000 | |
0.854 0.971 0.079 point-query | |
0.871 0.953 0.096 random-points | |
0.739 1.286 0.698 hot-points | |
1.768 1.579 0.491 insert-only | |
update-index | |
1 2 4 8 16 24 32 40 48 64 threads | |
2849 5936 11790 22581 36273 42133 45734 48407 50707 52596 myrocks.none | |
1614 2752 3537 3790 5253 9103 11093 11985 13216 15648 inno5635 | |
2109 3589 4399 10024 19181 23254 26194 28440 30928 37401 inno5717 | |
1898 3412 6220 14677 25821 31938 35783 40372 45167 48629 inno802 | |
1606 3032 5592 10545 18791 23793 25214 23133 19721 16375 toku5717.none | |
update-nonindex | |
1 2 4 8 16 24 32 40 48 64 threads | |
2820 5729 11414 21628 37227 44550 49949 53992 56748 60554 myrocks.none | |
2686 5328 9551 14293 18186 21600 22341 22562 23396 22571 inno5635 | |
3015 6112 11450 20499 34111 43630 50979 56130 58975 61993 inno5717 | |
2956 5968 11339 20386 34334 42548 48816 54112 57401 61146 inno802 | |
1133 2160 3970 6763 10821 11792 9752 8424 7320 6491 toku5717.none | |
update-nonindex-special | |
1 2 4 8 16 24 32 40 48 64 threads | |
4817 10539 20960 37367 50184 56527 59843 62136 64542 66762 myrocks.none | |
5715 11645 19558 28983 29870 30274 30569 30842 30554 30006 inno5635 | |
5833 12308 22980 41236 65128 77944 83221 88380 91112 93919 inno5717 | |
5313 11404 21928 39504 62138 73645 80583 85112 87574 89357 inno802 | |
2006 3712 6395 10579 14959 17181 17722 17300 17043 17191 toku5717.none | |
delete-only | |
1 2 4 8 16 24 32 40 48 64 threads | |
9007 18282 35351 66151 105962 121986 134974 142790 147883 153538 myrocks.none | |
2040 11637 27617 42881 49902 53515 32762 35781 48829 52380 inno5635 | |
3716 13758 25432 42695 61548 71562 79599 86815 95251 109621 inno5717 | |
8487 16903 31424 55642 92155 115676 132123 143838 153201 163143 inno802 | |
2268 4316 7156 11815 17599 15651 15831 15986 14988 13925 toku5717.none | |
read-write --range-size=100 | |
1 2 4 8 16 24 32 40 48 64 threads | |
2536 5918 12132 23898 46956 65497 82030 94754 105625 123287 myrocks.none | |
2565 5772 10944 19806 32775 43352 54208 60020 59008 44331 inno5635 | |
2991 6513 12930 25870 50034 70707 87169 100446 96971 109883 inno5717 | |
3031 6622 13271 25869 49251 68987 85073 98108 108923 123764 inno802 | |
846 1684 3208 5018 8618 8786 8050 7639 7205 6608 toku5717.none | |
read-write --range-size=10000 | |
1 2 4 8 16 24 32 40 48 64 threads | |
182 323 612 1182 2272 3240 3971 4615 5177 5855 myrocks.none | |
153 312 606 1179 2143 2641 3005 3287 3479 3854 inno5635 | |
199 404 792 1519 2866 4025 4988 5840 6554 7585 inno5717 | |
211 428 831 1609 3046 4252 5232 6003 6754 7745 inno802 | |
205 401 767 1367 2438 3038 2856 2706 2674 2607 toku5717.none | |
read-only --range-size=100 | |
1 2 4 8 16 24 32 40 48 64 threads | |
2613 5588 11320 22490 44237 63227 79062 93594 106021 121732 myrocks.none | |
2869 5380 10389 22102 51273 74955 95121 113288 129199 151525 inno5635 | |
3134 6023 11836 23950 48690 72485 93916 112708 129886 156066 inno5717 | |
3279 6578 13163 26313 52664 75921 96867 114867 132130 157999 inno802 | |
1028 2193 4141 7287 13975 13169 12931 12450 12100 11106 toku5717.none | |
read-only --range-size=10000 | |
1 2 4 8 16 24 32 40 48 64 threads | |
147 259 496 955 1830 2621 3222 3745 4196 4744 myrocks.none | |
150 289 560 1096 2110 2977 3675 4230 4642 5097 inno5635 | |
145 293 584 1172 2343 3431 4306 5044 5661 6514 inno5717 | |
161 331 660 1300 2528 3582 4419 5130 5717 6515 inno802 | |
187 362 709 1306 2324 2833 2972 2739 2690 2621 toku5717.none | |
point-query | |
1 2 4 8 16 24 32 40 48 64 threads | |
3639 7512 15174 29874 58816 83050 104662 123034 140862 164356 myrocks.none | |
4217 8624 17569 34640 67636 95953 121605 143895 164845 192971 inno5635 | |
4007 7507 14658 29630 59752 88660 115233 139202 160214 195446 inno5717 | |
4096 8046 16000 31903 63489 91775 116838 140025 161217 193726 inno802 | |
1085 2292 4258 7096 14585 14131 13507 13314 13078 11891 toku5717.none | |
random-points | |
1 2 4 8 16 24 32 40 48 64 threads | |
56 113 228 444 844 1200 1524 1814 2076 2512 myrocks.none | |
59 118 242 485 936 1350 1728 2071 2382 2923 inno5635 | |
56 104 203 417 852 1280 1653 1990 2272 2825 inno5717 | |
61 121 237 478 943 1361 1738 2068 2391 2930 inno802 | |
16 32 61 101 222 207 209 219 231 240 toku5717.none | |
hot-points | |
1 2 4 8 16 24 32 40 48 64 threads | |
1313 2434 4427 7602 8415 8343 7994 7887 7849 7926 myrocks.none | |
2548 4154 6531 8534 9035 9308 10216 10508 10621 10642 inno5635 | |
2256 3584 6285 10194 11510 11041 12344 13212 13665 13766 inno5717 | |
2133 3482 6035 9313 10913 10934 11745 12432 12789 12851 inno802 | |
1546 2428 4281 6469 7394 7553 7462 7431 7417 7445 toku5717.none | |
insert-only | |
1 2 4 8 16 24 32 40 48 64 threads | |
9132 17423 33150 46507 55622 59936 63366 64627 65605 67180 myrocks.none | |
9482 21066 37280 48853 44006 41008 39242 38027 37087 34866 inno5635 | |
9406 18999 35225 56163 75042 70765 64347 61221 58572 54963 inno5717 | |
8077 14883 26669 41807 53939 51628 56416 56920 53073 43953 inno802 | |
3081 5866 8854 17280 25050 22969 20518 19205 18242 23168 toku5717.none |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment