… for point-in-time recovery. Generally if you’re considering the binary log filtering approach, I think it’s safer to set up… long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL… in AWS, got the volume mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling…mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…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
… (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both …or –run-time to limit how long they run. There are more changes in addition to those…query-digest –output json format in future releases after receiving real-world feedback. In summary, Percona Toolkit 2.2 for MySQL…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
… logs are disabled in the postrotate stanza. The order of operations is: 1. logrotate renames the log file. MySQL continues to write… runs the postrotate stanza 2a. Slow logging is paused (set global long_query_time=2000;) 2b. There is a small wait for buffered logs…. File handles are reopened (FLUSH LOGS;) 2d. Slow logging resumed (set global long_query_time=@lqt_save;)
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… which should produce updates in-place (I will use …run 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…cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft… TokuDB comes with good settings out-of-box, …
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… new DROP Table in MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in MySQL < 5.5.23... benchmark, all the queries were captured in the slow log by setting long_query_time to 0. Then for analysis purposes the queries in the slow log were… dips in QPS are not as low or as pronounced as compared to MySQL. Conclusion The new DROP TABLE related fixes in MySQL >= 5…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Metadata Locking related changes that were introduced in MySQL 5.5.3. It appears that the … the table it has accessed for as long as the transaction is open. Since an … 17 rows in set (0.00 sec) And you can see how the query spent nearly all its time waiting in the…
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… MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query_time…
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… to my upcoming talks at the Percona Live MySQL Conference in London, UK on December 3-4 2012: …
