… a rotation has not occurred, that is to say that the ls -l approach is misleading. Sample: # ls -l /var/lib/mysql… CDT 2013 Log sequence number 17750417191 Tue May 21 22:24:15 CDT 2013 Log sequence number 17750981011 -rw-rw—- 1 mysql mysql 536870912 May 21 22:24 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… still being executed. To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log rotation. Putting it all together Here is a logrotate configuration file for a slow log…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to 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…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
“To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log rotation.” Wouldn’t that be in the prerotate section? I don’t see one in the stanza provided.
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
… reopened MySQL will be practically unavailable causing unanticipated downtime. The workaround for this problem is very simple – instead of deleting MySQL log file – rename it, call “FLUSH LOGS” which will be instant as it will not… 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…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6…>&1 > /var/log/livebinlog/server2.log & As a great addition, older logfiles that have been rotated can be checked against the MySQL server’s…
Comment: How to calculate a good InnoDB log file size
November 23, 2008 By 38 Comments
… in such depth — I usually just log on to the system and see how often the log rotates — for instance, just now here’s a sample from a production machine: /var/lib/mysql> ls -lrth ib… 1 hour and the log rotates approximately every 2 hours, I probably don’t want to cut the log file size in 1…
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 using… 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…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… put on and off rotation without and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have… about – each slave can be at different coordinates in binary log compared to masters. There can be some events which are… queing event in relay log. Now lets see how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster are different…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…. Two logs are synced now which requires seeks which make certain disks to flush their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group commit which… seeks but it is only part of the latency. Disk rotation is another big contibutor. Even if we stay on the…
