mysql binlogs and their expiry times
Zbigniew Szalbot
zszalbot at gmail.com
Thu Oct 9 05:06:45 UTC 2008
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
More information about the freebsd-questions
mailing list