b_peterson wrote:
> I just got replication working in a master/slave
> model. I notice on my master's database
> directory, it has a bunch of replication log
> files. Do these get auto-deleted by the server?
> Or are we supposed to manually go in and delete
> the old unneeded ones after time?
I am assuming you are talking about the binary logs on the master, and not the relay logs on the slave. By default, the binary logs stay around and are not deleted. This is done just in case you need to replay the binary log, or are needed for soem sort of backup scheme.
To find out which logs can be safely removed from the master, you need to issue a SHOW SLAVE STATUS command on the slave, and note the 'Master_Log_File' value. This shows the current log fiole the slave's I/O thread is reading. You can then use this value to safely remove the files from the master using the 'PURGE MASTER LOGS TO 'log_name' command, using the value from ther SHOW SLAVE STATUS command.
Partha Dutta
Senior Consultant, MySQL Inc.
http://www.mysql.com