Loading...

mythtv-users@mythtv.org

[Prev] Thread [Next]  |  [Prev] Date [Next]

[mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? f-myth-users Fri Apr 06 23:00:33 2012

    > Date: Fri, 06 Apr 2012 11:05:16 -0400
    > From: "Michael T. Dean" <[EMAIL PROTECTED]>

    > 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.]
_______________________________________________
mythtv-users mailing list
[EMAIL PROTECTED]
http://www.mythtv.org/mailman/listinfo/mythtv-users