From: Michael Dykman Date: November 14 2011 6:12pm Subject: Re: Cleaning up old files List-Archive: http://lists.mysql.com/mysql/226297 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Those are your binary logs. =A0They store the data stream to be consumed by your slaves. .http://dev.mysql.com/doc/refman/5.0/en/binary-log.html Are you using replication? =A0If so, you need to go to each of your slaves and run the command 'SHOW MASTER STATUS;'. That will tell you which files are currently being consumed by your slaves. Anything older than the oldest one can be safely deleted.=A0 (the older ones are those with the lowest numbers embedded in the filename. If you are not using replication, erase them all. You might also want to turn of 'log-bin' in your configs. - michael dykman On Mon, Nov 14, 2011 at 1:01 PM, Rob Tanner wrote: > > Hi, > > In my MySQL directory, I have more than a few gig and a half sized files,= mysql-bin.000001, mysql-bin.000001 and et cetera. =A0They date from today = all the way back to early 2010. =A0I don't know exactly what those files ar= e but I would like to delete as many as are no longer is use since I had a = 40GB partition fill up over the weekend which resulted in bringing down our= web server. =A0So what are those files and can I delete all but the most r= ecent? > > Thanks. > > > Rob Tanner > UNIX Services Manager > Linfield College, McMinnville Oregon > -- =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.