[mythtv] Long scheduler runs

Mark Buechler mark.buechler at gmail.com
Thu Feb 7 16:05:20 UTC 2008


I've submitted a ticket with a patch which resolves this issue.

- Mark.

On 2/7/08, Allan Stirling <Dibblahmythml0015 at pendor.org> wrote:
>
> Mark Buechler wrote:
> >> # Query_time: 11  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> >> DELETE FROM program WHERE manualid = -1 OR  (manualid <> 0 AND -1 =
> -1);
>
>
> Since manualID is unsigned, this does not make any sense to me?
>
> It is also the reason MySQL doesn't use the index - If you run:
>
> mysql> select * FROM program WHERE (manualid <> 0 AND -1 =
> -1) and manualid=-1;
> Empty set, 1 warning (0.83 sec)
>
> mysql> show warnings;
>
> +---------+------+-------------------------------------------------------------+
> | Level   | Code | Message
>                    |
>
> +---------+------+-------------------------------------------------------------+
> | Warning | 1264 | Data truncated; out of range for column
> 'manualid' at row 1 |
>
> +---------+------+-------------------------------------------------------------+
> 1 row in set (0.00 sec)
>
>
>
> Cheers,
>
> Allan.
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-dev/attachments/20080207/f6daf27b/attachment.htm 


More information about the mythtv-dev mailing list