From: Nitin Mehta Date: May 3 2012 11:19am Subject: Re: master BIN-LOG maintenace List-Archive: http://lists.mysql.com/mysql/227306 Message-Id: <1336043986.38862.YahooMailNeo@web161601.mail.bf1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-83809723-6582678-1336043986=:38862" ---83809723-6582678-1336043986=:38862 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi Charles,=0A=C2=A0=0AI guess your application doesn't generate too much o= f binary logs. The parameter "expire-logs-days" kicks in at the flush but d= oes not necessarily require a manual "flush logs" command. You can reduce t= he value of "max_binlog_size" to make sure that at least one new file is cr= eated daily and this will force mysql to check and delete old bin-logs. The= default (and maximum) value for this variable is 1G. If I'm not wrong, it = is a dynamic variable, which means you can try different values without a r= estart of the database until you find a suitable one.=0A=C2=A0=0AHope that = helps!=0A=C2=A0=0ARegards,=0A =0A=0A________________________________=0A Fro= m: "Brown, Charles" =0ATo: Nitin Mehta = =0ACc: "mysql@stripped" =0ASent: Thursday, M= ay 3, 2012 4:24 PM=0ASubject: master BIN-LOG maintenace=0A =0AHi=C2=A0 Gur= us,=0A=0AI would like to set BIN-LOG maintenance procedure for my master. T= he master is on a windows platform. I=E2=80=99m all for make it simple and = clean therefore I=E2=80=99ve been leaning toward=C2=A0 the automatic BIN-L= OG removal =E2=80=9Cexpire-logs-days=3D7=E2=80=9D. The problem is for this = option to work, it should be preceded by a =E2=80=9CBIN-LOG FLUSH=E2=80=9D = command. Okay, where do I go from here in order to make this work. Please h= elp me.=0A=0AThanks=0A=0A=0A********************************************=0A= This message is intended only for the use of the Addressee and=0Amay contai= n information that is PRIVILEGED and CONFIDENTIAL.=0A=0AIf you are not the = intended recipient, you are hereby notified=0Athat any dissemination of thi= s communication is strictly prohibited.=0A=0AIf you have received this comm= unication in error, please erase=0Aall copies of the message and its attach= ments and notify us=0Aimmediately.=0A=0AThank you.=0A**********************= ********************** ---83809723-6582678-1336043986=:38862--