[mythtv-users] mythfilldatabase takes long, mysql at 100% CPU, mythfrontend hangs
Karl Dietz
dekarl at spaetfruehstuecken.org
Sat Apr 6 09:20:44 UTC 2013
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
More information about the mythtv-users
mailing list