(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
automatically generated byinfo2html