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
- MySQL 8.0 on RDS High-availability Edition or RDS Enterprise Edition
- MySQL 5.7 on RDS High-availability Edition or RDS Enterprise 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
- Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
- In the left-side navigation pane, choose .
- 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. Exceptions You can view the exception information about tables or collections in the RDS instance. You can click Automatic Space Optimization to enable the automatic storage expansion feature for the RDS instance. If the storage capacity of the RDS instance is insufficient, the system automatically expands the storage capacity. This ensures business stability.
You can click Optimization History to view the storage optimization history of the RDS instance.
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 fragments: For more information, see Use the automatic fragment reclamation feature for an ApsaraDB RDS for MySQL instance.
Storage Trend You can view the storage trend of the RDS instance in the most recent week. 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 fields and indexes 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 fields and indexes of the table.