… MySQL slow logs temporarily 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 { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…the log stream across log rotation events. On the standby server, the logs are replayed with Percona Playback by streaming the slow log …server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… their tbb::atomic<> implementation. My solution to log file rotation is to basically count how many people may …following: straight 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): …
Comment: A (prototype) lower impact slow query log
September 28, 2012 By 12 Comments
… 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… no file rotation would be taking place at all). However, the log folder needs to be only writable by mysql to prevent the…
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 so…
Comment: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
… a MySQL 4.0 mindset and don’t know much about the Information Schema. We just added support to rotate the slow query log. And…
