|
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
- [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? Craig Huff 2012/04/06
- Re: [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? Michael T. Dean 2012/04/06
- Re: [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? Craig Huff 2012/04/06
- Re: [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? Michael T. Dean 2012/04/06
- [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? f-myth-users 2012/04/06 <=
- Re: [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? Michael T. Dean 2012/04/07
- [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? f-myth-users 2012/04/07
- Re: [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? James Linder 2012/04/06
- Re: [mythtv-users] Must mythbackend be running when executing optimize_mythdb.pl and/or mythlink.pl? Michael T. Dean 2012/04/07