purge_replication_log - Purges all the mysql replication log that are no longer in use.
On slaves:
purge_replication_log
On the master:
purge_replication_log --master
Mysql doesn't yet automatically purge obsolete replication logs, so we must do it. This job is run periodically on both the master and slaves; the slaves connect to the master database and make an entry in a table which holds the log file that they are currently using, and the master consults this table to decide which log files are safe to purge.
For safety, the purge job will refuse to purge the logs if there are slaves that are connected, but don't have entries. If slaves are neither connected, nor able to write any entries (for whatever reason), tough nuggies for them.
Except the master/slave toggle, all command line options refer to the master's database, whether or not the job is invoked on the master or the slave. They are '--host', '--database', '--port', '--password', '--user', '--driver'. Slave mode is the default, '--master' should be specified when appropriate.
Copyright (C) 2000 Joshua Spoerri for Wall Street Source, under the GNU GPL. purge_replication_log comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it under certain conditions; see the COPYING file for details.
$Id: purge_replication_log.html,v 1.1 2003/01/26 14:44:26 mdprewitt Exp $