Last Updated: February 25, 2016
·
549
· peterpengnz

Mysql optimize table query

If the table has been recently changed the string type column length or large number of records have been deleted, it would be good to run optimise table query. See Mysql Doc for details.

For example:

mysql> optimize table change_logs;