… learned when logging a high volume of queries to the slow log. Do not use copytruncate Logrotate offers two techniques for log rotation (your log rotation scheme likely… during log rotation. Putting it all together Here is a logrotate configuration file for a slow log that illustrates these best practices: /var/mysql/slow_query.log…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…follow the log stream across log rotation events. On the standby server, the logs are replayed with Percona Playback by streaming the slow log from …is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a…
Comment: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…Joshua, writing every query to disk can be very expensive. At Groupon, we write slow logs to a different disk array on our… the slow log rate limiting feature in Percona Server — http://www.percona.com/doc/percona-server/5.5/diagnostics/slow_extended_55.html. Rotating the large slow logs requires some special consideration. We will cover…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
…I used their tbb::atomic<> implementation. My solution to log file rotation is to basically count how many people may be …MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15 seconds straight Drizzle (no slow query log): 8 seconds So…
Comment: A (prototype) lower impact slow query log
September 28, 2012 By 12 Comments
… has just set log_fd to -1. I’d probably place the call to ensure_log_file_open() of extended_slow_query_log_notify() at line 64, inside write_to_log() nr_thds_using_fd… why someone would make a extended_slow_query_log.log.1 -> (somewhere/lese to change the folder of the rotated query log file (they couldn’t move…
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
If you enable logging of all queries as “slow queries” using the patch or MySQL 5.1 you can get log file to grow huge. Same may happen with general log… the log file you no more need. It can be also good idea to hook up log rotate to take care of MySQL logs…
Comment: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
… much about the Information Schema. We just added support to rotate the slow query log. And we are trying to add SHOW CLIENT_STATISTICS…
