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

f-myth-users at media.mit.edu f-myth-users at media.mit.edu
Fri Feb 23 02:51:15 UTC 2007


    > Date: Thu, 22 Feb 2007 20:40:09 -0400
    > From: Greg Estabrooks <greg at phaze.org>

    > > solved decades ago.  Unfortunately, between MySQL's whole-table-locking

    >  You can avoid this by using innodb instead of myisam as has been 
    > mentioned before on this list. Though I agree, since most are using myisam
    > we definately want to avoid having the database writes done the way they are
    > now.

And if this is really the solution, why does Myth not do this
automatically when creating the DB?  Why do its various installation
pages not recommend this?  I'm guessing there are other gotchas
associated with going to innoDB, but I haven't researched it
carefully.


More information about the mythtv-users mailing list