Use "PURGE {MASTER|BINARY} LOGS TO 'log_name'" instead of "RESET
MASTER".
>From the manual:" Deletes all the binary logs listed in the log index that are strictly prior to the specified log or date. The logs also are removed from this list recorded in the log index file, so that the given log now becomes the first. (...) You must first check all the slaves with SHOW SLAVE STATUS to see which log they are reading, then do a listing of the logs on the master with SHOW MASTER LOGS, find the earliest log among all the slaves (if all the slaves are up to date, this will be the last log on the list), backup all the logs you are about to delete (optional) and purge up to the target log. " http://www.mysql.com/doc/en/PURGE_MASTER_LOGS.html -- DS On Mon, 2003-12-08 at 23:09, Mayuran Yogarajah wrote: > We are running MySQL 3.23 in production, and have replication > setup in the following manner: There are two machines (m1 and m2). > Replication is setup in a circular way. Both machines are master and > slave, more specifically, m1 is master to m2 and m2 is master to m1. > I checked today and saw that one of the machines had a bunch of > binary log files (see below). I read in the MySQL documentation that > you can delete the logs by issuing a RESET MASTER command. I am > wonder how this will affect replication. Is this going to break replication > in any way? Is it safe to simply delete the binary log files manually ? > (Id prefer to do this). Any input would be helpful. > > Thank you. > > > MySQL data directory: > > total 4388640 > drwx------ 2 mysql mysql 4096 Aug 17 19:24 mysql > drwx------ 2 mysql mysql 4096 Aug 17 19:46 test > -rw-rw---- 1 mysql mysql 445 Aug 17 20:42 mw01-bin.001 > drwxr-xr-x 8 root root 4096 Aug 17 23:51 .. > -rw-rw---- 1 mysql mysql 111 Aug 24 04:02 mw01-bin.003 > -rw-rw---- 1 mysql mysql 308 Aug 24 04:02 mw01-bin.002 > -rw-rw---- 1 mysql mysql 111 Aug 31 04:02 mw01-bin.005 > -rw-rw---- 1 mysql mysql 244491 Aug 31 04:02 mw01-bin.004 > -rw-rw---- 1 mysql mysql 111 Sep 7 04:02 mw01-bin.007 > -rw-rw---- 1 mysql mysql 28177 Sep 7 04:02 mw01-bin.006 > -rw-rw---- 1 mysql mysql 7947 Sep 13 23:59 mw01-bin.008 > -rw-rw---- 1 mysql mysql 111 Sep 14 04:02 mw01-bin.010 > -rw-rw---- 1 mysql mysql 3513 Sep 14 04:02 mw01-bin.009 > -rw-rw---- 1 mysql mysql 111 Sep 21 04:02 mw01-bin.012 > -rw-rw---- 1 mysql mysql 30791885 Sep 21 04:02 mw01-bin.011 > -rw-rw---- 1 mysql mysql 111 Sep 28 04:02 mw01-bin.014 > -rw-rw---- 1 mysql mysql 111270867 Sep 28 04:02 mw01-bin.013 > -rw-rw---- 1 mysql mysql 12105202 Sep 28 19:18 mw01-bin.015 > -rw-rw---- 1 mysql mysql 111 Oct 5 04:02 mw01-bin.017 > -rw-rw---- 1 mysql mysql 38094517 Oct 5 04:02 mw01-bin.016 > -rw-rw---- 1 mysql mysql 111 Oct 12 04:02 mw01-bin.019 > -rw-rw---- 1 mysql mysql 276605852 Oct 12 04:02 mw01-bin.018 > -rw-rw---- 1 mysql mysql 61917421 Oct 12 23:48 mw01-bin.020 > -rw-rw---- 1 mysql mysql 111 Oct 19 04:02 mw01-bin.022 > -rw-rw---- 1 mysql mysql 101760652 Oct 19 04:02 mw01-bin.021 > -rw-rw---- 1 mysql mysql 111 Oct 26 04:02 mw01-bin.024 > -rw-rw---- 1 mysql mysql 579578833 Oct 26 04:02 mw01-bin.023 > -rw-rw---- 1 mysql mysql 479 Nov 2 04:02 mw01-bin.026 > -rw-rw---- 1 mysql mysql 844900359 Nov 2 04:02 mw01-bin.025 > -rw-rw---- 1 mysql mysql 111 Nov 9 04:02 mw01-bin.028 > -rw-rw---- 1 mysql mysql 869670836 Nov 9 04:02 mw01-bin.027 > drwx------ 2 mysql mysql 4096 Nov 10 21:15 Viper > -rw-rw---- 1 mysql mysql 111 Nov 16 04:02 mw01-bin.030 > -rw-rw---- 1 mysql mysql 700865150 Nov 16 04:02 mw01-bin.029 > -rw-rw---- 1 mysql mysql 111 Nov 23 04:02 mw01-bin.032 > -rw-rw---- 1 mysql mysql 111 Nov 23 04:02 mw01-bin.031 > -rw-rw---- 1 mysql mysql 111 Nov 30 04:02 mw01-bin.034 > -rw-rw---- 1 mysql mysql 111 Nov 30 04:02 mw01-bin.033 > -rw-rw---- 1 mysql mysql 86 Dec 7 01:23 mw01-bin.035 > srwxrwxrwx 1 mysql mysql 0 Dec 7 01:25 mysql.sock > -rw-rw---- 1 mysql mysql 570 Dec 7 01:30 mw01-bin.index > -rw-rw---- 1 mysql mysql 111 Dec 7 01:30 mw01-bin.037 > -rw-rw---- 1 mysql mysql 111 Dec 7 01:30 mw01-bin.036 > drwxr-xr-x 5 mysql mysql 4096 Dec 7 01:30 . > -rw-rw---- 1 mysql mysql 63 Dec 7 01:49 master.info > -rw-rw---- 1 mysql mysql 861518654 Dec 8 17:53 mw01-bin.038 > -- Diana Soares -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
