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.
  1. Open the section «Databases».
  2. Expand the database menu and click «Optimize tables»:
  3. Click «Continue».
  4. Wait about 5-10 minutes.

Completion notification sent to mail and in Telegram.