…slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to…queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a production database backup to…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…set-vars is used to set both of these (or any) system variables. For a quick intro to metadata locks and how…MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…queries in slow query log by setting long_query_time=0 This patch is adapted version of patch by Georg Richter which was made to run with recent MySQL… with slow query log parser tool which works with adjusted slow query log format and which gives samples of queries after aggregation. Here is how its…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in…to play with table based slow query log in production while tuning one of the systems. It is pretty nice to be able to work with data in…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
…slow_query_log_file=mysql-slow.log Discovering long_query_time=60.000000 Setting long_query_time=0 Setting slow_query_log_file=mysql-slow.log-full-20121122112413 Setting slow_query_log=1 Flushing slow query log Sleeping 5 seconds… done. Restoring slow_query_log_file=mysql-slow.log…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
…to re-examine how we could provide slow query log type functionality to our users. The slow query log code inside the MySQL…_APPEND, the file offset is first set to the end of the file before …I had to extend the MySQL plugin API to be able to reproduce all the information in the slow query log. …
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…how one can find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries…In this case if I index the table I get the following record in the slow query log…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… 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… $REMOTEHOST — “cat – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to be sure both remote files are removed trap ‘ssh $REMOTEHOST…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL…query plan. This is where you need to really know how to write queries and how…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3…. 0.000007 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | +———————-+————+ 17 rows in set (0.00 sec) And you can see how the query spent …
