[mythtv-users] Table './mythconverg/recorded' is marked as crashed and should be repaired

[Brad DerManouelian]

On Oct 23, 2006, at 3:52 AM, Stephen Robertson wrote:

> >>
> >I found it, its called optimize_mythdb.pl and it fixed the problem.
> >
> >
> And, now that you found it, you should set it up as a daily cron  
> job, as
> described in the comments at the top of the script.
>
> Before anyones takes this the wrong way, this is a question from  
> someone who doesn't really know what they are talking about, rather  
> than a complaint!  Is there no way to remove the need for a cron  
> job to be manually created to do this?
>
> Stephen

All databases need to be optimized in order to achieve best  
performance. Unfortunately, all databases can become corrupt. It's  
impossible for an application to know when this has happened, so best  
to check every so often. Easiest way to do that is with a cron job.  
Takes about 30 seconds to set up and you don't have to think about it  
again after that (except when you upgrade you might have to change  
the path to the script). It has very little to do with MythTV and  
everything to do with MySQL.