[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