Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created June 2, 2017 19:12
Show Gist options
  • Save mdcallag/73aa938c417a19367a155eed3a6a251d to your computer and use it in GitHub Desktop.
Save mdcallag/73aa938c417a19367a155eed3a6a251d to your computer and use it in GitHub Desktop.
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