10x Performance Improvements - A Case Study

Ronald Bradford (EffectiveMySQL)
Average rating: ***..
(3.00, 3 ratings)

Our presentation will provide details include:

  • Identify what is truly slow and high volume queries
  • Choosing the right indexes including unique indexes, concatenated and partical indexes
  • Choosing the right storage engines (MyISAM, InnoDB and Memory)
  • Removing load including synchronous/real-time queries, master load, locking and sharding
  • The best performance improvement for a SQL statement is to eliminate it
  • Quantifying improvements made

The 10 Points are:

1. Monitor, Monitor, Monitor
2. Identify problem SQL
3. Analyze problem SQL
4. Indexes
5. Offloading master load
6. Improving SQL
7. Storage engines
8. Caching
9. Sharding
10. Handling database maintenance

Bonus. Front end improvements

Photo of Ronald  Bradford

Ronald Bradford

EffectiveMySQL

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo 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

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.