This is similar to vacuum in PostgreSQL. While MySQL knows to recycle disk space for rows when inserting new data, if the table has been considerably reduced in size, then optimize should be run.
E.g.
OPTIMIZE TABLE tableName1,tableName2;
Reference: http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
No comments:
Post a Comment