[mythtv-users] High mysql cpu usage

[Karl Dietz]

On 30.12.2012 13:30, Jarle Thorsen wrote:
> Having had problems with a very unresponsive system for a long time I
> have now finally found time to look into it. I've had this problem on
> 0.25 and now on 0.26 (and probably on 0.24 too) It seems like what I am
> experiencing is the same problem described in this thread.
> (http://www.mythtv.org/pipermail/mythtv-users/2012-March/330451.html)
>
> Basically mysqld is running at almost 100% CPU for minutes at a time,
> and no other tasks are able to get any data from the db and just hangs
> until mysqld has finished it's task. Looking at the backend log it seems
> to always happen in conjunction with "Reschedule requested for MATCH 0 0
> 0 - EITScanner". (and it seems to take a very long time to finish):
>
> 2012-12-30 13:13:17.530239 I [10117/10231] Scheduler scheduler.cpp:2242
> (HandleReschedule) - Scheduled 294 items in 101.0 = 97.08 match + 0.42
> check + 3.51 place

97 seconds just for finding all programs that MATCH your recording
rules seems to be a bit much.

Can you check that programs in the past get cleaned out?
   select * from housekeeping;
Look if you have sane values for "lastrun".

And verify that your database indices are intact. Just run the
repair/optimize script for that.
http://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance#Optimize_the_Database

Regards,
Karl