… you shouldn’t have a problem finding queries to run and compare. pt-query-digest is simpler pt-query-digest 2.2 has fewer options now. Basically, we re-focused it on its primary objective: analyzing MySQL query logs…. There are more changes in addition to those highlights. For example, three tools were removed, and there were several bug fixes…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 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…us more accurate understanding. Now, for example it is shown here that every query is reading approximately 38.53 distinct…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
… types supported by pt-query-digest‘s –type option is also possible, see below). Test away! Some example scenarios below. Using slow query log: # You can also run the slow log through pt-query-digest like the commands below…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
… you run pt-query-digest but in order to set the hostname you need to specify it in the –filter option. For example: pt-query-digest –review h=localhost,D=percona,t=query_review,p=pass,u=percona \ –review-history h=localhost,D=percona,t=query_review…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… can find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries which cause… to understand how much optimization is possible. For example I might have query which uses some index scans 1000 rows and sends… more this query is a very serious candidate for optimization. This is simple method and it can be used with pt-query-digest very…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… the Percona Toolkit is pt-query-digest. This tool is indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your…’s an example of running it with verbose output: $ full-slow-log -v Discovering slow_query_log=1 Discovering slow_query_log_file…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… Percona Live New York, and it includes an example of pt-table-checksum and pt-table-sync, among others. Q: Which options were… output by pt-query-digest. You can see the command line used to generate it at the top, it’s just pt-query-digest master/data…-all and –review with pt-query-digest. For example, with the sandbox server I used for the examples, it would be pt-query-digest –review S=/tmp/mysql…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
… of query and the type of index merge algorithm in the “Extra” field. Here’s an example of a table and a query… a pt-query-digest report which showed that it was the most commonly executed query on the server by two orders of magnitude. Other queries…, user_type) = (0, 1, 2) tuple chosen by pt-query-digest as the sample query wasn’t a fluke or unfortunately-chosen representative; in…
Comment: Percona Toolkit 1.0.1 released
September 8, 2011 By 13 Comments
…’t relevant. For example, it’s nice that 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… in features that we’ll remove entirely in the PT tools, for example. But that is life. We can’t focus in…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… or failover capability. For example tables used for logging less critical information. In this scenario, not all queries could scale out to… to direct queries to the slave(s) that have a copy of the right database. Q: Based on the example, I assume… the MySQL database for persistence, but when we measured query load with pt-query-digest, we found that 30% of the database response time…
