Created
June 2, 2017 19:12
-
-
Save mdcallag/73aa938c417a19367a155eed3a6a251d 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
| legend: | |
| * ips.av, qps.av - average rates for inserts/second and queries/second | |
| * ips.75, ips.95, ips.99 - insert rate at 75th, 95th and 99th percentile computed from per-interval rates over ~10 second intervals | |
| * qps.99 - query rate at 99th percentile (see ips.99) | |
| * r/i, rkb/i, wkb/i - iostat reads, KB read and KB written per insert | |
| * r/q, rkb/q - iostat reads and KB read per query | |
| * Mcpu/i, Mcpu/q - CPU utilization per insert and per query -- vmstat us and sy divided by ips.av, qps.av and multipled by a constant | |
| * size - database size in GB at test end | |
| * rss - mysqld RSS in GB at test end | |
| * r/s, rmb/s, wmb/s - average rates for iostat r/s, rMB/s and wMB/s | |
| * cpu - average CPU utilization from vmstat us + sy | |
| * engine - storage engine | |
| --- load | |
| ips.av ips.75 ips.95 ips.99 r/i rkb/i wkb/i Mcpu/i size rss r/s rmb/s wmb/s cpu engine | |
| - i3 NUC | |
| 20202 16447 14929 14265 0 0 7.12 1604 2.1 2.5 1 0 143.9 32.4 inno5635 | |
| 18727 15499 12519 11921 0 0 8.27 1595 2.2 2.3 4 0 154.9 29.9 inno5717 | |
| 16447 14163 12343 11963 0 0 9.90 1764 2.5 2.6 3 0 162.7 29.0 inno801.utf8 | |
| 16420 13614 11420 10725 0 0 9.88 1772 2.5 2.6 3 0.1 162.3 29.1 inno801.latin1 | |
| - i5 NUC | |
| 48077 45018 41937 34811 0 0 5.98 825 2.4 3.2 0.1 0 287.4 39.7 inno5635 | |
| 42373 40173 36573 35490 0 0 9.03 860 2.4 3.1 0 0 382.5 36.4 inno5717 | |
| 39216 37269 35205 33293 0 0 9.57 923 2.5 3.2 0 0 375.2 36.2 inno801.utf8 | |
| 40486 38748 34549 30639 0 0 9.40 898 2.5 3.2 0 0 380.4 36.4 inno801.latin | |
| --- q1000 | |
| ips.av ips.99 qps.av qps.99 r/i rkb/i wkb/i Mcpu/i r/q rkb/q Mcpu/q size rss r/s rmb/s wmb/s cpu engine | |
| - i3 NUC | |
| 999 995 4492 4188 0 0 38.39 28335 0 0 6300 3.1 3.7 0 0 38.3 28.3 inno5635 | |
| 999 994 3924 3700 0 0 36.18 27530 0 0 7008 3.1 3.5 0 0 36.1 27.5 inno5717 | |
| 999 997 3267 3088 0 0.01 40.80 27633 0 0 8450 3.4 3.5 0 0 40.8 27.6 inno801.utf8 | |
| 999 994 3222 3066 0 0.01 41.21 27696 0 0 8587 3.4 3.5 0 0 41.6 27.7 inno801.latin1 | |
| - i5 NUC | |
| 999 998 8937 8423 0 0 44.60 27021 0 0 3021 3.4 4.1 0 0 44.6 27.0 inno5635 | |
| 999 999 6625 6276 0 0 48.79 26976 0 0 4068 3.4 4.0 0 0 48.7 26.9 inno5717 | |
| 999 999 6423 6117 0 0 49.73 26834 0 0 4174 3.4 4.1 0 0 49.7 26.8 inno801.utf | |
| 999 999 6495 6182 0 0 49.71 26817 0 0 4124 3.4 4.1 0 0 49.6 26.8 inno801.latin1sw | |
| --- q100 | |
| ips.av ips.99 qps.av qps.99 r/i rkb/i wkb/i Mcpu/i r/q rkb/q Mcpu/q size rss r/s rmb/s wmb/s cpu engine | |
| - i3 NUC | |
| 100 100 4385 4192 0 0 100.40 258574 0 0 5885 3.1 3.8 0 0 100.2 25.8 inno5635 | |
| 100 100 3859 3714 0 0 50.30 253530 0 0 6563 3.2 3.6 0 0 5.0 25.3 inno5717 | |
| 100 100 3219 3080 0 0.06 54.12 253968 0 0 7882 3.5 3.5 0 0 5.4 25.4 inno801.utf8 | |
| 100 100 3231 3106 0 0.07 55.38 255673 0 0 7898 3.5 3.5 0 0 5.5 25.5 inno801.latin1 | |
| - i5 NUC | |
| 100 100 9055 8406 0 0 52.72 256905 0 0 2834 3.4 4.1 0 0 5.3 25.7 inno5635 | |
| 100 100 6715 6358 0 0 54.11 254845 0 0 3792 3.5 4.1 0 0 5.4 25.5 inno5717 | |
| 100 100 6588 6248 0 0 54.65 254140 0 0 3854 3.5 4.2 0 0 5.5 25.4 inno801.utf8 | |
| 100 100 6539 6149 0 0 55.18 254311 0 0 3885 3.5 4.1 0 0 5.5 25.4 inno801.latin1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment