… 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 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…
Comment: Be careful rotating MySQL logs
December 10, 2007 By 7 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: 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 …
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 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: Be careful rotating MySQL logs
December 16, 2007 By 7 Comments
[...] from：http://www.mysqlperformanceblog.com/2007/12/09/be-careful-rotating-mysql-logs/ [...]
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: A (prototype) lower impact slow query log
September 28, 2012 By 12 Comments
…_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…
