You can use the storage analysis feature of DAS to view the space usage profile of a database instance, the remaining days of space available, and the space usage, space debris, and space anomaly diagnosis of a table in the database.
The storage analysis feature is only available to MySQL and MongoDB databases. MySQL databases can be ApsaraDB RDS for MySQL databases and Apsara PolarDB databases. MongoDB databases can be ApsaraDB for MongoDB databases and user-created MongoDB databases. This topic uses ApsaraDB RDS for MySQL databases to demonstrate how to use the storage analysis feature.
DAS has accessed the database instance. For more information, see Access Instance.
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
Find the target instance. Choose Performance > Storage Analysis in the Actions column.
On the Storage Analysis > Storage Overview tab, you can view data such as the storage overview and storage trend.
On the Storage Analysis > Data Space tab, you can view the storage usage of databases and tables. Click a table name to view the fields and indexes of the table.
If you have multiple database instances, you can view the storage usage of all database instances on the Global Storage Usage page, and quickly find the database instance with the highest storage usage.
The global storage usage feature is only available to ApsaraDB RDS for MySQL databases, user-created MySQL databases, ApsaraDB for MongoDB databases, and user-created MongoDB databases.
- Log on to the DAS console.
- In the left-side navigation pane, click Storage Analysis to go to the Global Storage Usage page and view related information.
The Global Storage Usage page cannot display information of database instances deployed in the direct access and centralized-mode access methods, because their storage data cannot be collected.