Thanks Dan. According to the docs, the "BEFORE" option was introduced in 4.1.
I just tried the purge with the "to" option : PURGE MASTER LOGS TO 'db1-bin.002'; Query OK, 0 rows affected (0.01 sec) so I think I will just purge a couple log files at a time until I can get the disk space down to a more manageable capacity. The previous DBA had told me that the last time he purged the logs, it took it several minutes - but I can only assume he tried to purge too much at once. Thanks again! -- George >-----Original Message----- >From: Dan Buettner [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 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 quick command to run, generally a fraction of a second. >Since you have 132 files it might be a few seconds but I would not >expect longer than that. > >I don't know whether MySQL willl go back and delete the old logs if >you set that variable and restart - presumably it would, but not >certain. > >Dan > > > >On 10/18/06, George Law <[EMAIL PROTECTED]> wrote: >> 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 32768 >> log_bin ON >> max_binlog_cache_size 4294967295 >> max_binlog_size 1073741824 >> >> >> # echo "show status" | sql |grep bin >> Com_show_binlog_events 0 >> Com_show_binlogs 9 >> >> Right now, I have 132 bin-logs, each at 1 GB. the logs go back to >> 2/11/2006 >> >> If I were to add 'expire_logs_days 45' to my.cnf and restart >mysql, is >> mysql going to attempt to purge the logs >> > 45 days old and if so... how long does it typically take. >We cannot >> afford to restart if its going to take >> any significant amount of time for it to purge the logs and restart. >> >> thanks! >> >> >> George Law >> [EMAIL PROTECTED] >> MSN: [EMAIL PROTECTED] >> Phone: 864-678-3161 >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >http://lists.mysql.com/[EMAIL PROTECTED] >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
