[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 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