… variable use_global_long_query_time, which allows all current threads see change of long_query_time. By default value set in SET GLOBAL long_query_time=N command… on Rails application. With use_global_long_query_time=true even all current threads will respect SET GLOBAL long_query_time=N. The feature made for…) and sources with patches here http://www.percona.com/mysql/5.0.75-b12/
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… stable release version. Functionality Added or Changed  Percona Server 5.1.53-12.4 is based on MySQL…_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev) Bug #673567 – Compiler could produce… tests of options log_slow_slave_statements and use_global_long_query_time work only on statement-based replication. They were failing when…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… – 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… # Rows examine 1 4.97M 0 445.49k 9.80k 5.73k 49.33k 0 # Rows affecte 0 2 0 1… all the other useful information, not even query timing. Instead, I’ve used mk-query-digest: mk-query-digest –filter=’$event->{Thread_id} == 160847…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… could only choose to log all queries to see those which take less than 1s. Now long_query_time is in microseconds and you can set it for example to 300000 which is 0.3s! # Query_time: 0.503016 Lock_time… any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not work on other systems…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… pluggability, including pluggable authentication In addition to building on MySQL 5.5, here are the changes we’ve made from previous Percona… deleted. Bug fixed: #635399. (Yasufumi Kinoshita) Old variable use_global_long_query_time was deleted. (Oleg Tsarev) Bug fixed: #692415. Old variable innodb…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
… slow-query logging globally without restarting, similar to –use_global_long_query_time. Added the –query_cache_strip_comments option to strip comments from query before using it in query cache. Added a… 11 fails to compile with CFLAGS=-DUNIV_DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL-server #589639 Recovery process may…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… in MySQL 5.0 and below ? Use Our Patch – With this patch you can get all queries logged as slow queries (with times) and as you can change long-query-time online you can effectively enable and disable debug logging live. Note however this is not 100% equivalent for general query…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… –log (or –general-log in MySQL 5.1+) start-up parameter. The log writes any query being executed by MySQL to a… the slow log to, among others, include any query regardless of the execution time. The problem is that for both you need… simply setting long_query_time MySQL variable vale high enough). So what can be done when you really need to see the queries, but…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…may not be suitable for your environment. (garfield:~/work/mysql-5.0.51a) % ./configure ‘–disable-shared’ ‘–with-server-suffix=-community’ ‘–…changed at run time with both SET SESSION and SET GLOBAL. long_query_time=# Log all queries that have taken more than long_query_time microseconds to …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… list of queries which load replication the most. It however works only with statement level replication. You need to set long_query_time=0 and log_slave_slow_statements=1 for this method to work. Get the log file which will include all queries… about it too). First I would measure replication capacity on 5 minute intervals (or something similar) because it tends to vary…
