[mythtv-users] 0.19 Program Guide slowness...

gLaNDix (Jesse Kaufman) glandix at lloydnet.org
Thu Feb 23 23:33:18 UTC 2006


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 (@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-


More information about the mythtv-users mailing list