<br><br><div class="gmail_quote">On Tue, Apr 1, 2008 at 10:05 PM, Michael T. Dean <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On 04/01/2008 09:53 PM, Frank Lynch wrote:<br>
> I've been running mythtv happily for a couple of years, tonight I<br>
> decided to upgrade to 0.21 & migrate from Fedora Core 4 to ubuntu<br>
> gutsy. All appears to be going well at the moment.<br>
> However during the process I backedup my db & noticed that its a<br>
> whopping 2.2GB!<br>
<br>
</div>By what measure? Looking at the binary files? Looking at the size of<br>
the backup? Basically, it sounds large, but I want to verify that<br>
you're using some appropriate means of measuring the size.</blockquote><div><br>the 2.2GB file is the output from mysqldump for mythconverg before I gzip'd it. It compresses down to ~200 mb.<br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">
> Is this normal?<br>
> I have recently noticed that mysql was consuming quite a bit of cpu<br>
> time (even occasionally causing hd playback to stutter - its a<br>
> combined frontent/backend single-box setup). I was hoping that the<br>
> move off FC4 to Gutsy might help, but now I'm starting to wonder about<br>
> the sheer size of the db. Has anyone encountered an issue like this<br>
> before? Is there any way to reduce or prune the mythconverg db a little?<br>
<br>
</div><br>Were you running with EIT only as your source for listings and not<br>
running mythfilldatabase? </blockquote><div><br>I was running mythfilldatabase via cron for the longest time, then around the time of the switchover to schedules direct I enabled the "allow myth to run mythfilldatabase by itself" option in the frontend.<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">If so, that could be the reason it's large.<br>
If so, don't worry, it will get a lot smaller sometime tomorrow, now<br>
that you've upgraded to 0.21. </blockquote><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
<br>
Regardless, now that you're on 0.21, all of the cleanup that's safe to<br>
do will be done automatically.<br>
<br>
Mike<br>
</blockquote><div> </div>awesome, thanks for the info Mike. I'll hold off on dropping tables & creating trouble for myself :-)<br>thanks,<br>--Frank<br></div>