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

[GXL.nl]

Michael T. Dean said the following on 19/11/09 21:38:
> On 11/19/2009 03:27 PM, GXL.nl wrote:
>> 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?
> 
> mysql -umythtv -p mythconverg -e
> 
> cat << "EOF" | mysql -umythtv -p mythconverg
> SELECT COUNT(*) FROM oldrecorded;
> SELECT NOW();
> SELECT MIN(starttime) FROM oldrecorded WHERE recstatus NOT IN (-3, 11);
> EOF
> 
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
$ cat << "EOF" | mysql -umythtv -p mythconverg
 > SELECT COUNT(*) FROM oldrecorded;
 > SELECT NOW();
 > SELECT MIN(starttime) FROM oldrecorded WHERE recstatus NOT IN (-3, 11);
 > EOF
Enter password:
COUNT(*)
4226
NOW()
2009-11-19 21:57:21
MIN(starttime)
2009-11-08 19:40:00