This blog, MySQLPerformanceBlog.com, is powered by WordPress, but we never really looked into what kind of queries to MySQL are used by WordPress. So for couple months we ran a Query Analytics (part of Percona Cloud Tools) agent there, and now it is interesting to take a look on queries. Query Analytics uses reports produced by pt-query-digest, but it is quite different as it allows to see trends and dynamics of particular query, in contrast to pt-query-digest, which is just one static report.
Why looking into queries important? I gave an intro in my previous post from this series.
So Query Analytics give the report on the top queries. How to
detect which query is “bad”?
One of metrics I am typically looking into is ratio of “Rows …