Here's another way to do it which works well with multiple slaves: http://mtop.sourceforge.net/utils/purge_replication_log
This script is run on the slave and the master. When run on the slave it updates a table in the master which keeps track of the log position for each slave. When run on the master, it finds the oldest logfile being used and purges up to that one. Danny Haworth wrote: > > I too would be interested in a good way of clearing the binary log files > (preferably non disruptive to the server ;-) > The only thing thats saving me so far is that the systems capacity is 320Gb. > > danny > > Anirudha Kukreti wrote: > > >hi all > >i have established a two way replication setup > >my problem is that my hard disk gets occupied by the log files; > >i tried purging the files but after some time again my hard disk gets filled > >with the log files > > > > > >mysql, queries > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
