… 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 33 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: 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…
Post: Win a free ticket to RailsConf!
May 15, 2011 By 10 Comments
… setting the variable “err-log” # in the [safe_mysqld] section as follows: # # [safe_mysqld] # err-log=/var/lib/mysql/mysqld.log # # If the root… be readable ONLY # for root ! /var/lib/mysql/mysqld.log { create 600 mysql mysql notifempty daily rotate 3 missingok compress postrotate # just if mysqld is…
Comment: How to calculate a good InnoDB log file size
November 23, 2008 By 33 Comments
… fairly easy to have monitoring mark when a file was rotated, so I can have it figured out automatedly. Then again… for a MySQL Monitoring system, whether it’s the Enterprise offering from Sun, or a cacti monitoring thing (frequency of log rotation) or…
Comment: Be careful rotating MySQL logs
December 10, 2007 By 5 Comments
… to make sure you use the logs. Why are you logging, if not to use the logs? If you need or want them… should be archived to another server. Certainly log rotation should be considered when logs are enabled — and not just for MySQL, but for any log.
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
…years back. We wrote about it, other people from MySQL Community too. The situation did not get better, …to do something such as getting Slave out of rotation when it is going through the process. Second. … may get out of sync with Innodb transaction logs. I’m also wondering if this is something …
Post: Benchmarking Galera replication overhead
October 13, 2011 By 12 Comments
… – result using 2 nodes under regular MySQL replication semisync – result using 2 nodes with semisync MySQL replication And now go to results…: You see quite periodic drops for MySQL replication, I think it is related to binary logs rotation And, second, much more serious problem: After 1800 sec of run, slave in regular MySQL replication was behind…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… often than it used to when all we had were rotating hard disk drives. I think the reason is very simple… that page size is no bigger than stripe element; second – logs are actually written in 512 byte units (in Percona Server…
