gistfile1.txt

From the Insert Benchmark on a small server with an IO-bound workload and 1 client

Legend:
* IPS - average rate for inserts/s during l.i1 (random writes) benchmark step
* cs/s - average rate for context switches/s from vmstat
* cpu/s - average rate for CPU utilization (us+sy) from vmstat
* cs/q - cs/s divided by IPS
* cpu/q - cpu/s divided by IPS and then multiplied by a constant

IPS     cs/s    cpu/s   cs/q    cpu/q           dbms
1998    67162   16.2    33.62   .008096         10.4.33
2048    93293   13.2    45.55   .006444         10.5.24
1481    65430   10.6    44.12   .007154         10.6.17
1513    62899   14.1    41.56   .009297         10.6.17, v3
1453    56729   15.6    39.03   .017010         10.6.17, v3 and innodb_spin_wait_delay=8