Re: relay-bin files not being cleaned up
Rick,
The log files are being purged now. I noticed that the binary log listed in relay-bin.info was not available, so I modified the PURGE BINARY LOGS to keep 10 days of log files. There are now just 2 relay-bin log files, both with today's date.
I was going to say that it seems the slave needs the binary log listed in the relay-log.info file, but that doesn't seem right. Relay-log.info lists mysql-bin.000048, and oldest file is mysql-bin.000058. Newest file is mysql-bin.000074. Perhaps the binary log value in the relay-log.info is stuck from when it was not available when I first noticed it.
Thanks for the help, it got me looking around to notice the strangeness of the relay-bin file entries.
So, I guess you need to keep some binary log files around for the slave process to validate (?) before it purges the relay bins.
Thanks again,
Vince
Subject
Views
Written By
Posted
7319
July 24, 2014 12:30PM
3150
July 25, 2014 08:55AM
2624
August 13, 2014 03:54PM
2292
August 15, 2014 03:11PM
Re: relay-bin files not being cleaned up
2097
August 25, 2014 03:00PM
1970
August 26, 2014 02:28PM
2003
August 27, 2014 03:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.