Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 8 Oct 2008 07:48:47 +0200
From:      "Zbigniew Szalbot" <zszalbot@gmail.com>
To:        freebsd-questions <freebsd-questions@freebsd.org>
Subject:   mysql binlogs and their expiry times
Message-ID:  <94136a2c0810072248t7143c6am7b5740a7d770317d@mail.gmail.com>

next in thread | raw e-mail | index | archive | help
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
$ pkg_info -Ix mysql-s
mysql-server-5.0.67 Multithreaded SQL database (server)
from ports.

Thanks!

-- 
Zbigniew Szalbot



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?94136a2c0810072248t7143c6am7b5740a7d770317d>