(mysql.info.gz) Optimization

Info Catalog

(mysql.info.gz) Repair

(mysql.info.gz) Table maintenance

 
 5.7.3.10 Table Optimization
 ...........................
 
 To coalesce fragmented records and eliminate wasted space resulting from
 deleting or updating records, run `myisamchk' in recovery mode:
 
      shell> myisamchk -r TBL_NAME
 
 You can optimize a table in the same way by using the SQL `OPTIMIZE
 TABLE' statement.  `OPTIMIZE TABLE' does a repair of the table and a key
 analysis, and also sorts the index tree to give faster key lookups.
 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'.  `OPTIMIZE TABLE' OPTIMIZE TABLE.
 
 `myisamchk' also has a number of other options you can use to improve
 the performance of a table:
 
    * `-S', `--sort-index'
 
    * `-R INDEX_NUM', `--sort-records=INDEX_NUM'
 
    * `-a', `--analyze'
 
 For a full description of the options, see  myisamchk syntax.
 

Info Catalog

(mysql.info.gz) Repair

(mysql.info.gz) Table maintenance