On MySQL 5.5+ I would think its preferable to use FLUSH /*!50503 SLOW */ LOGS, rather than a general FLUSH LOGS which will touch a lot of other (likely more expensive) log files as well.
Comment: Solving INFORMATION_SCHEMA slowness
May 5, 2013 By 25 Comments
… logs: http://bugs.mysql.com/bug.php?id=19588 – reported fixed in MySQL 5.1.21 but many people reported I_S was slow. http://bugs.mysql.com/bug.php?id=56178 – reported fixed in MySQL…
Comment: MySQL Slow query log in the table
April 23, 2013 By 1 Comment
Hi Peter, how to implement your slow query logs patch on my server . i am using Mysql Database. Please guide me step by step. It would be thanks.
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 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_filter…
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… that you can’t gather on the server with the slow query log, such as information in the TCP protocol that isn… and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log format, so you…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query_log_timestamp_always in Percona…: pt-heartbeat handles timezones inconsistently. Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… number of CPU. With Percona Server, enabled full query logging and log_slow_verbosity=full you can also get great amount of related…
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 Restoring long…
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”, ulonglong2double…), ‘;’ ) 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: 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 … 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… forced for log table if it is allowed or if there is a buffer of slow log queries which is used if log table…
