… in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log… log. – audit_whitelist_users : This one is undocumented on the wiki at the time of…”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… running queries. Disable MySQL slow logs during rotation Flushing logs takes time. Meanwhile, queries are still being executed. To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… long_query_time to 0 in order to log every query. (See part two for handling massive 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…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
I didn’t have time to answer all of the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest should work on… won’t be able to have access to the slow query log file, so pt-query-digest is often used with the –processlist option…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
…astrostl, the slow logs are disabled in the postrotate stanza. The order of operations is: 1. logrotate renames the log file. MySQL continues to… for buffered logs to be flushed (select sleep(2);) 2c. File handles are reopened (FLUSH LOGS 
2d. Slow logging resumed (set global long_query_time=@lqt…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…operation, and its tries and wait time between tries for all operations are …log now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query… analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was …
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 … -100 log-slow.log and now change it to SELECT * FROM slow_log ORDER BY start_time DESC LIMIT 100 you would find new queries coming to… forced for log table if it is allowed or if there is a buffer of slow log queries which is used if log table is…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…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…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… log file, it outputs 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…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query_time: 2.365434 Lock_time: 0.000000 Rows_sent…
