I've been thinking about this a little while my database is updating its schema from .20.2 to .21.... a thought occurred to me that I've been running myth since 0.18 & many db tables have been refactored & renamed but from browsing mythconverg with phpmyadmin I suspect that many of the tables still exists & appear to contain data. I'm a little nervous about going in and dropping what look like tables without knowing whats required for 0.21. So I was wondering if anyone has a list of the DB tables that are used/required for 0.21, if I have that in hand then I might go in & start dropping old tables.<br>
I'd be interested if folks have thoughts on this?<br>cheers,<br>--Frank<br><br><div class="gmail_quote">On Tue, Apr 1, 2008 at 9:53 PM, Frank Lynch <<a href="mailto:frank.lynch@gmail.com">frank.lynch@gmail.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;">Hi Folks,<br>I've been running mythtv happily for a couple of years, tonight I decided to upgrade to 0.21 & migrate from Fedora Core 4 to ubuntu gutsy. All appears to be going well at the moment.<br>
However during the process I backedup my db & noticed that its a whopping 2.2GB! <br>
Is this normal? <br>I have recently noticed that mysql was consuming quite a bit of cpu time (even occasionally causing hd playback to stutter - its a combined frontent/backend single-box setup). I was hoping that the move off FC4 to Gutsy might help, but now I'm starting to wonder about the sheer size of the db. Has anyone encountered an issue like this before? Is there any way to reduce or prune the mythconverg db a little? <br>
cheers,<br><font color="#888888">--Frank<br><br>
</font></blockquote></div><br>