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.
In the left-side navigation pane, click Storage Analysis. The Storage Analysis page 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 page.
||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.
||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.
||You can view the trends of data space usage, log space usage, and write ahead log (WAL) space usage.
- 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
- 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.