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.

  1. Open the section "Databases".
  2. Expand the menu of the database whose tables you want to optimize and click "Optimize tables":
  3. Clickon "Continue":
  4. Wait about 5-10 minutes.