Setting a Diagnosis Threshold

You can set a diagnosis threshold to identify abnormal tables whose tablespace is above the threshold.

To use this function, you need to subscribe to Intelligent O&M first. For details, see Subscribing to Intelligent O&M.

Log in to the management console.
Click in the upper left corner and select a region and a project.
Click in the upper left corner of the page and choose Databases > Relational Database Service.
On the Instances page, click the DB instance name.
In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
Click the Storage Analysis tab to view the table diagnosis results of your instance.

Figure 1 Table diagnosis results
Click next to Auto Diagnosis. In the displayed dialog box, configure a daily tablespace increase limit. The value ranges from 1 to 100,000,000, in MB.

Figure 2 Configuring a daily tablespace increase limit
Click OK. The system automatically identifies the tables whose tablespace exceeds the specified threshold in the past day and counts the number of those tables in the Tablespaces area.
Click a number and view the details about abnormal tables on the Diagnosis Details page.

Figure 3 Diagnosis details

Q: What can I do if there are tables whose tablespace has grown abnormally in the past day?
A: Check tablespace fragmentation and reclaim fragmented space. Do not use DELEDTE to clear data. If you have any other questions, submit a service ticket to contact customer service.
Q: What is the impact of tables without primary keys on my DB instance?
A: Tables without primary keys can cause slow SQL statements, affecting instance stability. You are advised to add primary keys to such tables to reduce the primary/standby replication delay.
Q: What is the impact of tables without indexes on my DB instance?
A: Tables without indexes can cause slow SQL statements, affecting instance stability. You are advised to add indexes to table fields for more efficient query.