[mythtv-users] Anyone using SSD for long term storage?

[jedi]

On Thu, Jul 24, 2014 at 08:04:56AM -0700, Thomas Mashos wrote:
> On Thu, Jul 24, 2014 at 2:16 AM, Warpme <warpme at o2.pl> wrote:
> > On 23/07/14 23:26, Joseph Fry wrote:
> >
> >> On Wed, Jul 23, 2014 at 2:49 PM, jacek burghardt
> >> <jaceksburghardt at gmail.com <mailto:jaceksburghardt at gmail.com>> wrote:
> >>
> >>     Well do you guys think that using ssd for buffer will imrove mythtv ?
> >>
> >>
> >> Define improve.

[deletia]

> >
> > 5.Current MythTV system based on quite standard HDD like WD Green is
> > working really nice even with ATOM CPU. (i.e.86 progs EPG list loads in
> > aprox 0.2-0.4sec; showing 400+ recordings list is instant (in sense that
> > there is no time to show loading progress dialog).
> >
> > Summarizing:
> > Speaking in economy: HDD->SSD marginal utility increase is in my case
> > was ABSOLUTELY not worth of SSD investment.
> >
> > Before SSD spending decision I'm strongly recommending:
> >
> > -buy more RAM for having huge as possible kernel disk buffers
> > -move /tmp to tempfs
> > -allocate 32MB or more for MySQL query cache (and other parameters
> > accordingly to http://mysqltuner.pl/)
> >
> > With above it is highly probable that You will get MythTV system where
> > HDD->SSD upgrade will absolutely not worth the money (and allows You
> > spent those money elsewhere - with much higher utility).
> >
> > YMMV
> >
> >
> > _______________________________________________
> 
> While I agree with most of what you said, I do find it a bit humorous
> that you're discussing putting the MySQL DB onto an SSD as some kind
> of huge investment. We're talking under $50 here. Would RAM be faster?
> Yes, but it's also more expensive.
> 
> Everything has it's trade-offs I suppose

    Well, you always want to have your OS and DB on a separate drive
from your recordings. So that extra drive is going to be a constant in
any decent backend build. The price of a hard drive only goes so low 
and you only need so much space on your boot drive for a backend.

    The difference between your boot drive being SSD vs spinning rust
no longer has anything to do with cost. It's simply a function of how
much extra empty drive space you want to have on your OS/DB drive.

    SSDs are cheap enough and big enough that they are interchangeable
with spinning rust when it comes to a mythtv build (at least for the OS
drive).