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

[David Brodbeck]

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'?