MySQL binlog problem

    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?

-- 

	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.