Use the storage analysis feature - ApsaraDB RDS - Alibaba Cloud Documentation Center

Database Autonomy Service (DAS) provides the storage analysis feature for ApsaraDB RDS for MySQL. This feature allows you to view the storage usage and the number of remaining days for which storage is available of your ApsaraDB RDS for MySQL instance. This feature also allows you to view the storage usage, fragmentation, and exception diagnostic results of a table on the RDS instance. This feature helps you identify storage exceptions at the earliest opportunity to ensure database stability.

Prerequisites

Your RDS instance runs one of the following MySQL versions and RDS editions:

MySQL 8.0 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.7 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster Edition
MySQL 5.6 on RDS High-availability Edition
MySQL 5.5 on RDS High-availability Edition

Background information

The storage analysis feature allows you to view the storage usage and the number of remaining days for which storage is available of your ApsaraDB RDS for MySQL instance. This feature also allows you to view the storage usage, fragmentation, and exception diagnostic results of a table on the RDS instance.

Usage notes

You can use the storage analysis feature to analyze up to 20,000 tables.

Procedure

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, choose Autonomy Service > Diagnostics.
On the page that appears, click the Storage Analysis tab.

On the Storage Overview and Data Space tabs, view the storage usage of the RDS instance.

Tab	Section	Description
Storage Overview	Storage	You can view the following storage information: Exception, Avg Daily Increase in Last Week, Available Days of Storage, and Used Storage. Note You can click the icon to view details about each item.
	Exceptions	You can view the exception information about tables or collections in the RDS instance. If the automatic space optimization feature is enabled for the RDS instance, you can also view the space optimization history.Exceptions DAS can identify the following exceptions: Potential overflows of auto-increment primary keys: DAS automatically identifies potential overflows of auto-increment primary keys in the RDS instance. Duplicate indexes: DAS automatically identifies duplicate indexes in the RDS instance. Tablespace fragment identification: For more information, see Automatic tablespace fragment recycling.
	Storage Trend	You can view the storage change trend in a specific period of time. Note The period of time can span a maximum of seven days.
	Tablespaces	You can view information such as the storage usage of each table on the RDS instance. You can click the name of a table to view the Field and Index of the table.
Data Space		You can view the storage usage of each database in the RDS instance and the storage usage of tables in the database. You can click the name of a table to view the Field and Index of the table.