Database Autonomy Service (DAS) provides the storage analysis feature. You can use this feature to view the storage usage of a database instance and the number of days for which the remaining storage space is available. You can also view information about the usage, fragments, and anomaly diagnosis results of a tablespace in a database. This topic provides an example to describe how to use the storage analysis feature. In this example, an ApsaraDB RDS for MySQL instance is used.

Procedure

In the left-side navigation pane, click Storage Analysis. The Storage Analysis tab appears. On the Storage Overview and Data Space tabs, you can view information about the storage usage of the database instance, such as information about anomalies and the trend chart of space usage. The following table describes the parameters on the Storage Analysis tab.
Parameter Description
Storage Overview You can view information such as the average daily space usage within the previous seven days, the number of days for which the remaining storage space is available, and the total amount of used space.
Data Space You can view the usage of each data space and each tablespace. You can click the name of a table to view the fields and indexes of the table.
Storage Trend You can view the trends of data space usage, used space usage, log space usage, and temporary space usage.
Exceptions
  • Potential auto-increment primary key overflows: DAS can automatically identify potential overflows of auto-increment primary keys in ApsaraDB RDS for MySQL databases and ApsaraDB PolarDB MySQL-compatible edition databases.
  • Duplicate indexes: DAS can automatically identify duplicate indexes in ApsaraDB RDS for MySQL databases and ApsaraDB PolarDB MySQL-compatible edition databases.
  • Tablespace fragments: For more information, see Automatic space fragments recycling.
  • Abnormal SQL requests: For more information, see Abnormal SQL request identification.