Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
You can buy off the shelf now boxes with 64G or 128G RAM in them - I have a a hard time believing that it makes economic sense to use SSD for sorting. –  Gaius Jan 12 '11 at 22:10

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
    
Thanks for your answer. I should have been more specific: large data warehouse, huge tables, lots of sorting. –  SteveHarville Jan 12 '11 at 16:16
    
I updated the original question to make it more specific. –  SteveHarville Jan 12 '11 at 18:28
1  
Actually all reads are cache by the EMC array, unless you disable the read cache for that LUN (easy to do, just a check box). With a large high IO database EFDs can definitely reduce your IO wait times. I'll leave the MySQL stuff to someone else (I know almost nothing about MySQL at this point). –  mrdenny Jan 12 '11 at 20:07
    
All reads are cached but the cache will not have the next random read and the one just cached won't be read again. We are getting a new Storage System with EMC FAST so all the hot blocks will migrate to SSD. So the question is moot now. –  SteveHarville Jan 21 '11 at 21:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.