2.6.1.1.8. Optimize database tables

During optimization, the size of the database may temporarily increase.

Optimization is an attempt to reorganize the physical space used by database tables and indexes. It can help to reduce the used space and slightly improve performance. The standard OPTIMIZE TABLE command is used for optimization (see official MySQL documentation).

  1. Open the "Databases" section.
  2. In the database menu, click "Optimize tables":
  3. Confirm the operation with the button in the window.
  4. Wait for the operation to complete (usually 5-10 minutes).
Content

    (1)