Intel SSD 910 in tpcc-mysql benchmarkVadim Tkachenko
I continue my benchmarks of Intel SSD 910, the raw IO results are available in my previous experiment. Now I want to test this card under MySQL workload to see if the card is suitable to use with MySQL.
- Server: Dell PowerEdge R710
- CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz
- Memory: 192GB
- Storage: Fusion-io ioDrive 640GB, Intel SSD 910 (software RAID over 2x200GB devices)
- Filesystem: ext4
- OS: Ubuntu 12.04.1
- MySQL Version: Percona Server 5.5.27-28.1
- Benchmark name: tpcc-mysql
- Scale factor: 2500W (~250GB of data)
- Benchmark length: 2h, but the result is taken only for last 1h to remove warm-up phase
There is graph of Throughput taken every 10 sec:
Or to have final results I take total amount of transactions for 1h:
|BP size||Fusion-io||Intel SSD 910||Ratio (fio/i910)|
In conclusion I see that Intel SSD 910 handles MySQL workload quite well, I did not face any problem working with this card.
Level of stability of results is about the same as with Fusion-io card. The performance of Intel SSD 910 is about ~30% worse, but
it is expected for this price level. I think Intel SSD 910 is suitable to use with MySQL / Percona Server.
Link to raw results and stats
Raw results, config, OS and MySQL metrics are available from Benchmarks Launchpad.