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.