Getting the Best MySQL Performance in Your Products: Part III, Query Tuning

In Part III of our four-part performance series, Alexander Rubin gives you expert advice on how to tune queries in your product's MySQL embedded or bundled database. Alexander has many years of MySQL consulting experience optimizing his clients' MySQL databases and queries. He is also the performance expert in the MySQL consulting organization, the one MySQL experts turn to for performance advice.

In this session, Alexander will review the following elements of query tuning, building on the steps he covered in Part 1, the Fundamentals and Part II, Beyond the Basics.

1. Monitoring your queries
2. Understanding query performance
3. Indexes
4. Using temporary tables
5. GROUP BY operations
6. Subqueries

We will also cover the new MySQL 5.6 features, which can improve performance of your queries.

WER:

WO: