… version of MySQL. The microslow patch adds a very useful feature, the ability to log queries by execution plan. log_slow_filter=name Log only the… the filter to an empty string to stop collection. SET GLOBAL log_slow_filter:=”"; Then it was just a question of examining the slow query log…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log options. This… you cannot change at runtime from MySQL console wit SET or SET GLOBAL command. log_slow_filter=name Log only the queries that followed certain…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… log_slow_verbosity. Actually, this is a very simple and straightforward tool to browse slow …for visualizing collected data from the MySQL Slow Query Log. The name comes from the…filtering on first seen date; * custom reports, choosing which columns to show; * filtering queries by hosts; * filtering…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you … filter out queries which you already looked at using LIKE statement. As default table format for slow_log …the log file. If you used to do tail -100 log-slow.log and now change it to SELECT * FROM slow_log…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… MySQL to a file with limited amount of additional information. The other is slow log enabled by –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store… take a peek into a network stream and filter for packets that go to MySQL. Those packets contain queries. Here’s my…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… really large log file generated. Another thing that we normally do is set the variable log_slow_verbosity to ‘…using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229… query, by using a LIMIT clause or by filtering based on the option_name column, or you…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…. Slow logs which include timestamps but no query–which can happen if using slow_query_log…check-only. When using –replicate-check-only, filter options like –databases and –tables were …timezones inconsistently. Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…the application by aggregating query log with mk-query-digest. When I filtered out only queries of …_page_hash_index,btr_search_info_update_slow,btr_search_info_update,btr_cur_search_…do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most…-digest (Percona Server marks Slave Thread in slow query log so it is easy to filter out events) so you can see whenever…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… 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… 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 -T…
