[mythtv-users] [mythtv-commits] Ticket #7604: Very slow query when delete recording (was Re: Very slow mythfrontend, mysql at 100%)
info at gxl.nl
Thu Nov 19 20:27:51 UTC 2009
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
>>>> 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?
> mythtv-users mailing list
> mythtv-users at mythtv.org
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?
More information about the mythtv-users