<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jan 14, 2013 at 9:47 PM, Jarle Thorsen <span dir="ltr"><<a href="mailto:jarlethorsen@gmail.com" target="_blank">jarlethorsen@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><br><div><br>I have now tried to have EIT completely off for the last 24H and it was
like giving my mythbox a new life. No lagging at all. I have now turned
on logging for slow mysql queries (longer than 20 seconds), and also turned on passive EIT
scanning.<br><br></div><div>And here we go again:<br></div><div><br>2013-01-14 20:36:10.697272 I [16203/16230] Scheduler scheduler.cpp:2129 (HandleReschedule) - Reschedule requested for MATCH 0 0 0 - EITScanner<br>2013-01-14 20:36:57.013252 I [16203/16230] Scheduler scheduler.cpp:2242 (HandleReschedule) - Scheduled 140 items in 46.2 = 45.42 match + 0.18 check + 0.60 place<br>
</div></div><br></div><div class="gmail_extra">mysqld is again at 100% CPU in this time window, but the query is not logged by mysql as a slow query for some reason?<br></div></div></blockquote><div><br></div><div>Probably lots of smaller queries. If those scheduler items are queried with one query per item. Maximum time per query is something like 45.42/140=0.32s. But if this happens only with EIT scans it suggests that this is concurrency issue. Which means that I was wrong with my idea with changing execution plans.<br>
<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><br></div><div class="gmail_extra">I'm guessing that the passive EIT scan gives it less data and that is the reason why it uses apx 40 seconds, compared to the 80+ seconds with active EIT scan enabled.<span class=""><font color="#888888"><br>
</font></span></div></div></blockquote><div><br></div><div>I'm just wondering why MySQL is busy looping on CPU. I have two DVB-C tuners with passive EIT scan but I don't see this issue. I only have 25 channels and less recordings but it takes only fractions compared to above:<br>
<br> mythlogserver: mythbackend[3434]: I Scheduler scheduler.cpp:2241 (HandleReschedule) Scheduled 30 items in 0.1 = 0.06 match + 0.01 check + 0.02 place<br><br> <br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr"><div class="gmail_extra"><span class=""><font color="#888888">
</font></span></div><span class=""><font color="#888888"><div class="gmail_extra"><br>-- <br>Jarle Thorsen
</div></font></span></div></blockquote><div> </div></div></div><div class="gmail_extra">Juhani<br></div><div class="gmail_extra">-- <br>Juhani Rautiainen <a href="mailto:jrauti@iki.fi" target="_blank">jrauti@iki.fi</a>
</div></div>