I continue my benchmarks of Intel SSD 910, previous time I compared it with Fusion-io ioDrive https://www.percona.com/blog/2012/09/07/intel-ssd-910-in-tpcc-mysql-benchmark/. Now I want to test this card against RAID over spinning disks.
There is a jitter graph of Throughput taken every 10 sec:
I put number of median throughput, so we can estimate a performance gain.
Or in text form:
|BP size||HDD RAID||Intel SSD 910||Ratio (i910/raid)|
So gain is in 5-7x range, which is quite decent.
One thing to pay attention is a density of results. In case with RAID it is much more dense.
So I build a graph where throughput is shown every second:
The variation of throughput with Intel SSD 910 is much bigger, though I am not totally sure what is the main contributor into that: the card of itself
or MySQL internals + flushing logic.
Now, all these results are received with innodb_flush_log_at_trx_commit=2, which in comments to previous post was called cheating.
So I ran another round with innodb_flush_log_at_trx_commit=1 to see what kind of penalty to expect.
There is some penalty of using innodb_flush_log_at_trx_commit=1, but it is not significant.
In conclusion I see that for its price (around $2000 on date of publishing) Intel SSD 910 handles MySQL workload quite well, I did not face any problem working with this card. I think Intel SSD 910 is suitable to use with MySQL / Percona Server, especially if you are looking for quick performance boost in IO heavy workload.