Maximizing SQL Reviews and tuning with pt-query-digest
pt-query-digest is one of the more valuable components of the Percona Toolkit available as OSS to DBAs. In this talk, we will review the following with an eye towards real world test cases, output reviews and anecdotal production experience.
* Overview of functionality and usage
* Gathering data: slow/general logs, tcpdumps and more.
* How to use pt-query-digest against CSV tables (useful in Amazon RDS)
* Reviewing and interpreting output
* Identification of most executed queries and opportunities for improvement
* Identification of most impactful queries and opportunities for improvement
* Automating reports for devops and engineering teams using pt-query-digest