Maybe it's a bug.^___^ On Thu, Oct 9, 2008 at 1:37 PM, Andrew Garner <[EMAIL PROTECTED]>wrote:
> On Wed, Oct 8, 2008 at 3:10 AM, Zbigniew Szalbot <[EMAIL PROTECTED]> > wrote: > > 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! > > I've seen MySQL get confused in some situations - seemingly after > running out of disk space or when someone manually maintains bin logs > outside of mysql-bin.index (e.g. find+rm). expire-logs-days stops > working - explicit flush logs doesn't trigger expiration, log > rotations doesn't trigger expiration. In the cases I've run into an > explicit PURGE MASTER LOGS or a restart usually fixes things and > further flush-logs/log rotations appear to work - sometimes after > correcting the mysql-bin.index. There's a bug report similar to this > here: http://bugs.mysql.com/bug.php?id=28238. Might be useful to > also be aware of: http://bugs.mysql.com/bug.php?id=37027 > > ~Andrew > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn