[mythtv-users] Size of mythconverg database.

[Dave Day]

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?
>>
>> Thanks,
>> Dave
>
> 11GB isn't normal. Sound like you may have transaction logging enabled 
> or something like that.
>
> http://www.gossamer-threads.com/lists/mythtv/users/249133#249133
>
> Paul H.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>    
Paul -

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

Thanks again,
Dave
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100531/9b66cf7e/attachment.htm>