[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 19:33:15 UTC 2009
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):
> 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:
Please describe symptions--what do you see besides just a query being
reported in the slow-query log?
More information about the mythtv-users