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 single database in a PolarDB-X 1.0 instance on the Database Monitoring page in the console.

Monitoring metrics of databases

Monitoring metricParameterDescription
QPSqpsThe total number of SQL statements that are processed by the database in the PolarDB-X 1.0 instance per second.
Active ConnectionsconThe total number of connections between an application and the database in the PolarDB-X 1.0 instance.
Active ThreadsthreadThe number of threads that are used by the database in the PolarDB-X 1.0 instance to execute SQL statements.
Note
  • The data collection cycle is 1 minute for each metric 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 > Database Monitoring.
  5. On the Database Monitoring page, specify the following parameters.
    ParameterDescription
    DatabaseThe database whose monitoring metrics you want to view. Select the database from the Database drop-down list.
    Data IndexesThe monitoring metrics of the database. Select the monitoring metric that you want to view. For more information about monitoring metrics, see Monitoring metrics of databases.
    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.