Created
December 4, 2017 20:23
-
-
Save mdcallag/b63ad8763fbeaa12c6f7d9bbe906a83a 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
- load | |
ips r/i rkb/i wkb/i Mcpu/i size rss rMB/s wMB/s cpu engine | |
43099 0 0 1.28 981 78 0.8 0.2 55.2 42.3 MyRocks.none | |
42588 0 0 1.40 1098 39 0.5 0.1 59.5 46.7 MyRocks.zstd | |
51138 0 0 2.70 626 119 14.0 0 138.1 32.0 Inno5096 | |
50134 0 0 2.43 646 119 13.8 0 121.7 32.4 Inno5172 | |
42327 0 0 2.54 778 119 13.9 0 107.3 32.9 Inno5551 | |
50482 0 0 2.11 686 118 13.9 0 106.4 34.6 Inno5635 | |
44534 0 0 2.12 735 118 13.3 0 94.6 32.7 Inno5717 | |
37804 0 0 2.17 868 118 13.4 0 82.1 32.8 Inno802 | |
legend: | |
* ips - inserts/second | |
* r/i - iostat reads per insert | |
* rkb/i, wkb/i - iostat KB written per insert | |
* Mcpu/i - normalized CPU time per insert | |
* size - database size in GB at test end | |
* rss - mysqld RSS at test end | |
* rMB/s, wMB/s - iostat read and write MB/s, average | |
* cpu - average value of vmstat us + sy columns | |
- 12th hour of transactions | |
tps r/t rkb/t wkb/t Mcpu/t size rss un gn ul gl r/s rMB/s wMB/s cpu engine | |
2734 0.76 14.92 0.48 6319 81 14.1 0.6 0.4 1 0.7 2085 40.8 1.3 17.3 MyRocks.none | |
2760 0.76 9.29 0.45 7110 40 14.1 0.5 0.4 0.9 0.6 2103 25.6 1.3 19.6 MyRocks.zstd | |
1732 1.01 16.49 15.73 9848 133 14.0 2 2 23 2 1752 28.6 27.2 17.1 Inno5096 | |
1793 0.91 14.80 15.70 9614 133 13.8 2 2 23 2 1628 26.5 28.2 17.2 Inno5172 | |
2355 0.93 14.89 15.99 7768 135 13.9 3 2 7 2 2192 35.1 37.7 18.3 Inno5551 | |
2399 0.92 14.79 13.50 7583 134 13.7 2 1 4 1 2218 35.5 32.4 18.2 Inno5635 | |
2244 0.93 14.85 15.08 8357 134 13.3 2 1 3 1 2082 33.3 33.8 18.8 Inno5717 | |
2167 0.92 14.65 16.58 8687 133 13.3 2 2 5 1 1985 31.8 35.9 18.8 Inno802 | |
legend: | |
* tps - transactions/second | |
* r/t - iostat reads per transaction | |
* rkb/t, wkb/t - iostat KB read and written per transaction | |
* Mcpu/t - normalized CPU time per transaction | |
* size - database size in GB at test end | |
* rss - mysqld RSS at test end | |
* un, gn, ul, gl - 99th percentile response time in millisecs for UpdateNode, GetNode, UpdateList and GetLinkedList transactions | |
* r/s - iostat reads/second | |
* rMB/s, wMB/s - iostat read and write MB/s | |
* cpu - average CPU utilization from vmstat us + sy |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment