0.19 Program Guide slowness...

["gLaNDix (Jesse Kaufman)" <glandix (at) lloydnet.org>]

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";
>         }
>     }

looks good to me! :)


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