OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: mysql-bin maintenance

edbergedberg-online.com
Date: Mon May 11 2009 - 21:15:50 CDT


On Mon, May 11, 2009 6:41 pm, Rilawich Ango wrote:
> Hi,
> In the master database, there are plenty of mysql-bin.X. It
> occupied almost all the disk space. As I know, the files should be removed
> by issuing reset master. Below are my questions. -Do I need to stop
> replication before issuing reset master? If yes, do I need to rebuild the
> replication after reset master? If no, does the existing replication
> broken after reset master? ango
>

See

   http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html

(or the relevant URL for your language/version). And you can use the
expire_logs_days system variable to have MySQL automatically purge old
logs.

   - steve

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql