@lists.mysql.com
Sent: Thursday, October 19, 2006 12:16 AM
Subject: bin-log with expire_logs_days
Hi All,
I have a **high traffic** mysql 4.0.18-standard-log server running with
bin-logging enabled.
Right now, this must be using a default setting for expire_log_days. I
do not see this anyway in
show
: Thursday, October 19, 2006 4:00 PM
Subject: Re: bin-log with expire_logs_days
Hi,
The system variable expire_logs_days removes the binary logs
automatically after the given number of days. The default is 0, which
means no automatic removal. Possible removals happen at startup and at
binary log
: Wednesday, October 18, 2006 3:28 PM
To: George Law
Cc: mysql@lists.mysql.com
Subject: Re: bin-log with expire_logs_days
I haven't used the server variable you refer to, but instead have
always used an external command piped in via cron - PURGE BINARY LOGS
BEFORE date
and I just use a DATE_SUB function
Hi All,
I have a **high traffic** mysql 4.0.18-standard-log server running with
bin-logging enabled.
Right now, this must be using a default setting for expire_log_days. I
do not see this anyway in
show variables or show status
$ echo show variables | sql |grep bin
binlog_cache_size
I haven't used the server variable you refer to, but instead have
always used an external command piped in via cron - PURGE BINARY LOGS
BEFORE date
and I just use a DATE_SUB function to subtract X days from today's date.
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
It's a pretty