(mysql.info) table-optimization

 
 5.10.4.4 Table Optimization
 ...........................
 
 To coalesce fragmented rows and eliminate wasted space that results
 from deleting or updating rows, run `myisamchk' in recovery mode:
 
      shell> myisamchk -r TBL_NAME
 
 You can optimize a table in the same way by using the `OPTIMIZE TABLE'
 SQL statement.  `OPTIMIZE TABLE' does a table repair and a key
 analysis, and also sorts the index tree so that key lookups are faster.
 There is also no possibility of unwanted interaction between a utility
 and the server, because the server does all the work when you use
 `OPTIMIZE TABLE'. See  optimize-table.
 
 `myisamchk' has a number of other options that you can use to improve
 the performance of a table:
 
    * -analyze, -a
 
    * -sort-index, -S
 
    * -sort-records=INDEX_NUM, -R INDEX_NUM
 
 For a full description of all available options, see  myisamchk.

Info Catalog

(mysql.info) repair

(mysql.info) table-maintenance

(mysql.info) table-info

automatically generated byinfo2html