Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
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