All Products
Search

This Product

    ApsaraDB for OceanBase:Capacity center

    Document Center

    ApsaraDB for OceanBase:Capacity center

    Last Updated:Feb 22, 2024

    This topic describes how to use the capacity center. You can view the resource usage information and usage trends of clusters, tenants, databases, tables, and indexes in the capacity center to identify capacity risks and perform scale-up in a timely manner.

    Procedure

    1. Log on to the ApsaraDB for OceanBase console.

    2. In the left-side navigation pane, click OceanBase Autonomy Service.

    3. In the Instance Details section, click the name of the target cluster instance.

    4. In the left-side navigation pane, click Capacity Center to view relevant information on the Capacity Center page.

    View information on the Capacity Center page

    1. View the capacity risk prompts of the cluster.容量风险

    2. View the CPU utilization, memory usage, storage usage, and log disk usage.

      Note

      At present, the log disk usage can be displayed only in ApsaraDB for OceanBase V4.x.

      1Click View Usage Trends. In the dialog box that appears on the right, select a period to view the disk usage trend.

    3. View the capacity usage details of tenants within the last seven days, including the CPU utilization, memory usage, storage usage, log disk usage, and number of connections. A capacity metric that is considered risky is displayed in red.租户使用明细

    4. View the capacity of tenants.

      1. After you select a tenant, you can filter the data of the tenant by database or table.2

        You can view the trends of CPU utilization, memory usage, storage usage, log disk usage, and number of partition replicas over time. You can select Last 7 Days, Last 14 Days, or Last 30 Days or specify a custom period as the time range to view the status of a specified tenant, database, or data table.

        3

      2. You can view the top 10 databases with the highest disk usage on the right side. You can click the triangle before a database to view the sizes of disk space occupied by data and indexes in the database.

        image.png

        Click Details or a database name to view details about the distribution of table data in the database. You can view information about each table in the following columns: Table Name, Number of Rows, Disk Usage, Data Size, and Macro block usage ratio.

        image.png

    5. View the capacity of the cluster.

      1. If you select All Tenants, you cannot filter the data by database or data table. Instead, you can view the storage usage, number of partition replicas, CPU utilization, and memory usage of different tenants in the cluster in charts.

      2. You can view the top 10 tenants with the highest disk usage on the right side. You can click the triangle before a tenant to view sizes of disk space occupied by data and indexes in the tenant.

        3

        Click Details or a tenant name to view details about the distribution of table data in different databases in the tenant. You can view information about each table in the following columns: Table Name, Number of Rows, Disk Usage, Data Size, and Macro block usage ratio.

        Note

        • At present, the number of rows in a table cannot be obtained in ApsaraDB for OceanBase V4.x.

        • The minimum granularity for displaying data is 0.01 GB. Data with a size less than 0.01 GB is displayed as 0 GB in size.