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

[Michael T. Dean]

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?

Thanks,
Mike