[mythtv-users] Mythweb not showing program guide
Cj B
black at comet.n-polk.k12.ia.us
Thu Mar 16 16:07:04 UTC 2006
On Mar 16, 2006, at 7:33 AM, Niels Dybdahl wrote:
> Do you have a lot of mysqld activity when you try to open the
> program guide ?
>
No, mysql utilization goes up to about 5%, while apache is using 23%.
I checked the mysql.log and found that it's output a ton of queries
like this:
SELECT program.*,
UNIX_TIMESTAMP(program.starttime) AS
starttime_unix,
UNIX_TIMESTAMP(program.endtime) AS
endtime_unix,
CONCAT(repeat('star_character',
program.stars * 'max_stars'),
IF((program.stars * 'max_stars' *
10) % 10,
"½", "")) AS starstring,
IFNULL(programrating.system, "") AS rater,
IFNULL(programrating.rating, "") AS rating,
oldrecorded.recstatus
FROM program
LEFT JOIN programrating USING (chanid,
starttime)
LEFT JOIN oldrecorded
ON LENGTH(IFNULL
(oldrecorded.seriesid, "")) > 0
AND LENGTH(IFNULL
(oldrecorded.programid, "")) > 0
AND oldrecorded.programid =
program.programid
AND oldrecorded.seriesid =
program.seriesid
WHERE program.chanid='1070' AND program.starttime =
FROM_UNIXTIME('1143021600') GROUP BY program.chanid,
program.starttime ORDER BY program.starttime
When exceuted manually it does return a program.
| 1070 | 2006-03-22 02:00:00 | 2006-03-22 02:30:00 | Family Guy |
Holy Crap | Peter invites his religious father to live with the
family. | Animated | series | 2000 | 0 |
1 | | 1 | 0 | 0 | 1
| 0 | 0 | SH296001 | 1999-09-30 | Series
| | 111 | EP2960010010 | 0
| 0 | 1143021600 | 1143023400 | | VCHIP |
TV-14 | 11 |
More information about the mythtv-users
mailing list