MySQL has "expire_logs_days" can be defined in my* file, but I don't see there such
"expire_relay_days" can be used. And also the PURGE command works only on bin log files,
not on relay files. What can I do beside manually remove the files? Manually removing
files may cause issue.
--- On Wed, 6/10/09, Rick James <rjames@stripped> wrote:
> From: Rick James <rjames@stripped>
> Subject: RE: How to purge relay-bin file
> To: database100@stripped, replication@stripped
> Date: Wednesday, June 10, 2009, 1:37 PM
> Look for the PURGE command.
> Check you're my.cnf for 'bin' and 'relay'.
> Look at the file relay*x -- one of them should have a list
> of current
> relay log(s). Any relay logs older than that can be
> simpled rm'd.
> (If you are running Windows, some of the above needs
> Rick James
> MySQL Geeks - Consulting & Review
> > -----Original Message-----
> > From: Database System [mailto:database100@stripped]
> > Sent: Wednesday, June 03, 2009 6:08 AM
> > To: replication@stripped
> > Subject: How to purge relay-bin file
> > Hi,
> > There are many relay files on master server, don't
> know why.
> > There is no setup for that in my.ini file. If I just
> > delete those files, it won't match the content of
> > file. How to purge those?
> > If I simply delete all relay files and relay-index
> file, when
> > I need this server as slave (one of master to master),
> can I
> > just use change master to command, then will all relay
> > and relay index automatically generated again?
> > Thanks,
> > Lisa
> > --
> > MySQL Replication Mailing List
> > For list archives: http://lists.mysql.com/replication
> > To unsubscribe:
> > http://lists.mysql.com/replication?unsub=1
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1