[mythtv-users] Performance issues of keeping DB and recordings on different hard drives (was: Better listings for Schedules Direct users. Free!)

Greg greg12866 at nycap.rr.com
Wed Sep 1 17:28:22 UTC 2010


On 09/01/2010 12:08 PM, Gabe Rubin wrote:
> On Tue, Aug 31, 2010 at 11:16 PM, Michael T. Dean
> <mtdean at thirdcontact.com>  wrote:
>    
>> As far as the DB optimizations go, I'll leave it to others to help.  The one
>> thing I will say, however, is that having the database's binary data files
>> on the same file system that you're using to record could have a huge impact
>> on performance.  In truth, the best setup puts the database on a separate
>> spindle.
>>      
> I see this a lot on the list to now understand that this is pretty
> much the way to do.  However, I do have some questions about
> performance benefits for my particular system.  I just built a new
> system that uses a SATA drive.  My old system used a PATA drive and I
> understand there is a performance gain from switching over to SATA.  I
> would be interested in taking one of my old PATA drives and converting
> using that for everything and just leaving the SATA drive for storage
> of my recordings and possibly to backup the PATA drive (my SATA drvie
> is 2TB, so it makes no sense to not use that to store recordings).
>
> My question is, will I see a performance gain by doing this or is
> there a bigger performance gain by having the system and the database
> on SATA?
>
> Second question, if there is a performance gain, what is the best way
> to transfer all the bits over to the older PATA drive without having
> to reinstall everything?  I imagine I need to reformat the PATA and
> partition it similar to how the SATA drive, but don't know much more
> about doing this type of work on linux.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>    
I did this last year and used  http://clonezilla.org/


More information about the mythtv-users mailing list