[mythtv-users] 0.25 SQL CPU Load issues after optimisation
gary.buhrmaster at gmail.com
Fri Jul 20 19:18:27 UTC 2012
> 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.
More information about the mythtv-users