Getting the Best MySQL Performance in Your Products: Part III, Query Tuning
Part III of the four-part performance presentation, series, will show you how to tune queries in your product's MySQL embedded or bundled database. Part III reviews the following elements of query tuning (below), building on the steps covered in Part 1, the Fundamentals and Part II, Beyond the Basics.
1) Monitoring your queries
2) Understanding query performance
4) Using temporary tables
5) GROUP BY operations