Last active
May 9, 2017 14:14
-
-
Save mdcallag/43f69854bf7ce0fc9347d7698db2640f 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 rate for inserts & queries | |
| * ips.75, ips.95, ips.99 - insert rate at 75th, 95th and 99th percentile computed from ~10 second interval rates | |
| * qps.99 - query rate at 99th percentile (see above) | |
| * r/i, rKB/i, wKB/i - iostat reads/insert, KB read/insert and KB written/insert | |
| * r/q, rKB/q - iostat reads/query, KB read/query | |
| * Mcpu/i, Mcpu/q - normalized CPU per insert and per query | |
| * size - database size in GB at test end | |
| * rss - mysqld RSS in GB at test end | |
| * r/s, wMB/s, rMB/s - iostat reads/second, MB written/second and MB read/second | |
| * cpu - average cpu utilization from vmstat us & sy columns | |
| * engine - database engine | |
| - mysql | |
| test #1 - 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 | |
| 20202 16447 14929 14265 0 0 7.12 1604 2.1 2.5 1 0 143.9 32.4 inno5635.opt.6g | |
| 18727 15499 12519 11921 0 0 8.27 1595 2.2 2.3 4 0 154.9 29.9 inno5717.opt.6g | |
| 16447 14163 12343 11963 0 0 9.90 1764 2.5 2.6 3 0 162.7 29.0 inno801.opt.6g.utf8 | |
| 16667 14369 12347 11462 0 0 9.86 1756 2.4 2.6 3 0 164.4 29.3 inno801.opt.6g.latin1 | |
| test #2 - wps=1000 | |
| 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 | |
| 999 995 4492 4188 0 0 38.39 28335 0 0 6300 3.1 3.7 0 0 38.3 28.3 inno5635.opt.6g | |
| 999 994 3924 3700 0 0 36.18 27530 0 0 7008 3.1 3.5 0 0 36.1 27.5 inno5717.opt.6g | |
| 999 997 3267 3088 0 0.01 40.80 27633 0 0 8450 3.4 3.5 0 0 40.8 27.6 inno801.opt.6g.utf8 | |
| 999 993 3277 3114 0 0.01 40.98 27608 0 0 8415 3.4 3.5 0 0 40.9 27.6 inno801.opt.6g.latin1 | |
| test #3 - wps=100 | |
| 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 | |
| 100 100 4385 4192 0 0 100.40 258574 0 0 5885 3.1 3.8 0 0 100.2 25.8 inno5635.opt.6g | |
| 100 100 3859 3714 0 0 50.30 253530 0 0 6563 3.2 3.6 0 0 5.0 25.3 inno5717.opt.6g | |
| 100 100 3219 3080 0 0.06 54.12 253968 0 0 7882 3.5 3.5 0 0 5.4 25.4 inno801.opt.6g.utf8 | |
| 100 100 3221 3094 0 0.05 56.19 254452 0 0 7885 3.5 3.5 0 0 5.6 25.4 inno801.opt.6g.latin1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment