[mythtv-users] sluggish system, potential HD failure, and how best to get back up and runnin

Greg Thompson gthompson20 at gmail.com
Tue Mar 4 19:49:14 UTC 2014

On Mar 4, 2014, at 2:05 PM, Simon Hobson <linux at thehobsons.co.uk> wrote:

> On 4 Mar 2014, at 16:47, Gabe Rubin <gaberubin at gmail.com> wrote:
>> The key questions I have are, is a SSD a good option considering the DB gets many writess a day and I thought SSDs fail after a certain amount of writes.  Even if that is not an issue, is the cost worth it?  I don't neccesarily want to replace this drive with a HDD because I only need about 50-100 gigs for the system drive (maybe more, I am forgetting how large the db can get).
> You can do a **LOT** to reduce the drive I/O load by tuning the DB. It also makes a vast difference to performance - reducing reschedule times (which happens any time a recording starts/ends or you add/change/delete a rule).
> But in any case, SSDs include wear levelling algorithms so they don't keep writing to the same place all the time. The emptier the drive, the more (and more easily) it can spread the wear around. The DB doesn't get all that big anyway, my root system is only 1.2G used, and /var (which includes the database) has only 2G used - on a system that's recorded 7022 episodes of 670 shows over a little over 5 years.
> I added an SSD not long ago (when eBuyer has a good deal on a 64G one). That and some DB tuning made a big difference to the system - reschedules normally happen before the "upcoming recordings" screen refreshes, while before, it would refresh and not show the last change (eg I could click "Don't record" and the program would still show as to be recorded until the next page refresh).
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

Mind sharing your DB Tuning Tips?


More information about the mythtv-users mailing list