…. msl (microslow) patch was developed a few years ago to allow more precise logging of query execution times into the slow log. Originally MySQL… slow log you can set with patch applied. All filter-type options work in conjunction meaning that in order for query to be logged… to your slow log will be. Multiple flags allowed in a comma-separated string. [microtime, query_plan, innodb] msl patch currently can log three…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… need to be investigated Patching Slow Query Logging – First thing we did is created a Patch which allows you to specify slow query time in… 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…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… and also adds new. For the patch to work you must of course enable slow logging with –slow-query-log parameter. MySQL 5.1 has… redirect query log (it’s actually called general log now) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will not… for your logs to the plain old-fashioned files. In MySQL 5.1 it’s done by setting –log-slow-queries=slow.log and –log-output…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… the patch. The basic idea is the same as for its predecessor – to get more information about query execution logged into slow log, however… LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s SQL thread. This patch allows you to change that behavior with the new parameter –log-slow…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… as the improvements to the slow log output, and INDEX_STATISTICS). Despite having many requests to port these patches to 5.1, we… locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling info – Userstat patch Different patches to help…
Post: Microslow patch for 5.0.37
June 6, 2007 By 2 Comments
… short message that patch enables microsecond resolution in slow-log (see more http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/) for 5.0.37 is available here: www.mysqlperformanceblog.com/files/patches/patch.slow-micro.5.0.37.diff The patch…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…€™s microslow patch immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query… 20-25k queries per second. If all queries are logged – a slow log is populated at rate about 10MB/sec. This is… performance degradation caused by the microslow patch itself. Let’s do the same tests but logging to /dev/null. CPU-bound case…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a 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… use this feature as it is incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying… 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…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… 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… either by enabling the logging before starting the database instance or, even more work, by applying the patch and rebuilding the entire…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… time for some requests. What if some pages are still slow to load because of the time spent in database and… – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew… response time. I can also convert that into a slow query log that lists all the queries that were executed during this…
