Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
1 processes, 5000000 rows-per-process, 5005 seconds, 999.0 rows-per-second, 999.0 rows-per-second-per-user, 4238448 queries, 846.8 queries-per-second
iostat, vmstat normalized by insert rate
samp r/s rkb/s wkb/s r/q rkb/q wkb/q ips spi
501 3406.8 54508 91964 3.410 54.563 92.057 999.0 0.100100
samp cs/s cpu/c cs/q cpu/q
525 16228 17.3 16.244 0.017276
iostat, vmstat normalized by query rate
samp r/s rkb/s wkb/s r/q rkb/q wkb/q qps spq
501 3406.8 54508 91964 4.023 64.370 108.602 846.8 0.118092
samp cs/s cpu/c cs/q cpu/q
525 16228 17.3 19.164 0.020381
91G /data/m/my/data
mdcallag 14055 93.0 81.6 14394640 13326704 pts/2 Sl May28 1494:01 ./bin/mysqld --basedir=. --datadir=/data/m/my/data --plugin-dir=./lib/plugin --log-error=/data/m/my/data/nuc71.err --pid-file=/data/m/my/data/nuc71.pid
Insert rt: 256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max
Insert rt: 0 0 5509 30394 11625 2472 0 0 0 0 0.162702
Query rt: 256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max
Query rt: 1533183 1233734 1432488 12900 7962 18229 0 0 0 0 0.168406
insert and query rate at nth percentile
50th, 250 / 501 = 999.2 insert, 912.5 query
75th, 376 / 501 = 997.7 insert, 759.4 query
90th, 451 / 501 = 995.5 insert, 558.4 query
95th, 476 / 501 = 992.3 insert, 308.9 query
99th, 496 / 501 = 986.0 insert, 106.6 query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment