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

[Stuart Auchterlonie]

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....


Stuart