Last active
January 24, 2017 16:44
-
-
Save mdcallag/68052cdd36fe122354bc23ec337fb986 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
| Results from sysbench to show the impact from having non-empty memtable and level 0 during read-only tests. | |
| I get between 5% and 20% more QPS after flushing the memtable and L0. | |
| Tests are run via https://github.com/mdcallag/mytools/blob/master/bench/sysbench.lua/all.sh and the test sequence | |
| is load, update-only, read-write, read-only range scans, point queries, insert only. For the results with "flush" in the | |
| engine name I flushed the memtable and L0 prior to the read-only tests. | |
| The test server has 48 cores, enough RAM to cache the database and fast NVMe flash storage. The tests are run for | |
| 1 to 128 concurrent clients. | |
| --- 8 tables, 1M rows/table, database cached | |
| QPS, read-write, oltp-range=size=100 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 4587 10262 20985 53920 98612 128791 152316 165875 166799 172084 176416 176557 177173 rx.nov21.def10.none.100g | |
| 4722 10354 21915 54488 100001 128811 151581 164730 165523 172639 175777 177472 177150 rx.nov21.def10.none.100g.flush | |
| - | |
| QPS, read-only, oltp-range=size=10 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 5784 12579 33673 76146 131102 169322 202151 216496 220041 227069 241297 242754 246451 rx.nov21.def10.none.100g | |
| 6146 13419 36593 83823 144987 182339 214252 231226 234156 242033 254040 260621 261757 rx.nov21.def10.none.100g.flush | |
| QPS, read-only, oltp-range=size=100 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 4532 9503 20016 51046 95245 123686 146672 160520 163058 176585 183462 185185 183944 rx.nov21.def10.none.100g | |
| 5099 10775 23154 60817 108263 141374 166445 182428 184634 197415 209195 211512 210055 rx.nov21.def10.none.100g.flush | |
| QPS, read-only, oltp-range=size=1000 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 1458 2910 5857 11917 24718 34558 38683 42516 45417 45445 45072 44657 44483 rx.nov21.def10.none.100g | |
| 1802 3650 7399 15178 31054 43409 49621 54258 57930 58280 57641 58118 58043 rx.nov21.def10.none.100g.flush | |
| QPS, read-only, oltp-range=size=10000 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 199 397 778 1524 2994 4121 4646 5060 5304 5302 5233 5228 5192 rx.nov21.def10.none.100g | |
| 232 462 912 1797 3530 4784 5395 5961 6219 6193 6152 6033 6065 rx.nov21.def10.none.100g.flush | |
| --- 8 tables, 10M rows/table, 2G RocksDB block cache, all data in OS page cache, some data in RocksDB block cache | |
| QPS, read-write, oltp-range=size=100 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 4835 9838 20752 52575 94990 125821 150876 163236 162864 169262 173241 175870 174468 rx.nov21.def10.none.2g | |
| 4684 9881 20967 52541 96294 126636 149298 160877 161378 168064 171177 173867 173960 rx.nov21.def10.none.2g.flush | |
| - | |
| 6111 11591 24750 49951 89837 113607 133565 144713 149414 153290 151874 150312 149168 rx.nov21.def10.none.2g | |
| 5911 10633 24742 50071 90429 114893 134498 143458 149640 153599 153472 151913 149517 rx.nov21.def10.none.flushmt | |
| QPS, read-only, oltp-range=size=10 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 5610 12154 29343 72382 128571 161373 192342 208474 211321 221249 231269 236951 238421 rx.nov21.def10.none.2g | |
| 5856 13007 28795 79477 133250 171693 205472 219334 223443 229444 239274 244870 249438 rx.nov21.def10.none.2g.flush | |
| - | |
| 5617 12173 28031 72490 125096 162223 192227 208969 211957 227628 236036 240427 238283 rx.nov21.def10.none.2g | |
| 5564 12195 26557 75503 131222 165215 195277 206187 214315 233147 243040 244562 242355 rx.nov21.def10.none.flushmt | |
| QPS, read-only, oltp-range=size=100 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 4510 9435 19890 50093 92835 121913 145666 159461 159891 177378 184043 185102 183144 rx.nov21.def10.none.2g | |
| 4877 10266 22059 57760 102787 132140 156877 169098 172656 184135 194724 198588 197981 rx.nov21.def10.none.2g.flush | |
| - | |
| 4531 9508 20241 51052 94364 122953 144622 155711 165890 180887 184756 185965 183551 rx.nov21.def10.none.2g | |
| 4533 9509 19939 51980 95597 124293 147958 160643 170919 184830 188196 188271 186519 rx.nov21.def10.none.2g.flushmt | |
| QPS, read-only, oltp-range=size=1000 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 1550 3058 6157 12561 25868 36464 41182 45563 49026 49028 48953 48239 48283 rx.nov21.def10.none.2g | |
| 1705 3433 6967 14293 29253 40894 46307 50138 53717 54271 54299 54031 54045 rx.nov21.def10.none.2g.flush | |
| - | |
| 1496 3019 6120 12479 25651 36181 41036 45262 48671 47765 47832 48157 48003 rx.nov21.def10.none.2g | |
| 1531 3085 6231 12725 26316 37413 42328 46402 49725 48873 49624 49337 49254 rx.nov21.def10.none.2g.flushmt | |
| QPS, read-only, oltp-range=size=10000 | |
| 1 2 4 8 16 24 32 40 48 64 80 96 128 concurrency/engine | |
| 190 380 751 1488 2928 4037 4601 4994 5281 5270 5222 5198 5105 rx.nov21.def10.none.2g | |
| 215 428 849 1683 3313 4524 5116 5582 5797 5779 5740 5638 5642 rx.nov21.def10.none.2g.flush | |
| - | |
| 186 371 741 1464 2894 3979 4527 4923 5214 5203 5153 5135 5085 rx.nov21.def10.none.2g | |
| 191 383 759 1505 2981 4143 4654 5119 5379 5343 5269 5246 5221 rx.nov21.def10.none.2g.flushmt |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment