[mythtv-users] 0.25 SQL CPU Load issues after optimisation
grotepass at gmail.com
Thu Jul 19 20:48:00 UTC 2012
On Thu, 19 Jul 2012 20:50:42 +0100
Another Sillyname <anothersname at googlemail.com> wrote:
> On 19 July 2012 20:33, Gary Buhrmaster <gary.buhrmaster at gmail.com>
> > On Thu, Jul 19, 2012 at 3:10 AM, Another Sillyname
> > <anothersname at googlemail.com> wrote:
> > ....
> >> Thanks for this but didn't help I'm afraid.
> > It might be interesting to take the select, and run it
> > under an EXPLAIN (perhaps an extended explain)
> > to see what might be the cause of (what sounds like)
> > a table scan.
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://www.mythtv.org/mailman/listinfo/mythtv-users
> I'm trying to reverse engineer the SQL command that appears to be the
> trigger/cause of the the problem but I'm beyond the limit of my
> skillset on SQL here. It would be very helpful if either one of the
> devs or a SQL guru stepped in here to help look at this.
More information about the mythtv-users