[mythtv-users] REPAIR/OPTIMIZE in HouseKeeper (was Re: Running optimize_mythdb.pl before mythfilldatabase)

[Michael Heironimus]

On Thu, Feb 22, 2007 at 08:40:09PM -0400, Greg Estabrooks wrote:
> > as per the discussion of a few weeks ago], and MySQL's need for
> > constant maintenance (*), I really wish it was possible to use any
> 
> 
>  You know, it's funny. I've been using mysql "professionally" in my day to 
> day work, on literally hundreds of machines including my own  on everything
> from tiny to massive databases and I have never had to do more than a repair 
> on a table when a machine lost power mid disk write.  The only time I've had 
> anything "Weird" happen and got "spontaneous" corruption was what turned out
> to be a XFS bug causing data corruption all over the partition.

I can't explain why (not that I've really tried to figure it out), but
I've seen more issues with my MythTV database running on Linux/ext3 than
with all the other MySQL databases I've supported combined. Including
some with far more activity on less common platforms.

-- 
Michael Heironimus