… text’); 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…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 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… as this would allow to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
…-of-queries=1000000 –concurrency=64″ on my laptop) come out at the following: straight MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15 seconds straight Drizzle (no slow query log): 8 seconds So…
Post: Does Slow query log logs all slow queries ?
June 25, 2007 By 3 Comments
… 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 are not logged to slow query log…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… 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 Restoring long_query_time=60.000000 Restoring slow_query_log=1 Flushing logs…
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…
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 least 2 seconds. Percona actually extended the slow log to, among…
Post: MySQL Replication and Slow Queries
March 28, 2007 By 3 Comments
I just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a big… especially bad if you’re using tools to analyze slow query log to find what queries take up the most resources on your server…. One more thing to consider – slow replication queries also identify replication lag, ie if you have query which ran 10 seconds on the…
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…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
…}=\”$HOSTNAME\”" mysqld-slow-queries.log $HOSTNAME will reflect the current machine hostname. Replace $HOSTNAME with the necessary hostname if 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 multiple…
