… may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries…
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… explain queries, see their stats and post reviews. Box Anemometer Anemometer is a tool for visualizing collected data 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: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… 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… across 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…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… the query time and lock time as floating-point numerics to microsecond scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f”, ulonglong2double(query_utime)/1000000.0); 1947 sprintf…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time… 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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table…_conversionsblogpercona.commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log_fileblogpercona…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3….000040 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning up….000033 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000004 | | freeing items | 0.000009 | | logging slow query | 0.000002 | | cleaning up…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and… time the queries and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log… “–type=tcpdump” option to mk-query-digest. You can even make it print out a “slow query log file” format with the “–print…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… execution time of queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can get with our Slow Query Log…
