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

Michael T. Dean mtdean at thirdcontact.com
Thu Nov 19 20:30:50 UTC 2009


On 11/19/2009 02:49 PM, 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):
>>>
>>>
>> <scheduler query>
>>> I dug in a little deeper and when I run this query direclt from 
>>> mysql (phpmyadmin) it takes 13 secs but if I remove the two fields 
>>> from oldrecstatus it only takes 3 secs. For this test I have 
>>> disabled the cache with SQL_NO_CACHE and I have only removed the two 
>>> fields (oldrecstatus.recstatus, oldrecstatus.reactivate) but have 
>>> kept the JOIN on that table.
>>>
>>> Anyone have an idea? 
>>
>> GXL, I'm assuming you're the person who submitted ticket #7604, 
>> right?  Are you seeing any issues or negative effects or UI slowness 
>> or anything?
>>
>> That query does take time.  13s could be normal or may indicate a 
>> problem on your system--depending on a lot of different factors.  
>> But, the UI should be completely disconnected from the scheduler 
>> query's execution, so it shouldn't affect anything even if it is 
>> running slow.
>>
>> Also, can you please provide the (complete) output of:
>>
>> mythbackend --version
>>
>> Please describe symptions--what do you see besides just a query being 
>> reported in the slow-query log?
> Yes it was me who entered that ticket and I was about to write a mail 
> to the list as (you?) suggested in that ticket when I saw Ronald 
> having the same issue.
>
> The frontend hangs on the confirmation message. So when I select a 
> recording to delete and I press `Yes Delete` that window will be shown 
> for about 15-20 secs. It might not sound as a long time but 20 sec 
> waiting is a long time :) That is the only thing noticable (but I 
> havent really used this version yet).

Can you run and paste the output of:

mysql -umythtv -p mythconverg -e 'SHOW INDEXES FROM oldrecorded;'

Mike


More information about the mythtv-users mailing list