[mythtvnz] New list member - Hardware recommendations

[Steve Hodge]

On Thu, Jan 12, 2012 at 20:12, criggie <criggie at criggie.org.nz> wrote:

> On 12/01/12 18:54, Steve Hodge wrote:
> > If you're going to be recording a lot of stuff
> > simultaneously then perhaps having MySQL on a separate drive might be
> > important...
>
> Why?  The mysql output is a single record to the recordings table, a
> single record in the recorded table, and maybe a few state updates that
> the tuner is in use.
>

I think it builds the index in recordedseek during recording as well. That
table is current 3.5M rows in my db, seems to be about 2 rows a second
added per recording. So on balance it really shouldn't be an issue, it's
just something I've seen people raise as a concern in the past.

Cheers,
Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120112/765ed78d/attachment.htm