[mythtv-users] 0.25 SQL CPU Load issues after optimisation

[Gary Buhrmaster]

....
> Well, I have not tried this (I am not in a position to test at the moment),
> but you may be able to just take the sql you have identified, and
> use the mysql cli, type in 'EXPLAIN ' and then copy/paste everything
> starting with the SELECT (probably need to add a trailing ';'.  And
> then try EXPLAIN EXTENDED.

I have done this, and the query plan looks reasonable, and for
my environment, the SELECT itself runs very quickly, returning
(around) 850 rows.

If you need additional assistance, please (first) update the
statistics for your tables, and then run the EXPLAIN EXTENDED,
and provide the results.

Gary