[mythtv-users] MySQL log files growing alarmingly
nemoinis at telus.net
Sun Jan 28 05:16:22 UTC 2007
On Jan 27, 2007, at 1:28 PM, Chuck Peters wrote:
> On 1/27/07, Rod Smith <mythtv at rodsbooks.com> wrote:
>> I set up a MythTV system about a week ago and I've discovered that my
>> log files are growing at an alarming rate. I know next to nothing
> On my Ubuntu Dapper machine I changed KEEP_BINARY_LOGS to 30.
> Look in /etc/cron.daily/mysql-server and verify that Ubuntu Edgy is
> also using the same file /etc/mysql/debian-log-rotate.conf to set the
> cp at peters:~$ cat /etc/mysql/debian-log-rotate.conf
> # This is the config file for
> # /etc/logrotate.d/mysql-server (for normal logs)
> # /etc/cron.daily/mysql-server-4.1 (for binary logs)
> # It should be kept in shell script syntax and contain only variables.
> # Both log file types are rotated daily, whenever "FLUSH LOGS;" is
> # issued and when the server (re)starts so do not choose too low
> # Configuring /etc/logrotate.d/mysql-server does not yet work.
> # The number of binary log files that are kept. They are rotated daily
> # and on "FLUSH LOGS;". A value of 0 disables rotating and is set as
> # for backward compatibility.
As far as I can tell on Ubuntu Edgy with mysql 5.0.24 the variable
controlling the binary logs is in /etc/mysql/my.cnf (or
/var/lib/mysql/my.cnf or ~/.my.cnf if it has been copied there).
The binary logs are not rotated but are expired according to the value
At least that's what happening on my system...
More information about the mythtv-users