[mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl?
Michael T. Dean
mtdean at thirdcontact.com
Sat Apr 7 14:28:50 UTC 2012
On 04/07/2012 01:47 AM, f-myth-users at media.mit.edu wrote:
> > Date: Fri, 06 Apr 2012 11:05:16 -0400
> > From: "Michael T. Dean"<mtdean at thirdcontact.com>
>
> > Also, the only reason we don't automatically run optimize_mythdb.pl type
> > functionality (repair/analyze/optimize)--we already have code in MythTV
> > to do it all--is because if it were being run and the MySQL server
> > crashes (mysqld crash/power outage/full file system/...) during a table
> > repair, it's critical that a repair is run, again, after restarting the
> > server and before any client attempts to read any data from the table
> > that was being repaired--otherwise, you could lose all of the data in
> > the table.
>
> That's some gotcha. Is this documented anywhere? Can a query,
> even of a damaged table, result in a write?
>
> [I've been lucky enough never see a crash -during- a table repair,
> in or out of Myth.]
Yep. It's documented on the MySQL site. :)
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
Mike
More information about the mythtv-users
mailing list