It is known that MySQL due internal limitations is not able to utilize
all CPU and IO resources available on modern hardware.
Idea is to run multiple instances of MySQL to gain better performance on Fusion-io ioDrive card.
Full report is available in PDF
For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems.
Fusion-io ioDrive Duo 640GB MLC card was provided by Fusion-io.
More details on hardware and software configuration are in full report
tpcc-mysql tests were run for following combinations:
2400W, big buffer pool
2400W, small buffer pool
1200W, big buffer pool
1200W, small buffer pool
The purpose of different combination of data and memory sizes, was to check
how data/memory ratio affects results.
We used 48 user sessions and we performed 2700 sec long run, gathering data for New Order Transaction each 10 seconds.
That is, for each set of user sessions, we take 270 throughput measurements.
Based on this, we constructed Median Throughput for last 900 sec, to avoid warm-up influence on results.
In conclusion I can highlight:
Recently Fusion-io announced new ioDrive2 card with new driver, which promises even better performance for MySQL. I am looking forward to test it.
Disclaimer: This benchmark is sponsored by Fusion-io, but this post is totally independent and fully reflects our opinion.