 | | | Relay-bin logs | Relay-bin logs 2006-06-28 - By Dan Buettner
Back
Those do indeed have something to do with replication - they're a
record of all data manipulation commands (inserts, updates, deletes,
table creates and alters, etc). The slaves basically read the
commands from those files in order to replicate what the master has
done.
You can purge them fairly easily. The one gotcha is that you will
want to keep the most recent files around so that in case one or more
of your slaves fall behind, you're not purging the logs out from
underneath it.
See
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
A nice command (taken from an example on that page) that gives you a
moving window of binary log info is something like:
PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 31 DAY);
In my opinion running this command as a cron job or scheduled task is
a great solution in most situations, better than purging to a specific
file or purging them manually whenever you remember to (which is
usually about 5 minutes after you run out of disk space).
Dan
On 6/28/06, Dirk Bremer <Dirk.Bremer@(protected)> wrote:
> I'm using MySQL 4.1 and the master runs on a Windows 2000 server. This
> master replicates to several slaves.
>
> While browsing the data directory on the master, there are a lot of
> binary log files that are named:
>
> MasterName-relay-bin.999999 (where MasterName is the server-name and
> 999999 is a six-digit number)
>
> I have about 350 of these files and they all appear to be held open by
> the mater, i.e. they cannot be deleted from Windows. I assume that these
> files have something to do with replication.
>
> How can I purge these files to a more manageable number?
>
> Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
> - USA Central Time Zone
> 636-755-2652 fax 636-755-2503
>
> dirk.bremer@(protected)
> www.nisc.coop
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@(protected)
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|