Space Analysis

Last updated: 2020-06-03 10:56:06

    Using the capacity analysis feature of DBbrain, you can view the instance capacity utilization, including the sizes of data and log capacities, the daily increase in capacity utilization, the estimated number of available days, and the capacity used by tablespaces under the instance.

    Currently, capacity analysis is supported only for TencentDB for MySQL (excluding the Basic Edition).

    Disk Capacity

    Log in to the DBbrain Console, select Diagnosis and Optimization on the left sidebar, and select Space Analysis at the top.
    On the capacity analysis page, you can view the comparison of daily increases in the last week, the available disk capacity, the estimated number of available days, and the trend in disk capacity usage in the last week.

    Top Tablespaces

    The Top Tablespaces section displays the details of your tables that have relatively high capacity usage, including the storage engine, number of rows, total used capacity, data capacity, index capacity, fragment capacity, and fragment percentage. Each column of data can be sorted in ascending or descending order. You can view the disk capacity usage details in this section and perform optimization promptly.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help