[mythtv] regular full CPU load by mysqld if mythbackend is running

[John Pullan]

On 19/10/05, Stuart Auchterlonie <stuarta at squashedfrog.net> wrote:
> On Wed, Oct 19, 2005 at 10:24:56AM -0400, Wendy Seltzer wrote:
> >
> > Thanks. Almost, but not quite. There's still a stutter at the point when it
> > hits the "Scheduled 162 items in 0.7," and it does that twice about a minute
> > apart once it has finished scanning channels. This is on a fast machine (p4
> > 3 GHz, DMA enabled). Are there other tweaks you'd recommend or logs that
> > would be helpful?
>
> I've noticed that the biggest hit on the database is all the
> calls made by the scheduler. This is also what you are seeing.
>
> There is no 5 minute fix for this. Will look into this when
> I get a chance. (I'm thinking new scheduler call
> backgroundReschedule)
>
> Perhaps you could try running mysql at a lower priority,
> that way the scheduler queries should take longer, but it's
> not a long term solution....
>
>
How about calling the scheduler when we're about to come out of
channel crawl mode ? Or is that not feasible ?


--
John