… slow logs with long_query_time set to 0. Here are a some lessons we learned when logging a high volume of queries to the…_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/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=@lqt_save…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… discarded designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling massive slow…-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
….53% 1338484 mysqld mysqld [.] ut_delay(unsigned long) So basically most of the time 5.6.11 spent in LRU_scan. I… sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…to Dimitri’s environment. To put a long story short, the results are fairly …queries: select avg(id) from sbtest$i force key (primary) select count(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0…-type=uniform –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… once long ago and not updated since. Now that we have four base versions of MySQL (5.0, …t have a problem finding queries to run and compare. pt-query-digest is simpler pt-query-digest 2.2 …by 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
… on this SSD to run this experiment that long. So there we see the strong side of TokuDB… –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads=32 –rand-type=…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 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
… 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… 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 serious portion of you load comes from very simple queries you would not lose…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… – 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… # Hosts localhost # InnoDB trxID 1153145C (2/0%), 11531626 (2/0%)… 43 more # Last errno 0 # Users prod # Query_time distribution # 1us # 10us ################################################################ # 100us ######### # 1ms # # 10ms…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… Discovering 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 log…
