… size, new binary log is created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex is held for the duration of the binary log removal…
Comment: Troubleshooting Relay Log Corruption in MySQL
October 19, 2012 By 7 Comments
… useful information in my scenerio. If you expire your binary logs after X amount of days (expire_logs_days=X) on your Master server and your Slave replication gets hung up on a Relay_Master_Log… been expired. You can use: Change MASTER to RELAY_LOG_FILE = ‘Relay_Log_File’, RELAY_LOG_POS = ‘Relay_Log_Pos’; to use the Relay logs which…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs after in X days…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid log-error = /db/mysql.err log-slow-queries = /db/slow-queries.log log-bin = /db-logs/bin-logs/mysql-logs/mysql-bin expire_logs_days = 30 # Expire logs after in X days…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… [Server] server-id = 1 log-bin=/data/mysql/drbd [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock [Server] server-id = 1 log-bin=/data/mysql/drbd expire_logs_days…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual error_countblogpercona.commanual event_schedulerblogpercona.commanual exit_infoblogpercona.commanual expire_logs_daysblogpercona.commanual external_lockingblogpercona.commanual external_userblogpercona.commanual federatedblogpercona.commanual….commanual log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log_queries…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query…=6M key_buffer_size=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… practice it is MyISAM related. expire_logs_days This is replication/binlogging related options – when to delete binary logs from master. It does not affect Innodb and other storage engines transaction logs, slow query log or general log. flush, flush_time Flushing (closing) of tables after…
Post: Announcing Percona Server 5.5.27-29.0
October 11, 2012 By Leave a Comment
… in progress. Bug fixed #686534 (George Ormond Lorch III). Option expire_logs_days was broken by group_commit patch introduced in Percona Server… Smith). Flashcache support resulted in confusing messages in the error log on Percona Server startup even when flashcache was not used…
Comment: Binary log file size matters (sometimes)
May 29, 2012 By 6 Comments
but is faster rotating few huge (1G) files OR many small (50M) files? for example, when max_binlog_size = 1G and expire_logs_days=14 we have 200 files. With 100M it’s 2000 files and 50M => 4000 files. It could be slow to. it’s question of benchmark.
