… prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log rotation….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: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6….” sleep $RESPAWN done Configuration file: MBL=/opt/mysql5.6/usr/bin/mysqlbinlog MYSQLHOST=10.10.10.10 MYSQLPORT=3306 MYSQLUSER=replication…>&1 > /var/log/livebinlog/server2.log & As a great addition, older logfiles that have been rotated can be checked against the MySQL server’s…
Post: Win a free ticket to RailsConf!
May 15, 2011 By 10 Comments
…/lib/mysql/mysqld.log { create 600 mysql mysql notifempty daily rotate 3 missingok compress postrotate # just if mysqld is really running if test -x /usr/bin/mysqladmin && /usr/bin…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… such effect just by enabling log_bin. Innodb tables also have to flush logs on transaction commit unless you …their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group …but it is only part of the latency. Disk rotation is another big contibutor. Even if we stay …
