MySQL 5.4 Sysbench Scalability on 64-way CMT Servers
By allanp on Apr 21, 2009
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 threads up to 64. Active threads beyond 64 are using only 64 vCPUs.
And here is some raw data:
A few observations:
- Throughput scales 63% from 32-way to 64-way for read-only and 67% for read-write. Not quite as good as for the OLTP test reported in my earlier blog, but not at all bad.
- Beyond 48 vCPUs, idle CPU is preventing optimal scaling for the read-only test.
- There's quite a bit of CPU left on the table for the read-write tests.