[mythtv-users] mysql seems crashed, and logging crashed

[Mike McMullin]

On Sat, 2013-08-31 at 20:20 -0400, Jerry wrote:
> On Sat, Aug 31, 2013 at 7:14 PM, Mike McMullin <mwmcmlln at mnsi.net>
> wrote:
>         MythTV Version : v0.25.2-15-g46cab93
>         MythTV Branch : fixes/0.25
>         Network Protocol : 72
>         Library API : 0.25.20120506-1
>         QT Version : 4.8.1
>         
>         
>         I don't have a mythconverg directory nor does a locate
>         indicate anything
>         like ./mythconverg/logging, mythfrontend staus indicates that
>         there is
>         no current data for the program guide.
>         
>         Where should I be able to find the logging, and how do I tell
>         if the
>         mysql databse is crashed or fine?

   {snip}
>         
> 
> I'd try running the optimize_mythdb.pl script.  In my system, it's
> located
> at /usr/share/doc/mythtv-docs-0.26.0/contrib/maintenance/optimize_mythdb.pl
> 
> http://v2kblog.blogspot.com/2009/03/fixing-mythtv-database-table.html
> is a page of a guy who was saved by this program with a similar
> situation to yours.
> 
> I run it every night around 3 AM as a cron job.

Look like that helped 40 minutes and I'm seeing housekeeping notices in
the log file.