[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:38:15 UTC 2009

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 MIN(starttime) FROM oldrecorded WHERE recstatus NOT IN (-3, 11);


More information about the mythtv-users mailing list