[mythtv-users] Database sizes

John Drescher drescherjm at gmail.com
Fri Aug 31 18:34:59 UTC 2007


On 8/31/07, Gareth Glaccum <gareth.glaccum at btopenworld.com> wrote:
>
>
> Hi,
> Have searched through the threads, nothing really jumps out to answer....
> How large would you expect the database to be on an 8 month old system? I
> have been running a system since around the turn of the year, FC5 I think
> (maybe 6, not really of consequence) I am currently in the process of moving
> the database and the capture devices to a new box. Access to the database
> has been generally getting slower recently, as has deleting files.
> I thought that dumping the database, renaming everyting that was computer
> name specific (via sed) and then importing on the new machine would be a
> good way of doing things.
> When the database was dumped (only mythconverg at the moment) the size is
> 168Mb. This seems quite excessive. Not determined exactly where the data is
> yet (EPG?) but is this normal? Is there a good spring clean routine to
> improve matters (a 168Mb database has got to cause a little bit of lag, my
> new data store can only do around 300Mb R/W /s non-sequential)
> Thanks,

My 3.5 year old mythtv system dump from last night was:
-rw-r--r-- 1 root root 104M Aug 31 03:21 mythtv-2007-08-31

Which is about 15MB compressed with bzip2:
-rw-r--r-- 1 root root  15M Aug 31 03:21 mythtv-2007-08-31.bz2

John


More information about the mythtv-users mailing list