During database O&M, you need to identify and resolve storage-related issues at the earliest opportunity. You can use the storage analysis feature to view the storage usage and the number of remaining days for which storage is available on an ApsaraDB RDS for MySQL instance. This feature also allows you to view the storage usage of a specified table, tablespace fragments, and exception diagnostic results on the RDS instance. This feature helps you identify storage exceptions at the earliest opportunity to ensure database stability.
Prerequisites
The RDS instance runs RDS High-availability Edition or RDS Cluster Edition.
If your RDS instance runs RDS Basic Edition, you can perform storage analysis in the Database Autonomy Service (DAS) console. For more information, see Storage analysis.
Background information
The storage analysis feature allows you to view the storage usage and the number of remaining days for which storage is available on an RDS instance. This feature also allows you to view the storage usage of a specified table, tablespace fragments, and exception diagnostic results 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 Services > 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.Storage Analysis
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 move your pointer over
to view the details of 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 database instance and the usage of tablespaces in the database.
You can click the name of a table to view the Field and Index of the table.
References
If you enable the automatic storage expansion feature for an RDS instance, the system automatically expands the storage capacity when the available storage reaches the specified threshold. For more information, see Use the automatic storage expansion feature.
If you enable the automatic fragment reclamation feature for an RDS instance, the system automatically reclaims the tablespace fragments in a table when a metric such as the tablespace size or the fragmentation percentage of the table reaches the specified threshold. For more information, see Use the automatic fragment reclamation feature.
For information about storage analysis in other database engines, see the following topics: