Storage Analysis

Checking the Storage Overview

1. Log in to the DAS console.
2. Click in the upper left corner and select a region and project.
3. In the navigation pane, choose Intelligent O&M > Instance List.

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

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

   Avg. daily increase in last week = (Current space usage – Previous space usage)/7

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

   • Data: disk space occupied by user data
   • Binlogs: disk space occupied by binlogs
   • Temporary space: disk space occupied by temporary files

Used Storage over Time

You can view the used storage over time.

Figure 2 Viewing Disk Space Distribution

• Data space: Disk space occupied by user data
• Binlog: Disk space occupied by binlogs
• Temporary space: Disk space occupied by temporary files

Tablespaces

You can view tables with abnormal tablespace growth, tables without primary keys, and tables without indexes through automated or manual diagnosis.

If there are more than 5,000 tables or the vCPU usage exceeds 90%, manual diagnosis is not supported.

1. In the Abnormal Tables area, click Subscribe.
   Figure 3 Abnormal Tables
   

2. In the Subscribe to Intelligent O&M dialog box, confirm the information, select the agreement, and click Subscribe.
   Figure 4 Subscribing to Intelligent O&M
   

3. In the Tablespaces area, view table diagnosis results.
   Figure 5 Viewing table diagnosis results
   

   Both automated diagnosis and manual diagnosis are supported.

   • Automated diagnosis

     Tables in the Top 50 Tables area are automatically diagnosed at about 04:00 every day.

     In the left part of the Tablespaces area, you can view tables whose tablespace has grown abnormally in the past day. You can click the number to view the diagnosis details and handle the abnormal tables based on the suggestions provided.

     Figure 6 Viewing diagnosis details
     

     Any table whose tablespace has grown by more than 10,240 MB in the past day is counted. You can also click next to Auto Diagnosis to set the upper limit for daily tablespace increase.

     Figure 7 Setting the upper limit
     
   • Manual diagnosis

     Click Re-diagnose to manually trigger a diagnosis task. This operation can be performed every 10 minutes. The diagnosis scope is not limited.

     Once the diagnosis is complete, you can view the numbers of tables without primary keys and tables without indexes. You can click a number to view the diagnosis details and handle the abnormal tables based on the suggestions provided.

     Figure 8 Viewing diagnosis details
     

Top Databases and Tables

1. Click next to Collect Top Databases and Tables to enable the function.

   The system automatically collects data of top 50 databases and tables at about 04:00 every day.

   Figure 9 Enabling Collect Top Databases and Tables
   

2. View the top 50 databases and tables by physical file size and identify the databases and tables with high usage based on disk space distribution.
   Figure 10 Viewing 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 reserved 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.
   • Some statistics may be missing because data of databases or tables is fluctuating.

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