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: 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: 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: 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: 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: 5.0.77 / 5.0.82 -build16 Percona binaries
June 11, 2009 By 4 Comments
…. Since that time new patches were added: profiling_slow.patch This patch adds information from SHOW PROFILE to query information in slow.log output. profiling… information about all rollback segments innodb_thread_concurrency_timer_based.patch This patch provides the configuration variable backport from MySQL 5.4…
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…
