"Having little time and lots to do, I decided that I was mainly
interested in the “painful” cases we see. For example,
it’s interesting to note that the Fusion-io card has the
advantage of being plugged into a PCI express slot and is not
subject to the limitations of more traditional disk I/O channels.
That means you can move a lot of data VERY quickly. But
that’s not a concern in most of our cases.
"The servers generally have a fair amount of RAM (32GB is
common) and most of that is used for InnoDB’s buffer pool.
What does hurt are queries that cause InnoDB to hit the disks to
fetch pages that haven’t been cached. These are generally
small random reads that are scattered all over the disk. As
I’ve discussed in previous articles, this is a latency (seek
time) issue, not a throughput issue.
"But the Fusion-io card is SLC memory based, so the
“seek” times should be VERY small. The same is true for
the regular SSD."
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.