… slightly more complicated. To manage this process, we use a tool co-developed with Percona. “Warm standby server”? Did you catch… 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…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… the questions during Wednesday’s MySQL webinar, “5 Percona Toolkit Tools That Could Save Your Day,” but as promised, here are… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest should…, you won’t be able to have access to the slow query log file, so pt-query-digest is often used with…
Comment: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
Hi, Martin, Andrew, you are right on these. You can also use SET GLOBAL slow_query_log = on|off to turn slow log on and off, like Bill does in his tool here. http://www.mysqlperformanceblog.com/2012/11/22/get-me-some-query-logs/
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… pt-upgrade a try. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t have… have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the…-time, –interval, –iterations) standard. If you hadn’t noticed, one tool would run forever by default, while the other would run…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… 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… 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… it. So we came op with slow query log parser tool which works with adjusted slow query log format and which gives samples of queries…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
…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 … I have written). See https://github.com/billkarwin/bk-tools I hope you find this script a useful complement …
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… floating-point numerics to microsecond scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f… to the log table, query times and lock times are truncated to to integers: sql/log.cc, Log_to_csv_event_handler::log_slow(): 610…), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in my bk-tools github project. It’s called export-slow-log-table…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… query historic stats, support for log_slow_verbosity. Actually, this is a very simple and straightforward tool to browse slow queries. The web interface… Toolkit to do the slow query log collection. Specifically you can run pt-query-digest. To parse your slow logs and insert them into a database for reporting. Personally, I find this tool as an advanced instrument…
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… this feature as it is incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying 100… come in the log file. If you used to do tail -100 log-slow.log and now change it to SELECT * FROM slow_log ORDER BY…
Comment: Get Me Some Query Logs!
December 31, 2012 By 14 Comments
… to the full-slow-log tool to support: – Query logging options in Percona Server and MariaDB. – Gentler log redirection, without doing FLUSH LOGS. – New “-f file” option to specify the location of the redirected slow-query log. I’ll…
