After running a myth setup for a while, things tend to slow down due to cruft in the mysql database. Running this script helps a lot. A quick and dirty cron job run daily/weekly/monthly might be useful. A simple: perl /usr/share/mythtv/contrib/optimize_mythdb.pl in a crontab file should do the trick. Reproducible: Always Steps to Reproduce: n/a Actual Results: n/a Expected Results: n/a
I had previously added this to mythfilldatabase. I guess they removed it. Either way, don't you think this should be an exercise left for the user?
Was this a patch to the source? mythfilldatabase is a binary (not sure what it used to be). If it was patched source, I guess this isn't necessary...
It's nice, but I don't think it's necessary. Periodic system maintenance is the job of the user, not the ebuild, right? Anyway, if users want to maintain/optimize their database, there's a mysqlcheck command that does it without all the perl hacking. I have a cron job to run mysqlcheck --optimize --all-databases on a regular basis.
I agree with #c3