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

[Wendy Seltzer]

On 10/19/05, Stuart Auchterlonie <stuarta at squashedfrog.net> wrote:
>
>
> Am now interested in the complete "Scheduled 162 items in 0.7,"
> line when it takes a big hit. Suspect the match time is quite high.


A representative one:
2005-10-19 12:59:46.109 Scheduled 162 items in 0.9 = 0.63 match + 0.23 place

Changing the mysqld priority doesn't eliminate the glitches. (niced to +5):
2005-10-19 13:11:57.973 Scheduled 162 items in 2.4 = 1.95 match + 0.41 place
2005-10-19 13:13:05.516 Scheduled 162 items in 0.8 = 0.52 match + 0.24 place

These are mostly tvwish requests, plus a few find-one or find-all I've
scheduled.

In the meantime, I'd recommend that this scanning default to "off" for those
who don't explicitly request it.

Thanks.
--Wendy
--
Wendy Seltzer
http://wendy.seltzer.org/blog/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20051019/ee8552ab/attachment.htm