Intel SSD 910 in tpcc-mysql benchmark

September 7, 2012

Author

Vadim Tkachenko

Benchmarks

Hardware and Storage

MySQL

Share this Post:

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.

Benchmark date: Sep-2012

Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with baseline Fusion-io ioDrive card

Hardware specification

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

Software

OS: Ubuntu 12.04.1

MySQL Version: Percona Server 5.5.27-28.1

Benchmark specification

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

Parameters to vary: we vary innodb_buffer_pool_size: 13, 25, 50, 75GB to have different memory/data ration. And we test it on two storages: Fusion-io ioDrive and Intel SSD 910

Results
There is graph of Throughput taken every 10 sec:

Jitter graph:

Or to have final results I take total amount of transactions for 1h:

BP size	Fusion-io	Intel SSD 910	Ratio (fio/i910)
13 GB	397157	352750	1.13
25 GB	724011	497769	1.45
50 GB	1466559	1124223	1.30
75 GB	2464135	1939415	1.27

Conclusion

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.