[mythtv-users] mythfilldatabase takes long, mysql at 100% CPU, mythfrontend hangs

[Karl Dietz]

On 06.04.2013 08:11, Thomas Börkel wrote:
> Recently, I upgraded from 0.23.1 to 0.26 and I also got lots of new
> channels.
>
> Since then, mythfilldatabase needs about 15 minutes to load the data
> (from external grabber xml file) into the database.
...
> show processlist shows this SQL fragment:
>
> UPDATE program JOIN (SELECT MIN(starttime) AS starttime, title,
> subtitle,           LEFT(description
,,,
> mythfilldatabase output with timestamps:
...
> 2013-04-06 07:55:22.949184 I  Marking episode first showings.
> 2013-04-06 08:02:53.033445 I      Found 34820
> 2013-04-06 08:02:53.033460 I  Marking episode last showings.
> 2013-04-06 08:10:33.809246 I      Found 34701
...
> Anything I can do about this?

It sounds like the same issue as ticket #11282, see
http://code.mythtv.org/trac/ticket/11282

I hope to get to it in time for 0.27

Regards,
Karl