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 this short series I will show you how to do Slow Query Logging the right way.
Here’s links to the other two parts:
- Advanced MySQL Slow Query Logging Part 2: pt-query-digest report
- Advanced MySQL Slow Query Logging Part 3: fine-tuning the logging process
Follow Speedemy
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: