… discarded designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling massive… –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… were changed significantly (e.g. pt-query-digest, pt-upgrade, and pt-online-schema-change). Here are some highlights: Official support for MySQL 5… default, so specify –iterations or –run-time to limit how long they run. There are more changes in addition to those highlights. For…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… specify slow query time in microseconds rather than seconds and allows you to log all queries in slow query log by setting long_query_time=0 This patch is adapted version of patch by Georg Richter which was made to run with recent MySQL version… the time. Happily you can change long_query_time without restarting server so it is easy to get sample of all queries for some period of time…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option ….commanual Com_change_dbblogpercona.commanual Com_change_masterblogpercona….commanual log_warningsblogpercona.commanual long_query_timeblogpercona.commanual low_….commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona….
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: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… you are planning to upgrade or make any configuration change on your MySQL database the first advice usually is: – Benchmark! How should… the peak time to get valuable information: SET GLOBAL slow_query_log=1; SET GLOBAL long_query_time=0; With long_query_time we are logging all queries that…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… up long_query_time when it is set online, meaning changing it via set global long_query_time=0 and restarting slave does not pick up the change. I of course could just restart MySQL but…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… have a lot of extra calls checking various server changes which typically never change). We can also see Server prepared statements were… log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_data_file_path = ibdata1…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…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: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… examine only those rows related to the ones which changed since the last time the view was refreshed. The incremental refresh method… method takes a very long time to refresh: mysql> call flexviews.refresh( -> flexviews.get_id(‘demo’,'complete_example2′),’BOTH’,NULL); Query OK, 0 rows…
