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: