Automated Table Optimizations

[Max Kanat-Alexander]

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

	Sounds like a good idea. :-)

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla Services. And Everything Else, too.