Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Last active August 24, 2017 21:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/6c5bc0e1c69b018cf35b7c9046faf9ce to your computer and use it in GitHub Desktop.
Save mdcallag/6c5bc0e1c69b018cf35b7c9046faf9ce to your computer and use it in GitHub Desktop.
sysbench: 8 tables, 100M rows/table
server: 48 HW threads, 50gb RAM, fast SSD
Typical command line:
bash all.sh 8 100000000 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
2.516 1.338 1.395 update-index
1.103 1.210 0.482 update-nonindex
0.907 1.067 0.376 update-nonindex-special
1.325 1.099 0.337 delete-only
0.942 1.149 0.317 read-write.range100
1.064 1.157 1.210 read-write.range10000
0.798 0.968 0.323 read-only.range100
0.980 0.946 1.280 read-only.range10000
0.850 0.917 0.226 point-query
0.933 0.900 0.300 random-points
0.457 0.904 0.608 hot-points
0.890 1.009 0.317 insert-only
8 connections
rocks inno toku engine/test
4.892 2.862 2.304 update-index
1.769 1.681 0.169 update-nonindex
1.382 1.506 0.476 update-nonindex-special
1.409 1.178 0.250 delete-only
0.989 1.082 0.202 read-write.range100
0.893 1.141 1.055 read-write.range10000
0.838 0.895 0.279 read-only.range100
0.870 1.046 1.258 read-only.range10000
0.857 0.840 0.215 point-query
0.911 0.824 0.245 random-points
0.621 1.194 0.819 hot-points
0.828 1.056 0.313 insert-only
48 connections
rocks inno toku engine/test
2.294 2.223 0.817 update-index
2.685 2.726 0.393 update-nonindex
2.172 3.031 0.734 update-nonindex-special
2.830 3.054 0.283 delete-only
2.758 2.706 0.192 read-write.range100
1.113 1.394 0.577 read-write.range10000
0.810 0.996 0.101 read-only.range100
0.893 1.203 0.589 read-only.range10000
0.845 0.954 0.089 point-query
0.864 0.941 0.125 random-points
1.412 3.166 2.055 hot-points
1.111 1.855 0.579 insert-only
update-index
1 2 4 8 16 24 32 40 48 64 threads
2980 5950 11695 22271 36128 41755 45630 48317 49914 52107 myrocks.none
2895 6017 11770 22157 35423 40558 43342 44960 47441 49698 myrocks.zstd
1184 2905 4537 4552 5731 10281 19626 20674 21755 24501 inno5635
1585 4161 7809 13029 22922 33940 40672 45247 48381 50660 inno5717
1487 3905 7412 12613 19535 31382 39917 43824 47095 50059 inno802
1652 3078 5664 10489 18871 24185 25111 20482 17786 12468 toku5717.none
1458 2799 5279 9644 17077 21443 21722 19066 16831 14748 toku5717.zlib
update-nonindex
1 2 4 8 16 24 32 40 48 64 threads
2794 5758 11159 21465 37273 44372 49098 53608 56406 60086 myrocks.none
2887 5903 11521 22295 36934 43448 46953 51566 54128 56948 myrocks.zstd
2532 5251 9433 12132 16863 19981 22660 22457 21003 21265 inno5635
3065 6089 11430 20398 33494 42859 50052 54715 57256 60135 inno5717
2939 5809 10846 19379 32170 41121 47925 52973 55712 58792 inno802
1222 2352 4340 7520 12237 13960 11421 9504 8265 7194 toku5717.none
979 2025 3930 7316 12711 13631 13067 12582 12195 12194 toku5717.zlib
update-nonindex-special
1 2 4 8 16 24 32 40 48 64 threads
4767 10406 20524 36738 49013 56235 59534 61958 64033 66232 myrocks.none
4868 10366 20645 37585 50607 56421 59328 61948 63309 65377 myrocks.zstd
5255 10861 18712 26566 24945 23651 23025 22268 29471 32598 inno5635
5608 12172 22470 40015 63199 75943 81950 86625 89340 93067 inno5717
5101 10712 19867 35754 57566 69644 76113 80273 84716 88734 inno802
1980 3884 6892 12647 21506 24661 23344 22390 21660 21431 toku5717.none
1815 3670 6655 12346 20554 23562 23730 22959 23002 23411 toku5717.zlib
delete-only
1 2 4 8 16 24 32 40 48 64 threads
8916 18060 35389 66059 105970 122017 134336 140753 147080 153084 myrocks.none
9187 18431 35928 67099 106998 121917 129430 138954 142844 146605 myrocks.zstd
6726 13838 28173 46871 44921 43688 46798 50462 51967 56035 inno5635
7398 17174 32045 55240 88958 111395 129942 146653 158730 171151 inno5717
7916 16573 30147 51982 85225 107230 124579 137712 150521 163310 inno802
2273 4461 7330 11736 17421 15022 15368 15812 14709 13575 toku5717.none
1587 3356 6553 11809 20491 21187 22395 23858 24676 23256 toku5717.zlib
read-write.range100
1 2 4 8 16 24 32 40 48 64 threads
2507 5569 12105 23771 46678 64707 81191 94501 105156 121689 myrocks.none
2903 6167 12549 25078 49311 68669 83766 95562 103569 115688 myrocks.zstd
2661 5941 12018 24013 43726 58191 62226 45964 38118 31131 inno5635
3058 6494 12988 25988 50230 70433 86727 94166 103164 120120 inno5717
3035 6600 12984 25190 47586 65956 79637 89469 109184 123330 inno802
845 1660 2968 4870 8234 8606 8129 7701 7341 6741 toku5717.none
438 952 1910 3676 7212 9714 11352 11636 10944 9876 toku5717.zlib
read-write.range10000
1 2 4 8 16 24 32 40 48 64 threads
182 322 613 1179 2270 3242 3980 4612 5186 5853 myrocks.none
179 357 699 1351 2580 3617 4208 4784 5194 5471 myrocks.zstd
171 361 696 1319 2462 3432 4096 4414 4658 4801 inno5635
198 396 778 1506 2838 3990 4928 5777 6497 7515 inno5717
217 431 833 1608 3048 4240 5186 5977 6708 7705 inno802
207 407 780 1392 2510 3050 2845 2735 2690 2647 toku5717.none
119 237 473 921 1765 2369 2617 2850 2777 2479 toku5717.zlib
read-only.range100
1 2 4 8 16 24 32 40 48 64 threads
2565 5541 11148 22215 43937 62507 77783 92020 104791 121843 myrocks.none
2880 5998 12183 24310 48443 67862 83120 96217 104747 118233 myrocks.zstd
3214 6592 13271 26498 52532 75089 95134 113479 129366 152179 inno5635
3113 5936 11732 23751 48083 71365 92452 111732 128854 156002 inno5717
3265 6437 12863 25826 51910 75402 96410 115291 131936 158085 inno802
1040 2233 4366 7416 14295 13984 13534 13330 13106 12187 toku5717.none
575 1256 2577 5157 10209 14042 16852 18282 17065 15235 toku5717.zlib
read-only.range10000
1 2 4 8 16 24 32 40 48 64 threads
147 259 491 952 1828 2613 3217 3744 4141 4714 myrocks.none
144 283 558 1081 2085 2907 3430 3876 4143 4453 myrocks.zstd
150 288 560 1093 2110 2989 3676 4222 4633 5126 inno5635
142 284 568 1144 2302 3373 4257 4989 5578 6466 inno5717
160 332 657 1300 2529 3602 4415 5152 5733 6529 inno802
192 377 730 1375 2459 3101 2986 2815 2731 2732 toku5717.none
109 217 432 847 1637 2208 2439 2657 2727 2338 toku5717.zlib
point-query
1 2 4 8 16 24 32 40 48 64 threads
3573 7396 14842 29555 58120 82453 103593 123280 140582 164293 myrocks.none
3844 7784 15600 30912 61774 86620 107402 125339 138653 154557 myrocks.zstd
4202 8688 17468 34461 67667 96105 121766 145532 166228 195942 inno5635
3854 7291 14417 28954 58213 86808 113261 137388 158735 193987 inno5717
4114 8099 16138 32299 64344 92951 118409 142571 163232 196443 inno802
1148 2382 4463 7621 16632 15191 15101 14796 14883 14099 toku5717.none
754 1688 3569 7379 15237 21906 33655 32011 31987 30145 toku5717.zlib
random-points
1 2 4 8 16 24 32 40 48 64 threads
56 114 226 441 838 1195 1518 1805 2064 2493 myrocks.none
60 121 241 483 944 1378 1733 2029 2278 2719 myrocks.zstd
60 122 242 484 939 1352 1732 2076 2387 2932 inno5635
54 100 197 399 821 1241 1619 1954 2248 2795 inno5717
63 123 244 492 968 1393 1782 2115 2448 2995 inno802
18 36 67 119 262 249 256 277 299 321 toku5717.none
14 31 71 170 423 789 704 705 712 670 toku5717.zlib
hot-points
1 2 4 8 16 24 32 40 48 64 threads
1241 2409 4673 8732 14891 17597 19411 20473 21262 21920 myrocks.none
1236 2435 4694 8767 14890 17405 19082 20233 20757 21504 myrocks.zstd
2714 5132 9187 14057 12556 12345 13496 14416 15054 15248 inno5635
2455 4765 9095 16787 29048 37141 41789 45262 47669 47795 inno5717
2347 4562 8795 16471 28775 37047 41136 44458 46842 46772 inno802
1651 3209 6178 11520 20661 26201 27807 29623 30936 31925 toku5717.none
1664 3251 6162 11512 20681 25847 27684 29714 31162 31698 toku5717.zlib
insert-only
1 2 4 8 16 24 32 40 48 64 threads
8744 16917 32067 45420 54409 58826 61974 62707 63635 65554 myrocks.none
8900 16755 32352 45558 55564 59093 61552 62237 63445 65552 myrocks.zstd
9823 21243 37975 54848 59540 59138 58129 57749 57245 56337 inno5635
9918 19302 35537 57952 82141 92443 100129 103926 106198 109440 inno5717
8488 16309 30337 50406 74811 84802 92131 97049 101047 103646 inno802
3123 5900 9316 17218 30101 37034 39029 35600 33188 29667 toku5717.none
3106 5960 9324 17227 29218 37406 37529 35745 32882 31560 toku5717.zlib
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment