optimize_mythdb.pl (was 0.19 Program Guide slowness...)

["Michael T. Dean" <mtdean (at) thirdcontact.com>]

On 02/23/2006 06:06 PM, Phill Edwards wrote:

>>i have a cron job that goes through CHECK TABLE, REPAIR TABLE, OPTIMIZE
>>TABLE, and ANALYZE TABLE every night (i think, maybe every week) on all
>>servers that host any coding projects (i am our head php/mysql
>>developer) ... i've noticed a DEFINITE performance increase since i
>>started doing this
>>    
>>
>So would it come after the Optimise and look like this?
>
># Repair and optimize each table
>    foreach $table ( (at) tables) {
>        unless ($dbh->do("REPAIR TABLE $table")) {
>            print "Skipped:  $table\n";
>            next;
>        };
>        if ($dbh->do("OPTIMIZE TABLE $table")) {
>            print "Repaired/Optimized: $table\n";
>        }
>        if ($dbh->do("ANALYZE TABLE $table")) {
>            print "Analysed: $table\n";
>        }
>    }
>  
>

Just thought I'd mention that Chris Petersen wrote a script that does 
all of this except the analyze step.  The script is in the source 
package at contrib/optimize_mythdb.pl and includes comments which 
describe how to set it up.

Chris, any comments on the addition of the analyze table stuff?

Mike

_______________________________________________
mythtv-users mailing list
mythtv-users (at) mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users