Proper MySQL Query Optimization starts with a proper Slow Query Logging session. And MySQL Query Optimization is where I spend 70-80% of my time when doing MySQL performance optimization.
In part 2 here, we will go over the pt-query-digest report, that we have prepared in part 1.
Here’s links to the other two parts: