Performing Maintenance and Flush Operations

dbForge Studio for MySQL Table Maintenance Wizard and Flush dialog box allow you to perform table maintenance and flush operations. To open Table Maintenance Wizard, select Table Maintenance from the Database menu. To open the Flush dialog box, select Flush from the Database menu.

Performing Analyze Operation

To analyze tables or views, perform the following actions.

  1. Open the Table Maintenance Wizard.
  2. You can optionally select Do not write binary log, if you don’t want the analyze operation to be written to binary log.
  3. Click Analyze and then click the Next button.
  4. Select tables you want to analyze and click the Execute button.

Performing Check Operation

To check tables or views, perform the following actions.

  1. Open the Table Maintenance Wizard.
  2. Click Check and then click the Next button.
  3. Select tables and views you want to check and click the Next button.
  4. Select check mode and tables to check - all, changed, or tables, that have not been closed properly, and click the Execute button.

Performing Optimize Operation

To optimize tables or views, perform the following actions.

  1. Open the Table Maintenance Wizard.
  2. You can optionally select Do not write binary log, if you don’t want the optimize operation to be written to binary log.
  3. Click Optimize and then click the Next button.
  4. Select tables you want to optimize and click the Execute button.

Performing Repair Operation

To repair tables or views, perform the following actions.

  1. Open the Table Maintenance Wizard.
  2. You can optionally select Do not write binary log, if you don’t want the repair operation to be written to binary log.
  3. Click Repair and then click the Next button.
  4. Select tables you want to repair and click the Next button.
  5. Select repair options and click the Execute button.

Performing Flush Operation

To perform flush operation, open the Flush dialog box, select items to flush, and click the OK button. To perform flush operation over a single table, right-click the table in Database Explorer and select Flush on the shortcut menu.