[mythtv-users] Size of mythconverg database.
david.scott.day at gmail.com
Mon May 31 20:07:32 UTC 2010
On 05/31/2010 01:48 PM, Paul Harrison wrote:
> On 31/05/10 18:21, Dave Day wrote:
>> I am a relatively new user of Mythtv. I installed Myth in February
>> of this year and have been using the same database ever since.
>> Yesterday I noticed that the partition it is on was getting full.
>> One of the problems was that I originally assigned Myth Video to use
>> that partition and then never moved its storage to a more spacious place.
>> But I was also surprised to see that /var/lib/mysql which is where
>> the mysql database lives has 11GB!!! That makes me suspect that
>> there is some required housekeeping that I am not doing. I have a
>> fairly simple Myth system of one backend with one HVR 1600. I
>> started with MythTV 22 and have switched to 23.
>> Should the DB really be that big? There are only two databases,
>> mythconverg and test.
>> What can I do to keep it more lean?
> 11GB isn't normal. Sound like you may have transaction logging enabled
> or something like that.
> Paul H.
> mythtv-users mailing list
> mythtv-users at mythtv.org
Thanks so much. That was it.
purge binary logs to 'mysqld-bin-000038';
did the trick and I am well under a Gig now. I also commented out
log-bin in /etc/mysql/my.cnf
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users