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.
To analyze tables or views, perform the following actions.
- Open the Table Maintenance Wizard.
- You can optionally select Do not write binary log, if you don’t want the analyze operation to be written to binary log.
- Click Analyze and then click the Next button.
- Select tables you want to analyze and click the Execute button.
To check tables or views, perform the following actions.
- Open the Table Maintenance Wizard.
- Click Check and then click the Next button.
- Select tables and views you want to check and click the Next button.
- Select check mode and tables to check - all, changed, or tables, that have not been closed properly, and click the Execute button.
To optimize tables or views, perform the following actions.
- Open the Table Maintenance Wizard.
- You can optionally select Do not write binary log, if you don’t want the optimize operation to be written to binary log.
- Click Optimize and then click the Next button.
- Select tables you want to optimize and click the Execute button.
To repair tables or views, perform the following actions.
- Open the Table Maintenance Wizard.
- You can optionally select Do not write binary log, if you don’t want the repair operation to be written to binary log.
- Click Repair and then click the Next button.
- Select tables you want to repair and click the Next button.
- Select repair options and click the Execute button.
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.
Want to Find out More?
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?