… of the protocol. This lets us gather queries from servers that don’t have a slow query log enabled, at very high time resolution. With this new functionality, it becomes possible for mk-query-digest to… useful than just seeing a query or two — it has all the power of mk-query-digest for filtering, aggregating, printing and so…
Comment: Slow Query Log analyzes tools
February 4, 2007 By 84 Comments
…: # Filter slow queries executed from other users than root for at least 3 seconds, remove duplicates and save result to file php mysql_filter_slow_log.php -T=3 -eu=root –no-duplicates mysql-slow-queries.log # Start permanent filtering of all slow queries from now on: at…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… or other interval of your choice. 2) Use full slow query log and mk-query-digest. This method is great for one time execution… all queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow-log –filter…
Comment: Slow Query Log analyzes tools
January 30, 2007 By 84 Comments
… Peter, I reimplemented the mysql_slow_log_parser in PHP in order to provide an even more filtered result. If you want me… filter to log file once php mysql_slow_log_parser.php mysql-slow-queries.log Options: -T=min_query_time Include only queries which took as long as min_query…=include_query Include only queries which contain the string include_query (i.e. database or table name) [multiple] –filter-duplicates Output only unique query strings…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… mk-query-digest output was obviously bogus when compared to the host’s slow-query-log (for example, none of the top 5 slow queries reported by mkqd appeared in the actual slow log file). After a little brain-storming, we came up with a few solutions: use “mk-query-digest –filter ‘$event->{time…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… handling the XtraDB changed page tracking log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set… being logged even if they weren’t enabled for the slow query log. Bug fixed #730173 (Laurynas Biveinis). Fixed the regular expressions used for filtering…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…). Upstream bug #67983 was causing a memory leak on a filtered slave. Bug fixed #1042946 (Sergei Glushchenko). Percona Server would fail… being logged even if they weren’t enabled for the slow query log. Bug fixed #730173 (Laurynas Biveinis). Fixed the incorrect help text for slow_query_log…
Post: Missing Data - rows used to generate result set
July 20, 2008 By 15 Comments
… slow query log record) is the number of rows which MySQL used to generate result set. Comparing this number with number of rows query… queries so the number of rows accessed is same as number of rows used to generate result set – for example any filter…’t use indexes will make these number different, though such filter will be suboptimal and you may think how to fix…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… pt-query-digest fails to parse timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query_log_timestamp_…tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables were not applied. Fixed …
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… well it can bring the server down. You can have slow query log enabled and review it occasionally, but doing it offline means… query transformations, joins and better filtering for the statistics Also combining these new commands with our msl patch, which introduces the advanced query logging…
