[mythtv-users] read only tables

[Michael T. Dean]

On 10/22/06 12:13, mythtv-users wrote:

>FWIW I've got mine setup to automatically check (and repair if needed) the
>database on startup by using the command
>
>/usr/bin/mysqlcheck -r -u mythtv -pmythtv mythconverg
>
>before mythbackend starts, I did have it setup originally to detect an
>unclean shutdown but thought wtf, it's easier just to check every time as
>it adds all of about 7sec to the startup time.
>

I recommend using optimize_mythdb.pl (from the contrib directory of the 
source distribution), instead.  As it says in the comments, the 
recommended usage is as a daily cron job (and, in a cron job, can shave 
7s off the startup time for those days when you're restarting it over 
and over--i.e. for upgrades or whatever).

Mike