2.6.1.1.8. Optimizing database tables
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.
During optimization, the size of the database may temporarily increase.
- Open the section «Databases».
- Expand the database menu and click «Optimize tables»:
- Click «Continue».
- Wait about 5-10 minutes.