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

David Brodbeck gull at gull.us
Fri Feb 23 22:44:09 UTC 2007

David Campbell wrote:
> I have never heard of daily optimisation to get MYSQL to perform and I 
> look after a few 100 req/sec installs.

MythTV is the first application I've seen where daily optimization is
recommended, and I've worked with some pretty sizable MySQL databases. 
I don't know if its database utilization is really atypical or what the
issue is.  If we switch to PostgreSQL, I wonder if we'll see the same
issues, just with people running 'vacuum' instead of 'optimize'?

More information about the mythtv-users mailing list