[mythtv] Re: [mythtv-commits] Re: Ticket #551: Scheduler consuming all CPU cycles and disk bandwidth (via mysql).

[Brandon Beattie]

On Mon, Nov 14, 2005 at 04:07:07PM -0700, Endaf Jones wrote:
> On 11/14/05, Daniel Kristjansson <danielk at cuymedia.net> wrote:
> >
> > On Mon, 2005-11-14 at 22:01 +0000, MythTV wrote:
> > > Could this be the same issue I (and others) had with mythfilldatabase
> > > causing "IOBOUND - blocking in ThreadedFileWriter::Write()" errors
> > during
> > > a recording? See #348
> > This seems likely.
> >
> > Have you tried running MySQL niced?
> >
> > Also the #551 reporter tells me he's been running with the same DB
> > for a long time, is this the case for you as well?
> >
> At the time when I report #348, I had perhaps 10 months of myth usage on it
> (about 160 recordings). I've since pruned the database because of other
> issues. I moved my mythfilldatabase to a time when I don't do recordings
> (7am), so I haven't seen the problem recently. I did try and renice
> mythfilldatabase and that didn't make a difference (and now that I think
> about it, I should have tried renice on the mysql server instead).
>  I'll see if I can get some time tonight to try and get it to fail again.

Some interesting things, I'll post to bug 551 once I verify, but upon
marking 9 channels that dvb scan found as not visable via mythweb, I've
gone an evening, including recording 3 shows at the same time, without a
single IO block -- This hasn't happened for almost a month.  I had 5
channels in my listing that are USDTV channels, and normally encrypted.
2 others were simulcast but SD versions, and the other two simply didn't
have guide information.  

I'll add one back in at a time until the blocking occurs again, but I
thought I'd mention this small update here since it appears others may be
having related problems.

--Brandon