Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
1 processes, 500000000 rows-per-process, 91080 seconds, 5489.6 rows-per-second, 5489.6 rows-per-second-per-user, 0 queries, 0 queries-per-second
iostat, vmstat normalized by insert rate
samp r/s rkb/s wkb/s r/q rkb/q wkb/q ips spi
9109 445.5 7129 254083 0.081 1.299 46.284 5489.6 0.018216
samp cs/s cpu/c cs/q cpu/q
9542 28270 25.9 5.150 0.004715
iostat, vmstat normalized by query rate
samp r/s rkb/s wkb/s r/q rkb/q wkb/q qps spq
samp cs/s cpu/c cs/q cpu/q
90G /data/m/my/data
mdcallag 14055 94.8 81.3 14394640 13278408 pts/2 Sl May28 1444:30 ./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 1337564 1733406 1839057 73130 16827 16 0 0 1.136672
insert and query rate at nth percentile
50th, 2500 / 5001 = 5967.6 insert, 0.0 query
75th, 3751 / 5001 = 4074.5 insert, 0.0 query
90th, 4501 / 5001 = 3515.1 insert, 0.0 query
95th, 4751 / 5001 = 3320.7 insert, 0.0 query
99th, 4951 / 5001 = 3037.6 insert, 0.0 query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment