…logs with long_query_time set to 0. Here are a some lessons we learned when logging a high volume of queries to the slow log…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: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…, we set long_query_time to 0 in order to log every query. (See part two for handling massive slow log volume.) The slow logs are served, via…-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool… difference between the IO usage is 2 orders of magnitude. All graphs looked like this (we did 39 measurements), the next…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… its tries and wait time between tries for all operations are configurable. …long ago and not updated since. Now that we have four base versions of MySQL (5.0… query logs. So the ability to parse memcached, Postgres, Apache, and other logs… –iterations or –run-time to limit how long they run. There …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…long story short, the results are fairly consistent with our original post across all… updates to the database, all SELECT queries, even those participating in…_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group …–forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…run this experiment that long. So there we see …on –max-time=18000 –report-interval=10 –max-requests=0 –num-…log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_…_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_…TokuDB-related options are all defaults, as I understand…
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: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
…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…
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 84 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…
