SAN Performance on a Internal Disk Budget: The Coming Solid State Disk Revolution

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

MySQL

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.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.