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
… really slow queries but to really optimize application throughput queries which generate most of the load 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… log all queries in slow query log by setting long_query_time=0 This patch is adapted version of patch by Georg Richter…
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 for 5.0.41 : www.mysqlperformanceblog.com/files/patches/patch.slow-micro.5.0…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… (microslow) patch was developed a few years ago to allow more precise logging of query execution times into the slow log. Originally…. Configuration There are several parameters related to slow log you can set with patch applied. All filter-type options work in conjunction… to your slow log will be. Multiple flags allowed in a comma-separated string. [microtime, query_plan, innodb] msl patch currently can…
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… 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-slave-statements. THE DETAILED…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
…. Because MySQL went through a lot of internal changes, the patch had to be written from scratch. It introduces some minor… and also adds new. For the patch to work you must of course enable slow logging with –slow-query-log parameter. MySQL 5… general log now) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will not work as…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… 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 with day to day usage of MySQL ® Two new features which not available for 5.0: In slow…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… without Binaries. This version also does not have any community patches yet, coming of the same tree as MySQL Enterprise. To… our microslow patch, which enables microsecound in slow-log. More info about the patch http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log…-microslow binaries. Source tar.gz with microslow patch (Link removed) The patch by itself 18K patch.slow-micro.5.0.33.diff We are…
Post: Finding what Created_tmp_disk_tables with log_slow_filter
September 22, 2008 By 3 Comments
… Percona patched version of MySQL. The microslow patch adds a very useful feature, the ability to log queries by execution plan. log_slow… on-disk temporary storage for intermediate results. SET GLOBAL log_slow_filter:= “tmp_table_on_disk,filesort_on_diskâ€; Wait…_slow_filter:=”"; Then it was just a question of examining the slow query log and fixing the queries. More information about the patches…
Post: New patches, new builds
September 5, 2008 By 24 Comments
… | | microslow_innodb.patch | Extended statistics in slow.log | 1.0 | Percona | GPL | | | split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to fix…_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability control_io-threads.patch | InnoDB patch to control count of IO…
