[mythtv-users] Slow MySQL query after delete

[Michael T. Dean]

On 09/05/2007 12:46 PM, David Brodbeck wrote:
> So it's still there, it's just hidden.  I guess if MySQL (or MythTV)  
> quietly ran an OPTIMIZE TABLE once a week, instead of my scheduling  
> it in cron,

MythTV should be doing the OPTIMIZE, ANALYZE, and REPAIR--as well as 
doing automated backups--by 0.21.  (If I can just get some time to
finish up the patches.)

>  people would stop complaining that MySQL is a "toy"  
> database -- even though the behavior would be exactly the same. ;)

I hope you're right.

Mike