[mythtv-users] Database tuning

jedi jedi at mishnet.org
Tue Sep 3 14:48:21 UTC 2013


On Sun, Sep 01, 2013 at 12:00:48PM -0500, Keith Pyle wrote:
> On 09/01/13 07:00, Simon Hobson wrote:
> 
> ...
> 
> >But still, if there's enough mamory to hold all the tables and indexes in memory, then I don't see why it appears to be creating 200+M of "something" on disk and creating a lot of wait I/O which seems to be my problem.
> >
> >It also causes pauses in playback when recordings start and end - last night I had my iPad handy so was able to check - and each time a recording started or ended, there was a pause (several seconds) in playback. That'll be because the database (and OS) is on the same disks as the recordings (but not for long*) - however that's a symptom of the underlying problem rather than the problem itself.
> >
> >* Ebuyer just had a too good to pass up deal on SSDs, so the OS and database will soon be on an SSD.
> Having your DB on a SSD will definitely improve responsiveness.  I
> have a SSD in my backend for the OS and DB, and it presented a
> noticeable improvement when I switched from a conventional drive.
> There were some people concerned that a high write load from a DB
> would wear out a SSD too fast.  My backend SSD has 3.995 years of

    I too have an SSD in my master backend as a boot/root drive and it 
helps mysql performance out quite a bit. Time will tell about the whole
reliability thing.

[deletia]


More information about the mythtv-users mailing list