gistfile1.txt

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