2009/11/02

how to purge master logs

> on master:    mysql -p

> 

> mysql >  show master status;

> 

> 

> on slave:   mysql -p

> 

> mysql > show slave status;

> 

> 

> If both master and slave are processing the same replication log file

> (meaning that replication is running correctly),  then you can safely

> run the following commend on master:

> 

> 

> mysql > purge master logs to "current-replication-log-filename";

 

No comments:

Post a Comment