…long_data to see whenever sending long…query execution, which size can be controlled by tmp_table_size and which also only exist for duration of query…0 TABLE_ROWS: 0 AVG_ROW_LENGTH: 0 DATA_LENGTH: 16384 INDEX_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL 3 rows in set (0…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… today – 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 some particular pages… mk-log-player and split all sessions that way, unfortunately mk-log-player will not have all the other useful information, not even query timing. Instead…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… you have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time=0, because if you set it to some other value say 0.1 seconds, it will miss all queries shorter than…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… you to 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… generate you query log and get back to unpatched version. It is best if you generate this log for all your queries with long_query_time=0 so if…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… treat long_query_time value as seconds. In effect one 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: 0.000048 Rows…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… is when you set long_query_time=1. After applying the patch you could see whether the time was 0.005s or 0.9s, which can… be 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 execute to…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… 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 MySQL server…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… similar to using mysql binary logs for point-in-time recovery after a restoring a… the total sales amounts are calculated (for all time) from a monthly summary. The monthly …long time to refresh: mysql> call flexviews.refresh( -> flexviews.get_id(‘demo’,'complete_example2′),’BOTH’,NULL); Query OK, 0…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…logging in the slow query log, and extended statistics in the same log. I logged a couple gigabytes of queries at 0-second threshold (all queries…Query_time: 0.304674 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # administrator command: Quit; Suddenly these queries…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… –long_query_time=n or by setting MySQL system variable with SET [SESSION|GLOBAL] long_query_time=n. The value is in microseconds (0 means to log all queries). The new feature is that patch can allow you to log queries executed…
