[mythtv-users] [mythtv-commits] Ticket #7604: Very slow query when delete recording (was Re: Very slow mythfrontend, mysql at 100%)

[GXL.nl]

Allan Stirling said the following on 19/11/09 21:18:
> GXL.nl wrote:
>> Michael T. Dean said the following on 19/11/09 20:33:
>>> On 11/19/2009 02:09 PM, GXL.nl wrote:
>>>> I have the same thing, also made a bug report (#7604) for it since 
>>>> it only happens since I upgraded to 0.22 (and from Ubuntu 8.04 to 
>>>> 9.1).
>>>>
>>>> I have enabled the slow-query-log from MySQL and it shows the 
>>>> following query as being slow (13 secs):
>>>>
>>>>
>
>
> Can you tell us if you run mythfilldatabase at all, or if this is an 
> entirely EIT based setup?
>
> Cheers,
>
> Allan.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Yes, I run mythfilldatabase although not daily and since 0.22 it may 
have run only 2-3 times.

The log also shows:
Rows_sent: 608  Rows_examined: 2574883
Which seems like a lot of rows examined and might indicate a bad join/index?

Nijn