Date: Thu, 9 Oct 2008 07:06:42 +0200 From: "Zbigniew Szalbot" <zszalbot@gmail.com> To: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: mysql binlogs and their expiry times Message-ID: <94136a2c0810082206u3e1de52el320672c67665ef5a@mail.gmail.com> In-Reply-To: <48ED0986.6060100@infracaninophile.co.uk> References: <94136a2c0810072248t7143c6am7b5740a7d770317d@mail.gmail.com> <48ED0986.6060100@infracaninophile.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
Hello, >> -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 > What's the output from running this SQL: "SHOW BINARY LOGS ;" ? mysql> SHOW BINARY LOGS ; +------------------+------------+ | Log_name | File_size | +------------------+------------+ | mysql-bin.000055 | 986782722 | | mysql-bin.000056 | 1073742442 | | mysql-bin.000057 | 754496837 | +------------------+------------+ 3 rows in set (0.01 sec) $ cat /usr/local/mysql/mysql-bin.index ./mysql-bin.000055 ./mysql-bin.000056 ./mysql-bin.000057 So all seems fine. Actually, I have taken this question to mysql list and found out that other users are reporting similar problems. http://lists.mysql.com/mysql/206576 http://bugs.mysql.com/bug.php?id=28238 http://lists.mysql.com/mysql/202793 So my final solution (if anyone's interested) was adding this to crontab 11 11 * * * /usr/local/bin/mysql -u root -psecret -e "PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)" It works so no problem but I do not really like the idea of providing passwords in crontab. I wish the option in my.cnf file worked as advertised. Anyway, thank you very much for your help. -- Zbigniew Szalbot
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?94136a2c0810082206u3e1de52el320672c67665ef5a>