The Sysbench version used was 0.4.8, and the read-only runs were invoked with the following command:
sysbench --max-time=300 --max-requests=0 --test=oltp --oltp-dist-type=special --oltp-table-size=10000000 \ --oltp-read-only=on --num-threads=[NO_THREADS] runThe "oltp-read-only=on" parameter was omitted for the read-write tests. The my.cnf file listed in my previous blog was also used unchanged for these tests.
Here is the data presented graphically. Note that the number of vCPUs is the same as the number of active[Read more...]