[mythtv-users] Populating the .xmltv file for my grabber from mythtv database?

[David Watkins]

>
>
>
>
> Not sure if anything in there hints to the problem.  It does look like
> most of the chunks took 30 minutes, which is still too long, but one of the
> later chunks took 90 minutes.
>
> I think this is clearly related to all the mysql activity.  When I monitor
> the vm, though, the CPU utilization is low, including the mysql daemon.  I
> am starting to think this operation is I/O bound, resulting in slow
> database operations.
>
>
>
Most of the earlier 3 day chunks will involve few database writes because
the guide data should be already there from previous runs.  Only the last
chunk will contain new stuff.  So I guess that supports the suspicion that
it's mysql updates that are eating up the time.

You could increase the log level to LOG_DEBUG which may give some more
clues.

What about memory utilisation / disk swapping in the VM?  Can you monitor
that?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210511/a8b6f21f/attachment.htm>