As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in … easy to filter all queries which happened within certain time interval (ie after I’ve done some changes) or filter out queries which you… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log by… same slow query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter -T…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
When you process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical values for… browse slow queries. The web interface is AJAX-based. Please refer to the screenshots below to see what columns you can filter the… from the MySQL Slow Query Log. The name comes from the instrument in a weather station that measures wind speed. SQL queries are like…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
…can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into query_review_history table…you copied slow query log from the another server. Having hostname set might be useful for filtering queries in the database aggregating slow queries from …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02… 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… the number of results returned by the query, by using a LIMIT clause or by filtering based on the option_name column…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…query-digest fails to parse timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query…. When using –replicate-check-only, filter options like –databases and –tables …. Previously, pt-heartbeat respected the MySQL time zone, but this caused false…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it is easy to filter out events) so… be even system which queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query on information_schema which…
Post: Finding what Created_tmp_disk_tables with log_slow_filter
September 22, 2008 By 3 Comments
… MySQL. The microslow patch adds a very useful feature, the ability to log queries by execution plan. log_slow_filter=name Log only the queries… collection. SET GLOBAL log_slow_filter:=”"; Then it was just a question of examining the slow query log and fixing the queries. More information about…
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…
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… “mk-query-digest –filter ‘$event->{time} && $event->{time} > 1′” to exclude all queries which it believes took longer than the servers long-query-time…
