…_using_fd but is using the old log_fd (thus switching log_fd before that). log_fd= -1; should also be atomic, although… 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: 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: Be careful rotating MySQL logs
September 27, 2012 By 7 Comments
… page which may suggest that a MV and HUP will rotate the logs safely, without incurring a huge delay or requiring the extra setup the issue of the FLUSH LOGS command may require. The referenced page isn’t reachable right… use as well. http://blesseddlo.wordpress.com/2011/04/15/mysql-logs-filling-up-var/ ( –> http://dev.gigigo.tw/index.php?option…
Post: Announcing Percona Server 5.5.27-29.0
October 11, 2012 By Leave a Comment
… Ormond Lorch III). The binlog shouldn’t be rotated while it contains XA transactions in the …support resulted in confusing messages in the error log on Percona Server startup even when flashcache… maximum number of indexes per table. Upstream MySQL bugs: #54127, #61178, #61179 and #61180. Bug fixed …
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 18 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 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: 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 …
Comment: How to calculate a good InnoDB log file size
November 23, 2008 By 38 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…
