… point-in-time recovery. Generally if you’re considering the binary log filtering approach, I think it’s safer to set up…. For example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST that might be a… and PRM simply attempt to connect and run a simple query, but it’s always possible to build something more involved…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… about discarded designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling massive…-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… 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… -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;’ endscript…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
… 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;)
Comment: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… is if you are using persistent-connections. The global variable long_query_time is checked when the connection is created, so if you… Percona Server feature to solve this issue. You can set the “slow_query_log_use_global_control” in 5.5 or “use… in 1 and the server will use the global variable long_query_time instead the local one. PS 5.1 http://www.percona…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… 5.5) for metadata locks. Now –set-vars is used to set both of these (or any) system variables…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
…SSD to run this experiment that long. So there we see the strong…sec checkpoint interval, as TokuDB does time-based checkpoints. These drops are quite…4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word… from documentation TokuDB comes with good settings out-of-box, but I …
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… 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 Sleeping…
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… time. Happily you can change long_query_time without restarting server so it is easy to get sample of all queries for some period of time…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store poorly performing queries that run at… the slow log to, among others, include any query regardless of the execution time. The problem is that for both you need… by simply setting long_query_time MySQL variable vale high enough). So what can be done when you really need to see the queries, but…
