[mythtv-users] MySQL log files growing alarmingly
turbo at talstar.com
Sat Jan 27 05:53:44 UTC 2007
On Sat, 2007-01-27 at 00:09 -0500, Rod Smith wrote:
> I set up a MythTV system about a week ago and I've discovered that my MySQL
> log files are growing at an alarming rate. I know next to nothing about
> MySQL, and the log files in question don't look like ordinary log files, so
> I'm reluctant to mess with them without guidance. I'm running Ubuntu 6.10
> with the MythTV 0.20 and MySQL packages that came with it. The log files
> appear in /var/log/mysql and are called mysql-bin.000001 and up (to
> mysql-bin.000047 at the moment). In total, the /var/log/mysql directory is
> now 270MB in size (on a 1GB partition), and I don't see any rules in the
> Ubuntu log file rotation configuration to touch these files, although there
> are rules to handle other (so far much smaller) MySQL log files.
> So, any advice on this? (A pointer to a Web page would be fine, provided it
> assumes little or no knowledge of MySQL.) Can these files be rotated by
> logrotate, or is there some better way to handle it?
Those are binary logs -- basically transactional logging for every
insert, update, delete, etc done on your database(s). You can (and, in
this case, should) turn off binary logging in your mysql configuration.
More information about the mythtv-users