ner [mailto:[EMAIL PROTECTED]
>Sent: 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 vi
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 rotation.
For transactions, it never causes rotation instead it writes t
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
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 quic
