Re: MySQL binlog problem

David wrote:

> Rod Smart wrote:
>
>>    Hello all.
>>
>>    I have MySQL 5.x running and I have a binlog problem.
>>
>>    1st I had the problem of the individual file size eating up my 
>> system HD space until I found the following command.
>>
>> max_binlog_size                 = 10M
>>
>>    Ok, now the binlog filesize gets to approx 10M, and it starts a 
>> new binlog file.
>>
>>    Good, but also bad, there is no limiting I have found on the 
>> number of binlog files created, with 1.2G available on /var, I am 
>> getting enough 10M binlog files to take this to about 100% and 
>> crashing MySQL.
>>
>>    Does anyone know how to limit the count of binlog files?
>>
>
> Hi Rod,
>
> You need to use PURGE MASTER LOGS to accomplish this as there isn't a 
> configuration parameter which you can set.
>
> <http://dev.mysql.com/doc/refman/4.1/en/purge-master-logs.html>
>
> HIH
>
> David
>
> _______________________________________________
> Melbourne Linux Users Group (Australia)
> Edit your settings: http://lists.mlug.org.au
>
>
    Yes, thank you, this is exactly what I am after.

    I am using MySQL with DSPAM for ridding SPAM from the company 
E-mails, and MySQL was logging heaps..

    Hmm, I had better check my home server too, ~33% of my home E-mail 
is SPAM (>27,000 spam since 24/11/05)