Getting the Best MySQL Performance in Your Products: Part II, Beyond the Basics

Part II of a four-part performance presentation series takes you beyond the basics and shows you the next set of steps to take when architecting your product's MySQL embedded or bundled database for higher performance.  The technical presentation builds on the concepts covered on Part I, The Basics, and reviews the following, more advanced topics:

  • Monitoring - How to know what’s going on
  • Data and Key Caches
  • Tuning - Even with other applications on the server
  • Sorting
  • Other Server Tuning Tips
  • Benchmarks
  • New in MySQL 5.6:
  • Monitoring with performance schema
  • Query performance optimizations