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.
NoteYou 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.
NoteThe 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.