[mythtv-users] Opinion on a P4 Backend // HDD Throughput

[Brad DerManouelian]

On Mar 5, 2008, at 8:56 PM, Jeff Holicky wrote:

> Q-Assuming one does a LOT of recording (not sure if there are stats  
> somewhere on this) - about how much disk space should allocated to  
> the myth database? I figure a 120GB - and divide it into two - and  
> use the non-OS/log side for archiving. Then have a bunch of other  
> HDDs for recording.  Are we talking up to 2GB; 5GB or 10GB for the  
> average DB?  I assume there is some pruning/purging/compacting/ 
> reindexing routines.
>
My db is 421MB and I have 1201 recordings in it.
I run the optimize_mythdb.pl script as a nightly cron job. I think it  
just runs an analyze on the tables and repairs any problems it finds.  
I don't think it does any purging.

-Brad