bjm at lvcm
Nov 30, 2004, 1:07 PM
Post #3 of 3
(800 views)
Permalink
|
Chris Petersen wrote:
> Beirdo was chatting in #mythtv-users about how he saved a bunch of disk
> space by optimizing his mysql databases. I happened to have a script
> that does this kind of thing, along with repairing any necessary tables,
> too.
>
> Anyway, I added in some code from nuvexport to auto-detect the database
> parameters from myth's mysql.txt, and posted it here:
>
> http://forevermore.net/files/optimize_mythdb.pl.gz
"mysqlcheck" "-r" and "-o" will act on all of the tables without
a script to find the table names.
> If there isn't already something like this in contrib, it would be nice
> to get this one checked in (or even better, have this kind of
> functionality built into myth itself).
The built-in function to automatically run mythfilldatabase asks
for "mythfilldatabase Path:". This could be anything but it expects
the status to be updated in the settings table as a result. You
could simply have it call a small script something like this:
#!/bin/sh
mysqlcheck -r -u mythtv -pmythtv mythconverg > /dev/null 2>&1
mythfilldatabase
mysqlcheck -o -u mythtv -pmythtv mythconverg > /dev/null 2>&1
-- bjm
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
|
