… queries that I have gathered from one of the Percona Server instance running on my personal Amazon micro instance. Using pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can be pretty CPU…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 1 Comment
… # limits this to 100 queries only # –no-report simply skips the overhead pt-query-digest had to compute # values for reports pt-query-digest –print –no-report –sample 100 –type tcpdump /path/to/tcpdump.out \ | pt-upgrade…
Comment: Percona Toolkit 1.0.1 released
September 8, 2011 By 13 Comments
… mk-query-digest can parse Postgres log files, but we want to make pt-query-digest simpler, and yanking out that code will help. pt-online… bugs in features that we’ll remove entirely in the PT tools, for example. But that is life. We can’t…
Comment: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
… on a UI for pt-query-digest that allows easier reviews. It can be found at https://github.com/kormoc/Query-Digest-UI I’ve been working on getting things like query formatting working via a module… to integrate. And if anyone has any feedback on the Query-Digest-UI, I would love to hear it!
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… it is good to use pt-query-digest to compare workloads on servers. Best if you can analyze full query logs but if this… Run EXPLAIN to see if plans for the query are the same. Changing Query Execution plans is the most common regression problem… change your application by changing how query is written and provide the hints. Check Query Execution If query execution plan looks the same…
Page: Tools
May 30, 2008 By 31 Comments
… analyze slow query log. It reads bunch of different log formats and has various stats, and it was there before pt-query-digest appeared…
Comment: Gathering queries from a server with Maatkit and tcpdump
February 23, 2012 By 23 Comments
When running pt-query-digest with –processlist, the #Time attribute is always returned as “# Time: 2012-02-23T15:09:00″ where there’s an extra T in the middle making the –since and –until option unusable. Is there anyway to get around this?
