[mythtv] Housekeeping function thrashing mysql

Chris Pinkham cpinkham at bc2va.org
Fri Jan 13 23:34:51 UTC 2006

> I've logged a select sql which is causing mysql to jump to 100% for upwards
> of 40 seconds which kills anything else needing data. I believe the sql is
> part of the housekeeping thread. Is there anyway of putting a limit on the
> return and putting it in a loop instead of getting the whole thing at once?

This is the scheduler query:
> SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime,
> program.endtime, program.title, program.subtitle, program.description,
> channel.channum, channel.callsign, channel.name, oldrecorded.endtime IS NOT
> NULL AS oldrecduplicate, program.category, record.recpriority, record.dupin,


More information about the mythtv-dev mailing list