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

Gabe Rubin gaberubin at gmail.com
Wed Sep 1 16:08:31 UTC 2010


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.


More information about the mythtv-users mailing list