When you process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical…-query-digest. Main features: * Dynamic filtering and searching of queries * Colorized and normalized SQL syntax * Explain the query dynamically * Integrated pt-query-advisor support * Detailed query…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… was working on today – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from… the other useful information, not even query timing. Instead, I’ve used mk-query-digest: mk-query-digest –filter=’$event->{Thread_id} == 160847… it would optimize the queries all together! Unfortunately mk-query-digest won’t do that for you, but then there’s mk-query-advisor 
Post: Optimize Your SQL With Percona's Online Query Advisor!
February 15, 2012 By 23 Comments
… nice if you could get expert advice on your SQL queries to find problems in them, the same way that programmers…-15; Do you see it? Congratulations! I’ve analyzed that query with the tool, and shared the results with you. Click…. That demonstrates another feature of the tool: you can share queries so they’re public, and other people can see them…
Comment: Optimize Your SQL With Percona's Online Query Advisor!
February 15, 2012 By 23 Comments
… following query, there isn’t a problem with the GROUP BY, yet the advisor claims a “Non-deterministic GROUP BY”. The next query is invalid but the advisor fails to detect the… your description, that the advisor is supposed to catch that (is it only supposed to work with queries that are valid?) In…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…-change pt-archive pt-mysql-summary pt-heartbeat pt-variable-advisor pt-config-diff pt-deadlock-logger The bug fixes are…-query-digest fails to parse timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query… report. Now such no-query events show up in reports as “/* No query */“. Fixed bug 1078838: pt-query-digest doesn’t parse general…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
…: a SQL formatter, a visual EXPLAIN tool, a configuration advisor, a query analysis tool, a way to register a server’s essential…
