Monitor the computing resources of a PolarDB-X instance

Updated at:

Compute Monitoring lets you track the performance of your PolarDB-X instance across three scopes — instance, cluster, and individual node. Use it to identify CPU saturation, slow SQL activity, JVM garbage collection pressure, and network bottlenecks before they affect end users.

Note

Compute Monitoring is available for PolarDB-X Enterprise Edition instances only.

View compute monitoring data

  1. Log on to the PolarDB-X console.

  2. In the top navigation bar, select the region where the instance is deployed.

  3. On the Instances page, click the PolarDB-X 2.0 tab.

  4. Find the instance that you want to manage and click its ID.

  5. In the left-side navigation pane, choose Monitoring and Alerting > Compute Monitoring.

  6. On the Compute Monitoring page, select a monitoring scope:

    Scope How to query
    Instance tab Specify a time range and click OK
    Cluster tab Specify a time range and click OK
    Node tab Select a node from the drop-down list, specify a time range, and click OK
    Note

    Performance data is retained for 30 days. The data collection interval is configurable.

Metrics reference

Resource metrics

Metric Description
CPU Average CPU utilization over the selected time range.
Memory JVM heap memory usage as a percentage of total heap capacity.

Query performance metrics

Metric Description
Average or logical response time Average response time of logical requests (user-initiated queries).
Physical response time Average response time of physical requests sent to data nodes.
QPS or logical QPS Number of user requests processed per second by the compute node.
TPS or logical TPS Number of transactions processed per second.
Physical QPS Number of requests sent to data nodes processed per second.
Logical slow SQL queries Number of slow SQL queries initiated by users per second.
Physical slow SQL queries Number of slow SQL queries sent to data nodes per second.

Network metrics

Metric Description Unit
Inbound network traffic Total inbound network traffic on the compute node. Kbit/s
Outbound network traffic Total outbound network traffic on the compute node. Kbit/s

Session metrics

Metric Description
Total number of sessions Total number of sessions per second.
Active sessions Number of active sessions per second.

Garbage collection metrics

Metric Description
Young GC time Time consumed by garbage collection in the young generation per second.
Full GC time Time consumed by full garbage collection per second.