MySQL and Solid State Disks on EMC Since all writes and sequential reads are cached by the EMC storage system, the best use for solid state disk is to store data that has a random READ pattern. On Oracle, that is the temp tablespace which is used for disk sorts that cannot fit in memory. How can I isolate the parts of MySQL which are characterized by a random disk read pattern?

Here's a clarification of my original question: This is a reporting database with very large tables, large sorts, etc. Cannot fit into server memory.
Typically any OLTP database that can't fit into memory has random reads.  If you are reading that much from your OLTP database that you need EFDs (what EMC calls SSDs) then you need to first look at putting a LOT more RAM into the database server.  It will be a lot cheaper to prevent the reads than to make the reads faster.  Those EMC EFDs run about $20k each.