… 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: Be careful rotating MySQL logs
December 16, 2007 By 5 Comments
[...] from：http://www.mysqlperformanceblog.com/2007/12/09/be-careful-rotating-mysql-logs/ [...]
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…
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 …
Comment: Tools
July 17, 2008 By 31 Comments
I developed a Perl package to help with managing groups of MySQL servers; hopefully others will find it useful. Current components monitor replication, rotate binary logs, and allow execution of commands on groups of servers from a central server. http://forge.mysql.com/wiki/ProjectPage_MyCAT
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…
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: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…IO bound or CPU bound, while to understand if MySQL goes through more rows than it needs to …needs to do is to flush transactional log. In case innodb_flush_log_at_trx_commit=1 (default) this …15K RPM Hard Drive it does 250 rotations per second (4ms per rotation) which gives us 2ms of average latency …
