After my previous benchmarks of FusionIO 160GB SLC card, FusionIO team sent me for the tests another card, FusionIO 320GB MLC. I should say I really appreciate an opportunity to play with this card and with combination of two cards.
This card is also not cheap, the price I can find on dell.com is $6,829.99, which is almost the same as for 160GB card, but with doubled space,
and which gives me 21$/GB for 100% formatted card, and 29$/GB for card with 75% of space allocated. Effect of 25% reserved space you will see in the results.
The full numbers are available on our Wiki benchmarks page, couple words about benchmarks.
I did sysbench fileio runs on 100% space allocated card and on 75% space allocated (240GB of
available disk space), and on 32GB and 100GB filesizes. After that I took two cards into software RAID0, and tried 100GB filesize in this configuration. Block size is 16KB in all cases.
The results for random write is here:
(Results are in MB/s (more is better) for random write test, pagesize 16KB )
|threads||32GB filesize, 100% space formatted||32GB filesize, 75% space formatted||32GB filesize, SLC||100GB filesize, 75% space formatted||100GB filesize, RAID0 over 2 cards|
or in chart form:
(if legend is unreadable, it is:
I hope Google Docs will fix the issue with font for the legend sometime
So there some numbers to consider:
Now having these cards and numbers, I am going to benchmark MySQL with FusionIO as storage.
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.