Viewing Top Databases and Tables by Physical File Size

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
4. On the Instances page, click the DB instance name.
5. In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
6. Click the Storage Analysis tab to view top 50 databases and tables.
   Figure 1 Top 50 databases and tables
   
   

   • Physical file sizes are precisely recorded, but other fields' values are estimated. If there is a large gap between a file size and another field, run ANALYZE TABLE on the table.
   • A database or table whose name contains special characters, including slashes (/) and #p#p, is not counted.
   • If there are more than 50,000 tables in your instance, to prevent data collection from affecting the instance performance, top databases and tables will not be counted.

7. Locate a database and click View Chart in the Operation column. You can view data volume changes in the last 7 days, last 30 days, or a custom time period (spanning no more than 30 days).
   Figure 2 Database Data