[mythtv-users] High mysql cpu usage

[Jarle Thorsen]

2012/12/30 Karl Dietz <dekarl at spaetfruehstuecken.org>

> 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
>

All the results from "select * from housekeeping;" are from today, or the
last couple of days except

DBCleanup                   | 2010-03-20 21:38:15

don't know if this is a bad thing?

I optimize the db regularly (and ran both repair and optimize manually
today), but it did not help.
-- 
Jarle Thorsen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121230/d140a3e3/attachment.html>