Performing Maintenance and Flush Operations

Last modified: June 26, 2023

dbForge Fusion for MySQL Table Maintenance Wizard and Flush dialog box allow you to perform table maintenance and flush operations. To open the Table Maintenance Wizard, on the Fusion menu, point to MySQL, and then click Table Maintenance. To open the Flush dialog box, point to MySQL, and then click Flush.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. These elements are determined by your Visual Studio edition and settings. For more information, see Visual Studio Settings.

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.