Re: MySQL binlog problem

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