Present finding gathered over 6 months working with solid state technology. The current generation of solid state drives can perform 5K random reads per second, while the current 10K rpm disk drive performs about 200 random reads per second. Thats a 25X performance improvement for 2-3x the cost of a single 10K drive.
Outline from my presentation:
- Solid State Disk!
-
When was the last Jump in disk technology?
When was the last big break through in memory?
When was the last big break through in CPU?
When was the last big break through in disk?
-When? -Memory: DDR : 2000 DDR2 : 2003 DDR3 : 2008 -CPU : 2000 P4 2002/3 hyperthreading 2005 64 bit! 2006 Dual Core – 2007 Quad Core -Disk? VH1’s back to the 90’s NO MAJOR CHANGES SINCE BILL Clinton WAS IN OFFICE! 10K RPM 1996 15K RPM 2000 8 years since something good, SSD is game changing
- Why?
- Sun Loves Solid State
- What is SSD?
- Why is it so cool?
-Disk is the slowest part of a system Harddrive access times < 5ms Memory access times < 60 ns Cpu cache access times < 10ns SSD < .5ms
The majority of workloads tend to have some sort of IO issues
Lower failure rates
- What will this due to disk? Revolutionize disk
-Different SSD type technologies:
Flash Based
SLC vs MLC
DDR Based
MTRON & Memoright disks!
- Benchmarks:
-Drive Tests: MTRON Memoright
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Orion IO Latency
-Orion IO
-More Orion
-More Orion
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Sysbench Random Read/Write Performance
-Whats MFT?
-DBT2 Buffer Pools
-MFT Free Space
-Mount Options
-IO Still Slower them memory
-MFT Helped with lower memory
-MyISAM Tests
-Io Schedulers
Ext3 -vs xfs
-IOSTAT?
Matthew Yonkovit is a 12 year database veteran, who has worked on large performance tuning adventures on most major database platforms for several fortune 500 clients. He currently is a SR. Consultant for Mysql and lives in St. Johns Michigan.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com
Download the MySQL Sponsor/Exhibitor Prospectus
Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.