….) First, we set long_query_time to 0 in order to log every query. (See part …-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log… applying the captured query traffic. This is an important step because update statements that …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Dimitri’s environment. To put a long story short, the results are fairly… non-trivial amount of updates to the database, all SELECT queries, even those participating…time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… written once long ago and not updated since. Now that we have four base versions of MySQL (5.0, … have a problem finding queries to run and compare. pt-query-digest is simpler pt-query-digest 2.2 … default, so specify –iterations or –run-time to limit how long they run. There are more changes in …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE …to run this experiment that long. So there we see the …mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time… thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option …commanual log_warningsblogpercona.commanual long_query_timeblogpercona.commanual low_….commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona…. unique_checksblogpercona.commanual updatable_views_with_limitblogpercona….
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time=0, … the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:….4% 89 0.0022 1.00 0.01 UPDATE wp_options # 7 0x7AEDF19FDD3A33F1 0.1381 1.7% …
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… any other query execution. So if you have transaction containing millions of simple updates instead of one large update to help MySQL replication lag… extremely complicated query. It is best to avoid INSERT … SELECT going through replication in 5.0 for many reasons (locking, long query time, waste…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… of months there have been no updates to our msl patch, however recently I managed some time to change this. The functionality… SET GLOBAL. long_query_time=# Log all queries that have taken more than long_query_time microseconds to execute to file. This option is standard MySQL, however after…
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… query log format as well. Update 2009-03-04: most of us at Percona now use mk-query-digest from Maatkit for slow query…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… which update queries take most time to execute. Unfortunately it did not work because Slave thread seems to have problems picking up long_query_time when… set global long_query_time=0 and restarting slave does not pick up the change. I of course could just restart MySQL but this…
