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:
- Advanced MySQL Slow Query Logging Part 1: the essentials
- Advanced MySQL Slow Query Logging Part 3: fine-tuning the logging process
I believe that providing the best user experience is the key to business success. Big part of that is making online systems fast, stable and reliable. On Speedemy.com, I am sharing best practices and tested methods that I have used for the last 12 years working as an architect of scalable systems and database performance consultant.
If you too are looking to improve the speed and reliability of your system, let's stay in touch: