PolarDB-X 1.0 provides the monitoring feature to help you check the status of your instances. This topic describes how to view performance monitoring data of a PolarDB-X 1.0 instance on the Instance Monitoring page in the console.

Monitoring metrics of instances

Metric categoryMonitoring metricParameterDescription
Metric categoryMonitoring metricParameterDescription
ResourceCPUcpuThe average CPU utilization of the compute node in the PolarDB-X 1.0 instance.
MemoryoldThe memory usage of the compute node in the PolarDB-X 1.0 instance. Memory usage fluctuations are normal.
Networknetin: inbound trafficThe total inbound traffic of the compute node in the PolarDB-X 1.0 instance. Unit: Kbit/s. Inbound network traffic is generated when a storage node returns data to the compute node.
netout: outbound trafficThe total outbound traffic of the compute node in the PolarDB-X 1.0 instance. Unit: Kbit/s. Outbound network traffic is generated when the compute node sends physical SQL statements to the storage node or the compute node returns data to applications.
EngineLogical QPSlqpsThe total number of SQL statements that are processed by the instance per second.
Physical QPSpqpsThe total number of SQL operations that are sent from the compute node to the storage node per second.
Logical RTlrtThe average response time (RT) for processing each SQL statement by the PolarDB-X 1.0 instance.
Physical RTprtThe average RT for processing SQL statements that are sent from the compute node to the storage node.
Active ConnectionsconThe total number of connections between an application and the PolarDB-X 1.0 instance.
Active ThreadsthreadThe number of threads that are used to execute SQL statements in the PolarDB-X 1.0 instance.
Note
  • The data collection cycle is 1 minute for the metrics of the Resource category and 5 seconds for the metrics of the Engine category in the preceding table.
  • You can view the monitoring data that is generated within seven days.

Procedure

  1. Log on to the PolarDB for Xscale console.
  2. In the top navigation bar, select the region where the target instance is located.
  3. On the Instances page, find the instance and click the instance ID.
  4. In the left-side navigation pane, choose Monitoring and Alerting > Instance Monitoring.
  5. On the Instance Monitoring page, specify the following parameters.
    ParameterDescription
    ParameterDescription
    Monitoring IndexThe metric category. Select Resource or Engine.
    Monitoring IndexThe monitoring metrics of the instance. Select the monitoring metric that you want to view. For more information about monitoring metrics, see Monitoring metrics of instances.
    Query TimeThe query time. You can specify the query time as 1 hour, 6 hours, 12 hours, one day, or one week. You can also customize a query time range. The minimum time range is 1 minute and the maximum time range is one week.