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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]