Automated Table Optimizations
mkanat at bugzilla.org
Fri Aug 11 22:15:56 UTC 2006
On Fri, 2006-08-11 at 08:23 -0700, Benton, Kevin wrote:
> I just learned that doing either CHECK TABLE or ANALYZE TABLE can do a
> lot for us in optimizing disk space utilization as well as indexing of
> tables in MySQL.
Yep. And on PostgreSQL, VACUUM ANALYZE (or VACUUM FULL ANALYZE, if you
have more time).
It's even more important on Postgres than on MySQL.
> I think it'd be a good idea to recommend that users implement a cron
> job that does these operations on a weekly-monthly basis in an
> optimization section of the manual.
I also considered adding a ./checksetup.pl --optimize switch. There's a
bug filed on it.
> I also think it'd be good to document (if we don't already) how to set
> up MySQL replication in a similar section. What do others think about
Sounds like a good idea. :-)
Competent, Friendly Bugzilla Services. And Everything Else, too.
More information about the developers