At the Linux prompt, enter this : cat mysql-bin.index Make sure every binlog is in the mysql-bin.index. If the list is incorrect, then the expire logs feature won't work.
To test this out, try using PURGE MASTER LOGS TO ' mysql-bin.000055'; If this doesn't work, this verifies that the contents of mysql-bin.index are inconsistent. You will have to manually correct the contents of mysql-bin.index and 'service mysql restart'. Give it a try !!! -----Original Message----- From: Zbigniew Szalbot [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 4:11 AM To: mysql@lists.mysql.com Subject: mysql binlogs and their expiry times Hi there, I hope someone can help. Due to they way my HD has been sliced I had to move mysql database to /usr/local/mysql. All works fine. Last week I added this entry: #expire bin logs expire_logs_days = 7 to /usr/local/mysql/my.cnf I restarted the MySQL server and now I have been waiting for the binlogs to automatically expire but this is not happening: $ ls -l /usr/local/mysql -r--r--r-- 1 mysql mysql 4954 Oct 1 07:30 my.cnf drwx------ 2 mysql mysql 1536 Sep 27 07:10 mysql -rw-rw---- 1 mysql mysql 1073745213 Sep 2 04:07 mysql-bin.000047 -rw-rw---- 1 mysql mysql 1073746878 Sep 7 03:48 mysql-bin.000048 -rw-rw---- 1 mysql mysql 1073745707 Sep 11 20:07 mysql-bin.000049 -rw-rw---- 1 mysql mysql 175527890 Sep 12 08:32 mysql-bin.000050 -rw-rw---- 1 mysql mysql 128272 Sep 12 08:40 mysql-bin.000051 -rw-rw---- 1 mysql mysql 1073745119 Sep 17 04:35 mysql-bin.000052 -rw-rw---- 1 mysql mysql 1073747657 Sep 22 04:26 mysql-bin.000053 -rw-rw---- 1 mysql mysql 1073744456 Sep 27 03:28 mysql-bin.000054 -rw-rw---- 1 mysql mysql 986782722 Oct 1 07:32 mysql-bin.000055 -rw-rw---- 1 mysql mysql 1073742442 Oct 6 04:18 mysql-bin.000056 -rw-rw---- 1 mysql mysql 536487381 Oct 8 07:45 mysql-bin.000057 -rw-r----- 1 mysql mysql 209 Oct 6 04:18 mysql-bin.index Do you have any idea why? Or if /usr/local/mysql/ is a correct location for my.cnf file? Perhaphs it should go to /usr/local/etc/ ? If it matters, I use mysql-server-5.0.67 on FreeBSD 7.0-Release machine. Many thanks! -- Zbigniew Szalbot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
