On Thu, Apr 28, 2005 at 07:39:47PM -0700, Chris Petersen wrote: > Since I've posted this everywhere else (and probably here before, > too), feel free to take a look at this: > > http://forevermore.net/files/mythtv_misc/optimize_mythdb.pl.txt > > It loads the mysql.txt file from your mythtv installation, connects > to mysql, and repairs and optimizes ALL of the tables. Add it to a > daily cron job and you'll not only be assured of your tables being > repaired if you're not there to watch them, but it'll keep your disk > space optimized (the recordedmarkup and program tables are > especially good at growing larger than the data they store).
Why not just incorporate this into the built-in myth timer stuff (a la the internally-scheduled mythfilldatabase)? --Rob
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users