10x Performance Improvements - A Case Study

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