Automated Table Optimizations

David Miller justdave at
Fri Aug 11 23:06:43 UTC 2006

Benton, Kevin wrote on 8/11/06 11:23 AM:
> 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?

Yeah, we've had this going on b.m.o for a while.

[root at mrdb01 cron.weekly]# cat analyze-bugzilla-tables
# Analyze the bugzilla tables to keep the indexes performant
mysql bugs -e "analyze table `mysql bugs --skip-column-names -e 'show 
tables' | tr '\n' ',' | sed 's/,$//'`"

Dave Miller                         
System Administrator, Mozilla Corporation
Project Leader, Bugzilla Bug Tracking System

More information about the developers mailing list