[mythtv-users] REPAIR/OPTIMIZE in HouseKeeper (was Re: Running optimize_mythdb.pl before mythfilldatabase)
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