Re: MySQL binlog problem

Hi.

24Apr2006 @ 08:52 Rod Smart thusly spake
>    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?

You can delete old ones. 
I don't keep binlogs older than a month.
Since my database gets backed up every night I could probably get rid of a lot
more.
You could setup a cron job to delete those.
IIRC they are only needed to rebuild after an emergency.
If you're not sure, put a bunch of them in a different directory, then, if you
can, restart the server and you'll see that they aren't used.


HTH.

Kind regards.


> 
> -- 
> 
> 	Rod Smart
> 	Technical Specialist
> 
> 	Rohwedder Pty. Ltd.
> 	53-55 Rocco Drive
> 	Scoresby 3179
> 	Victoria Australia
> 
> 	Tel: +61 (0)3 9763 6455
> 	Fax: +61 (0)3 9763 7043
> 
> 	URL: http://www.rohwedder.com.au
> 
> PLEASE NOTE:
> This e-mail and its content is not legally binding as long as not
> explicitly confirmed in writing by Rohwedder Pty Ltd.
> The information contained is confidential and intended for the
> exclusive use by the addressee designated above. If you have received
> this message by mistake, please contact us immediately.
> 
> 
> _______________________________________________
> Melbourne Linux Users Group (Australia)
> Edit your settings: http://lists.mlug.org.au

-- 
............._..
.|  .| |.|/.|_ .
.|__.|_|.|\.|_ .
:61 421 276 282: