Storage Analysis

Checking the Storage Overview

1. Log in to the console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner, and under Databases, click Data Admin Service.
4. In the navigation pane, choose Intelligent O&M > Instance List.

   Alternatively, on the Overview page, click Go to Intelligent O&M.

5. In the upper right corner of the Instance List page, search for instances by engine type, instance name, or instance IP.
6. Locate the target instance and click Details. The Dashboard page is displayed.
7. Click the Storage Analysis tab and check information in the Overview area. If the capacity is insufficient, scale up the storage or enable autoscaling.
   Figure 1 Overview
   

   If the average daily increase in last week is 0 GB, the estimated available days of storage are unlimited and are not displayed.

   If the total number of files in your storage (including data space, binlog space, slow query log space, relay log space, audit log space, temporary space, and other space) exceeds 10,000, DAS will not collect information about the files or display space distribution and usages over time on the console. This prevents performance slowdowns caused by collecting statistics on too many files. If this happens, submit a service ticket.

   • Data: Disk space occupied by user data (including temporary table files and ib_logfile files generated by the database)
   • Binlogs: Disk space occupied by binlogs
   • Slow query logs: Disk space occupied by slow query logs
   • Relay logs: Disk space occupied by relay logs
   • Audit logs: Disk space occupied by audit logs
   • Temporary space: Disk space occupied by temporary files
   • Other: Disk space occupied by files such as ibdata1, ib_buffer_pool, ib_doublewrite, and error.log, plus the reserved space (about 5% of the disk space) for OS

Tablespaces

DAS can diagnose tables with abnormal tablespace growth, tables without primary keys, and tables without indexes. To use this function, subscribe to Intelligent O&M first.

1. Click the Storage Analysis tab to view abnormal tables.
   Figure 2 Tablespaces
   

2. Click Subscribe. In the displayed dialog box, you can learn about enhanced features and billing rules.
   Figure 3 Subscribing to Intelligent O&M
   

3. After subscribing to Intelligent O&M, view the table diagnosis results of your instance.
   Figure 4 Table diagnosis results
   

4. Click next to Auto Diagnosis. In the displayed dialog box, configure the daily tablespace increase limit and click OK.
   Figure 5 Configuring a daily tablespace increase limit
   

Viewing the Disk Space Change Trend

You can check the storage usage over time of your instance.

Figure 6 Disk space distribution

Top Databases and Tables by Physical File Size

You can view the top 50 databases and tables by physical file size and identify the databases and tables with high usage based on storage space distribution.

Figure 7 Top 50 databases and tables

Click View Chart to view data volume changes in the last 7 days, last 30 days, or a custom time period (spanning no more than 30 days).

Figure 8 Viewing the trend

• DAS collects data at about 04:00 every day.
• 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 reserved special characters, including slashes (/) and #p#p, is not counted.
• Currently, only RDS for MySQL 5.7 and 8.0 are supported.
• If your instance's memory usage is greater than 85% or it has more than 50,000 tables, DAS will not collect related information. This prevents performance slowdowns caused by collecting statistics on too many databases and tables.
• Some statistics may be missing because of database or table data fluctuations.