[mythtv-users] High mysql cpu usage

[Michael T. Dean]

On 01/14/2013 02:47 PM, Jarle Thorsen wrote:
> 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.
>
>
> And here we go again:
>
> 2013-01-14 20:36:10.697272 I [16203/16230] Scheduler 
> scheduler.cpp:2129 (HandleReschedule) - Reschedule requested for MATCH 
> 0 0 0 - EITScanner
> 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
>
> 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?
>
> 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.
>

Sounds like you'll have to wait until Stuart M fixes (fixed?) the EIT 
locking problem I mentioned, before.  (I don't know if he's already 
fixed it, but it's possible, so you may want to look through commits and 
see if you find something about it, and if so, which branch(es) it's in 
and since when.  Then again, you could try updating to the newest 
0.26-fixes (or at least the newest -fixes for your version) (if you're 
not there, yet), and might just pick it up and save yourself some 
searching.)

Mike