[mythtv-users] Slow MySQL query after delete

Michael T. Dean mtdean at thirdcontact.com
Wed Sep 5 17:00:03 UTC 2007

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.


More information about the mythtv-users mailing list