gistfile1.txt

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