Maintaining a Table
While working with MySQL databases, you do a lot of changes such as data insert, update, and deletion, which may cause table fragmentation. As a result, the database server performance is deteriorated. To handle this, periodic maintenance is required.
You have logged in to a DDM DB instance on the DAS console.
During the optimization, a read-only lock will be added to target tables. Therefore, optimizing tables during off-peak hours is recommended.
The following operations show how to optimize a database table. The procedure for analyzing tables is similar.
- On the top menu bar, choose Database Management.
- On the displayed Objects page, select Tables, locate the target table, and choose More > Maintain > Optimize in the Operation column.
- In the displayed dialog box, click Yes.