Optimization is an attempt to reorganize the physical space occupied by database tables and indexes. It can help reduce the footprint and slightly improve performance. For optimization, the standard command is used
OPTIMIZE TABLE from MySQL syntax. A detailed description of this function can be found in documentation to MySQL.
To optimize your database tables, do the following: