[mythtv] backend from SVN 9761 bangs on mysqld

[Daniel Kristjansson]

On Sat, 2006-04-22 at 09:18 +0200, Tino Keitel wrote:
> Hi folks,
> 
> after I installed SVN 9761 I noticed that mysqld frequently uses all
> available CPU time when the backend is running. The last version I had
> was SVN 9591, where this wasn't the case. I ran the backend with -v eit
> and got this message when mysqld was using 100& CPU:
> EITHelper: Added 20 events
> I'm using DVB-T in Berlin/Germany.

This is probably normal. The DB hit is for the resceduling query.
Sometimes if the DB is corrupted this query will take much longer
than normal, but the recorder can handle a pretty substantial query
when the DB is not corrupted.

The EIT data collection also rate limits the number of reschedule
queries, and the start of EIT data collection is randomized to
prevent multiple recorder from all hitting the DB at exactly the
same time. This has been tested to work with three HDTV recorders
as long as you use XFS or JFS for the recording volume and place
the DB on a separate hard drive.

-- Daniel