With DBbrain's space analysis feature, you can view the instance space utilization, including the sizes of data and logs, the daily increase in space utilization, the estimated number of available days, and the space used by the tables and databases of the instance.
DBbrain starts an automatic collection and analysis task for all instances every day at midnight. After the collection and analysis of an instance are completed, the data on the instance's Space Analysis page is refreshed with the latest information of the day.
2. In the left sidebar, choose Performance Optimization.
3. At the top of the page, select the database type and instance ID, and select the Space Analysis tab.
4. View the disk space.
5. On the Space Analysis page, you can view the average daily growth for the past week, remaining disk space, estimated available days, daily disk space distribution, and the disk space trend table for the past 30 days.
Remaining disk space = Purchased disk space - Data space
Viewing TOP Table Space
The TOP table shows details of the current large tables, including collection name, collection space, physical file size, index space, data space, compression rate, average length, and number of collection rows. It supports sorting by specified fields in descending order. You can use this information to understand disk space usage and optimize promptly.
Note:
TOP tables/databases collect data once daily by default.
2. In the left sidebar, choose Performance Optimization.
3. At the top of the page, select the database type and instance ID, and select the Space Analysis tab.
4. Select the Top Tables tab, and select sort fields (descending order), including collection space, physical file size, index space, data space, compression ratio, average length, and number of set rows, to view the TOP table list.
5. Click the data rows in a TOP table to view the trend chart and table information.
Trend chart: It includes the trend chart of physical file size (physical file size, number of set rows), and space usage (collection space, index space, data space).
Table information: Display the index information of the table.
6. (Optional) Click
in the top-right corner of the list to download the data of TOP tables in .csv format.
Viewing TOP Database
The TOP database space shows details of the current large databases, including physical file size, index space, data space, average length, and number of set rows. It supports sorting by specified fields in descending order. You can use this information to understand disk space usage and optimize in a timely manner.
2. In the left sidebar, choose Performance Optimization.
3. At the top of the page, select the database type and instance ID, and select the Space Analysis tab.
4. Select the Top Databases tab, and select sort fields (descending order), including physical file size, data space, index space, average length, and number of set rows, to view the TOP database list.
5. Click the data rows in a TOP database to view the trend chart.
The trend chart includes the trend chart of physical file size (physical file size and number of set rows), and space usage (collection space, index space, and data space).
6. (Optional) Click
in the top-right corner of the list to download the data of TOP database in .csv format.
