Last active
September 19, 2017 17:41
-
-
Save mdcallag/e100bf977f5a0d279fc0d9ec08ae8eae 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
Notes: | |
* maxid1=1b | |
* 4 load clients for link table, loaders=4 | |
* 16 transaction clients,requestors=16 | |
* server has 48 HW-threads, 50g RAM, fast SSD | |
* transactions run for 12 hours, metrics from last hour are below | |
* I did not adjust wKB/i and wMB/s for MyRocks where it can overstate bytes written by up to 2X courtesy of counting bytes trimmed as bytes written | |
--- load | |
ips r/i rKB/i wKB/i Mcpu/i size rss rMB/s wMB/s cpu engine | |
- old config | |
177944 0 0 1.45 70 693 3.5 0.6 258.1 12.5 myrocks.none | |
183006 0 0.01 1.80 76 334 3.5 1.2 328.7 14.0 myrocks.zstd | |
167557 0 0 0.76 64 12xx 42.7 0 127.3 10.7 inno5635 | |
174434 0 0 0.76 69 12xx 40.0 0 133.0 12.1 inno5717 | |
147525 0 0 0.77 82 12xx 39.5 0 113.8 12.1 inno802 | |
38903 0 0 1.28 223 939 11.6 0 49.6 8.7 toku5717.none | |
39672 0 0 0.89 230 353 11.9 0 35.3 11.9 toku5717.zlib | |
ips r/i rKB/i wKB/i Mcpu/i size rss rMB/s wMB/s cpu engine | |
- new config | |
142812 0 0 2.03 79 948 7.5 0.3 290.3 11.3 myrocks.none | |
144232 0 0.01 2.55 87 439 5.0 1.9 367.7 12.6 myrocks.zstd | |
132297 0 0 1.04 75 15xx 42.7 0 136.6 9.9 inno5635 | |
138218 0 0 1.04 81 15xx 39.4 0.1 144.0 11.2 inno5717 | |
122495 0 0 1.05 96 15xx 39.5 0.1 128.8 11.8 inno802 | |
36737 0 0 1.68 246 12xx 11.1 0.1 61.6 9.0 toku5717.none | |
37032 0 0 1.18 257 442 11.6 0.1 43.8 9.5 toku5717.zlib | |
--- transactions @ 12h, mysql | |
tps r/t rKB/t wLB/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine | |
- old config | |
31007 1.16 22.16 1.84 793 746 11.5 0.7 0.6 1 0.9 36087 687.3 56.9 24.6 myrocks.none | |
31486 1.03 11.22 1.99 894 361 11.5 0.8 0.7 1 0.8 32288 353.3 62.6 28.1 myrocks.zstd | |
20171 1.18 18.84 20.94 900 13xx 43.2 3 2 7 3 23752 380.0 422.4 18.2 inno5635 | |
29269 1.15 18.47 20.47 795 14xx 40.0 2 2 4 2 33789 540.6 599.1 23.3 inno5717 | |
27970 1.16 18.51 21.14 810 14xx 40.1 3 2 4 2 32354 517.7 591.3 22.7 inno802 | |
8449 2.12 78.35 6.26 3368 989 13.3 5 4 10 9 17915 662.0 52.9 28.5 toku5717.none | |
9588 1.18 14.90 3.82 3770 378 12.4 5 4 7 3 11266 142.9 36.6 36.1 toku5717.zlib | |
- new config | |
tps r/t rKB/t wKB/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine | |
34701 1.16 22.41 1.27 659 997 11.7 0.7 0.5 1 0.9 40070 777.7 44.2 22.9 myrocks.none | |
34622 1.08 13.12 1.27 758 467 11.5 0.7 0.5 1 0.9 37379 454.4 44.1 26.2 myrocks.zstd | |
25775 1.16 18.50 12.05 672 16xx 43.2 3 2 6 4 29803 476.8 310.5 17.3 inno5635 | |
34539 1.15 18.39 11.91 609 17xx 40.0 2 2 3 2 39688 635.0 411.4 21.0 inno5717 | |
33578 1.14 18.23 11.97 641 17xx 40.1 2 2 3 2 38255 612.1 401.9 21.5 inno802 | |
8982 3.07 188.97 5.64 2685 12xx 14.0 4 3 13 12 27610 1697.3 50.7 24.1 toku5717.none | |
12448 1.20 17.42 2.84 2644 466 13.3 3 2 6 3 14885 216.9 35.4 32.9 toku5717.zlib | |
legend: | |
* ips, tps - inserts/second, transactions/second | |
* r/i, r/t - iostat reads per insert and per transaction | |
* rKB/i, rKB/t - iostat KB read per insert and per transaction | |
* wKB/i, wKB/t - iostat KB written per insert and per transaction | |
* Mcpu/i, Mcpu/t - normalized CPU time per insert and per transaction | |
* r/s, rMB/s, wMB/s - iostat r/s, read MB/s and write MB/s, averages | |
* size - database size in GB at test end | |
* rss - mysqld RSS in GB at test end | |
* cpu - average value of vmstat us + sy columns | |
* un, gn, ul, gl - 99th percentile response time in milliseconds for UpdateNode, GetNode, UpdateList and GetLinkedList transactions |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment