$ tail /var/log/mysql/mysql-slow.log
SELECT     c.chanid,         c.sourceid,           p.starttime,           p.endtime,        p.title,              p.subtitle,            p.description,    c.channum,            c.callsign,            c.name,           oldrecduplicate,      p.category,            sched_temp_record.recpriority, sched_temp_record.dupin,   recduplicate,          findduplicate,    sched_temp_record.type,        sched_temp_record.recordid,     p.starttime - INTERVAL sched_temp_record.startoffset     minute AS recstartts,     p.endtime + INTERVAL sched_temp_record.endoffset     minute AS recendts,                                             p.previouslyshown,     sched_temp_record.recgroup, sched_temp_record.dupmethod,  c.commmethod,          capturecard.cardid, cardinput.cardinputid,p.seriesid,          p.programid,       sched_temp_record.inetref,    p.category_type,       p.airdate,         p.stars,             p.originalairdate,     sched_temp_record.inactive, sched_temp_record.parentid,   recordmatch.findid,     sched_temp_record.playgroup, oldrecstatus.recstatus,     oldrecstatus.reactivate, p.videoprop+0,         p.subtitletypes+0, p.audioprop+0,   sched_temp_record.storagegroup,     capturecard.hostname, recordmatch.oldrecstatus, NULL,     oldrecstatus.future, cardinput.schedorder,     p.syndicatedepisodenumber, p.partnumber, p.parttotal,     c.mplexid, c.recpriority + cardinput.recpriority + (cardinput.cardinputid = sched_temp_record.prefinput) * 2 + (p.hdtv > 0 OR FIND_IN_SET('HDTV', p.videoprop) > 0) * 2 AS powerpriority FROM recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program AS p ON ( recordmatch.chanid    = p.chanid    AND      recordmatch.starttime = p.starttime AND      recordmatch.manualid  = p.manualid ) INNER JOIN channel AS c ON ( c.chanid = p.chanid ) INNER JOIN cardinput ON (c.sourceid = cardinput.sourceid) INNER JOIN capturecard ON (capturecard.cardid = cardinput.cardid) LEFT JOIN oldrecorded as oldrecstatus ON ( oldrecstatus.station   = c.callsign  AND      oldrecstatus.starttime = p.starttime AND      oldrecstatus.title     = p.title ) WHERE p.endtime > (NOW() - INTERVAL 480 MINUTE) ORDER BY sched_temp_record.recordid DESC, p.starttime, p.title, c.callsign,          c.channum;
# User@Host: mythtv[mythtv] @ localhost []
# Query_time: 0.000162  Lock_time: 0.000015 Rows_sent: 69  Rows_examined: 69
SET timestamp=1376630275;
SELECT recordid, next_record FROM record;
# Time: 130816 15:18:25
# User@Host: mythtv[mythtv] @ localhost []
# Query_time: 0.000442  Lock_time: 0.000058 Rows_sent: 1  Rows_examined: 145
SET timestamp=1376630305;
SELECT DISTINCT recgroup FROM recorded WHERE recgroup != "LiveTV" AND recgroup != "Deleted" UNION SELECT DISTINCT recgroup FROM record WHERE recgroup != "LiveTV" AND recgroup != "Deleted" ORDER BY recgroup;
jyavenard@htpc:/etc/mysql/conf.d$