[mythtv-users] SSD disk for DB

[Karl Dietz]

On 08.10.2012 21:53, Yeechang Lee wrote:
> Be careful with this. I found that mysql would sometimes create
> temporary files of up to 3.5GB in size when running certain functions,
> such as if a SQL statement in Custom Edit is accidentally made too
> broad[1] or the "Time" search from Schedule Recordings.

http://code.mythtv.org/trac/ticket/10023 has a patch for time search
that could use some testing for side effects. (worksforme)

At ~50kb per program, ~50 programs per day and ~100 channels you're
looking at 250 Mb per day or 3.5Gb per 14 days (SD) of guide data.
(I just picked random numbers that add up, I was seeing something
between 1,5GB and 2,5GB for time search with real world data IIRC)

Regards,
Karl