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
Results
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) |
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.
Vadim,
Very interesting…. it for some reason with smaller BP size when workload is expected to be more IO bound the difference from FusionIO is smaller than for less IO bound workload which is very counter intuitive. Do you have any ideas why it would happen?
Also did you do similar run for conventional Hdds… I wonder how much faster is it…
Is 910 crash safe – does it have capacitors to save data?
Andy,
I am not totally sure, however document
http://download.intel.com/newsroom/kits/ssd/pdfs/Intel-SSD-910-Series_ProdSpec.pdf
says that card can return SMART attribute “Volatile Memory Backup failure” which corresponds to broken capacitor.
So I guess it has.
Peter,
Yes, it is not obvious, but I have a theory.
As you see form raw IO benchmark, Intel 910 is much better in reads than writes.
Having smaller BP corresponds to more reads intensive workload, so that’s why Intel shows less gap there.
I am going to have the similar benchmark against RAID10 to compare numbers.
Hi vadim,
What about different firmware levels?
Daniel,
I am not sure I understand your question.
Hi Vadim,
Different firmware releases can have a big impact on the performance of the fusion io devices. Did you try different firmware’s? And could we expect anything from a new firmware?
Daniel,
I tested it with Fusion-io Drivers 3.1.5. Fusion-io does not really support downgrading version, so I can’t test with
older releases. I know that 3.x series for Fusion-io provides better performance than 2.x one.
| MySQL Version: Percona Server 5.5.27-28.1
The logs suggests that this was on MySQL-5.6.6, not 5.5.