Monitor the computing resources of a PolarDB-X instance

Updated at:
Copy as MD

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:

    ScopeHow to query
    Instance tabSpecify a time range and click OK
    Cluster tabSpecify a time range and click OK
    Node tabSelect 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

MetricDescription
CPUAverage CPU utilization over the selected time range.
MemoryJVM heap memory usage as a percentage of total heap capacity.

Query performance metrics

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

Network metrics

MetricDescriptionUnit
Inbound network trafficTotal inbound network traffic on the compute node.Kbit/s
Outbound network trafficTotal outbound network traffic on the compute node.Kbit/s

Session metrics

MetricDescription
Total number of sessionsTotal number of sessions per second.
Active sessionsNumber of active sessions per second.

Garbage collection metrics

MetricDescription
Young GC timeTime consumed by garbage collection in the young generation per second.
Full GC timeTime consumed by full garbage collection per second.