1 MySQL has a nice feature, slow query log, which allows you to log all queries that exceed a predefined about of time to execute.
2 Percona Toolkit’s pt-query-digest is one of the most powerful tools for SQL analysis.
3 We of course want to get rid of really slow queries but to really optimize application throughput, we also need to investigate queries that generate..