[mythtv-users] database size

[Frank Lynch]

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.
I'd be interested if folks have thoughts on this?
cheers,
--Frank

On Tue, Apr 1, 2008 at 9:53 PM, Frank Lynch <frank.lynch at gmail.com> wrote:

> Hi Folks,
> 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.
> However during the process I backedup my db & noticed that its a whopping
> 2.2GB!
> Is this normal?
> 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?
> cheers,
> --Frank
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080401/aac9a1fb/attachment.htm