Automated Table Optimizations

Benton, Kevin kevin.benton at
Fri Aug 11 15:23:35 UTC 2006

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.  This can improve performance of the back-end in tables that could potentially suffer from fragmenting (usually due to deletes followed by subsequent adds).  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 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?

Kevin Benton
Perl/Bugzilla Developer/Administrator, Perforce SCM Administrator
AMD - ECSD Software Validation and Tools
The opinions stated in this communication do not necessarily reflect the view of Advanced Micro Devices and have not been reviewed by management.  This communication may contain sensitive and/or confidential and/or proprietary information.  Distribution of such information is strictly prohibited without prior consent of Advanced Micro Devices.  This communication is for the intended recipient(s) only.  If you have received this communication in error, please notify the sender, then destroy any remaining copies of this communication.

More information about the developers mailing list