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 expected number of days after which the remaining storage may be insufficient. You can also view information about the storage 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.
- An ApsaraDB RDS for MySQL instance
- An ApsaraDB PolarDB MySQL-compatible edition instance
- An ApsaraDB for MongoDB instance
- A self-managed MongoDB instance
View global storage usage
If you use DAS to manage multiple database instances of the same type, you can view the storage usage of each database instance on the Global Storage Usage page. This can help you find the database instance that has the highest storage usage.
View the storage analysis results of a single database instance
- On the Instance Monitoring page, find the database instance that you want to manage and choose in the Actions column.
- On the Storage Analysis page, you can view the storage overview, usage of data space, exceptions, and storage usage trends of the instance. The following table describes the parameters.
Parameter Description Storage Overview You can view information such as the average daily space usage within the last week, the estimated remaining days available, and the total amount of used space. Data Space You can view the usage of each data space and tablespace. You can click the name of a table to view the fields and indexes of the table. Storage Trend You can view the usage trends of data space, used storage, log space, and temporary space. Exceptions
- Auto-increment primary key overflow risks: DAS can automatically identify potential auto-increment primary key overflow risks 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 tablespace fragment recycling.