Help Center/ GaussDB(for MySQL)/ User Guide/ Instance Management/ Viewing the Dashboard
Updated on 2024-09-24 GMT+08:00
View PDF
Share

Viewing the Dashboard

The Dashboard page allows you to monitor GaussDB(for MySQL) instance statuses.

  • You can view the real-time performance metric data and trends of all instances in your account. This allows you to quickly identify and address any abnormal instances.
  • You can also view the historical performance metric data.

Viewing Real-Time Metrics

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
  4. In the navigation pane, choose Dashboard.
  5. View the real-time performance metrics of a created GaussDB(for MySQL) instance under the current account.
    Figure 1 Viewing real-time metrics

    Table 1 Parameter description

    Parameter

    Description

    Node Name/ID

    Only monitoring data for the nodes of a created GaussDB(for MySQL) instance is displayed.

    Status

    The value can be:

    • Normal: Real-time monitoring data is displayed.
      NOTE:

      The monitoring data and charts are available for a new instance after the instance runs for about 10 minutes.

    • Abnormal: There is no monitoring data. The default values for all metrics are 0. The monitoring data is available only after the instance becomes normal.
    • Stopped: There is no monitoring data. The default values for all metrics are 0. The monitoring data is available only after the instance is started.

    Node Type

    The value can be:

    • Primary
    • Replica

    Availability Zone

    AZ where a GaussDB(for MySQL) instance node is located

    Private IP Address

    Private IP address of a GaussDB(for MySQL) instance node

    Failover Priority

    Failover priority of a GaussDB(for MySQL) instance node

    Metrics

    For details about metric description and handling suggestions for abnormal metrics, see Table 2. The following metrics are available:

    • CPU Usage (%)
    • Memory Usage (%)
    • TPS
    • QPS
    Table 2 Monitoring items

    Item

    Description

    Handling Suggestion

    Reference

    CPU Usage (%)

    CPU usage of the monitored object
    • Evaluate the SQL execution plan and add indexes to avoid full table scanning.
    • Upgrade vCPU specifications for compute-intensive workloads.

    What Should I Do If the CPU Usage of My GaussDB(for MySQL) Instance Is High?

    Memory Usage (%)

    Memory usage of the monitored object
    • Upgrade instance specifications.
    • Optimize SQL statements to reduce the use of temporary tables.
    • Reconnect sessions at a specific interval to release memory of the sessions.

    How Do I Handle a Large Number of Temporary Tables Being Generated for Long Transactions and High Memory Usage?

    TPS

    Execution times of submitted and rollback transactions per second
    • Evaluate the SQL execution plan and add indexes to avoid full table scanning.
    • Upgrade vCPU specifications for compute-intensive workloads.

    What Should I Do If the CPU Usage of My GaussDB(for MySQL) Instance Is High?

    QPS

    Query times of SQL statements (including stored procedures) per second

Viewing Historical Metrics

Select the target node in the real-time metric list to view historical metrics in the Historical Metrics area.
Figure 2 Viewing historical metrics
  • You can view the monitoring metric data of up to six nodes at a time.
  • The following monitoring time windows are supported: last 1 hour, last 3 hours, last 12 hours, last 24 hours, last 7 days, and a custom time period.
  • You can move the cursor to a point in time of the chart to view the metric at that point in time.
    Figure 3 Viewing performance metrics at a specific point in time

Parent Topic: Instance Management