…’); Filtering Slow Query Log – Especially after the changes 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 Nathanial Hendler) which allows you to filter out only queries which took more than…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous … I’ve got some time to play with table based slow query log in production while tuning one of the systems. It is… some changes) or filter out queries which you already looked at using LIKE statement. As default table format for slow_log is CSV with…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… other is slow log enabled by –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store poorly performing queries that run at… peek into a network stream and filter for packets that go to MySQL. Those packets contain queries. Here’s my quick one…
Post: Finding what Created_tmp_disk_tables with log_slow_filter
September 22, 2008 By 3 Comments
… the filter to an empty string to stop 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 the…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… today – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew some… a slow query log that lists all the queries that were executed during this session in the order they were executed: mk-query-digest –filter=’$event…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…. 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 and memory consuming, so ideally you would want to download the “slow query log… the number of results returned by the query, by using a LIMIT clause or by filtering based on the option_name column…
Comment: Slow Query Log analyzes tools
February 3, 2007 By 83 Comments
… a Google Code project for the MySQL Slow Query Log filter: http://code.google.com/p/mysql-log-filter/ You can access the initial PHP5 script here (requires the PHP extension BCMath): http://mysql-log-filter.googlecode.com/svn/trunk/mysql_filter_slow_log…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… 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 83 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: mk-query-digest, query comments and the query cache
… the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, including mk-query…query digest to discover these attributes and use them for aggregation. You could also filter on the embedded information to display only queries…