Create a gist now

Instantly share code, notes, and snippets.

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