…discarded designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling massive…3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set to 0. Here are a some lessons …/bin/mysql -e ‘select @@global.long_query_time into @lqt_save; set global long_query_time=2000; select sleep(2); FLUSH LOGS; select sleep(2); set global long_query_time=@…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set …once long ago and not updated since. Now that we have four base versions of MySQL (5.0, 5….have a problem finding queries to run and compare. pt-query-digest is simpler pt-query-digest 2….
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… this experiment that long. So there we see…mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0…cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word…TokuDB comes with good settings out-of-box, …
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, because if you set it to some other value say 0… were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… 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 adapted version of patch by Georg Richter which was made to run with recent MySQL…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… slow_query_log=1 Discovering slow_query_log_file=mysql-slow.log Discovering long_query_time=60.000000 Setting long_query_time=0 Setting slow_query_log_file=mysql-slow.log-full-20121122112413 Setting slow_query_log=1 Flushing slow query…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…query logging (with long_query_time = 0) for some time during peak load. Then you can use pt-query-digest to analyze the queries…a single-byte character set (5 to 7 …query writing and wanted to learn MySQL administration suggest any book or practices. Of course I’m biased but High Performance MySQL…
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 MySQL…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… 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…mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-file=slow.log Executed 429467 queries Spent 00:00:59.668649 executing queries…
