This topic describes the metrics for PolarDB-X V1.0.
When you call an API operation provided by CloudMonitor, set the Namespace and Period parameters.
- Set the Namespace parameter to acs_drds.
- Set the Period parameter to an integral multiple of 60. Default value: 60. Unit: seconds.
The following table describes the valid values of the MetricName and Dimensions parameters.
Metric | Unit | MetricName | Dimensions | Statistics |
---|---|---|---|---|
DRDS_CPUUtilization | % | CPUUtilization | userId and instanceId | Average |
DRDS_ConnectionCount | Count | ConnectionCount | userId and instanceId | Average |
Logical QPS | Count | LogicQPS | userId and instanceId | Average |
Logical RT | ms | LogicRT | userId and instanceId | Average |
Memory usage | % | MemoryUtilization | userId and instanceId | Average |
DRDS_NetworkInputTraffic | bit/s | NetworkInputTraffic | userId and instanceId | Average |
DRDS_NetworkOutputTraffic | bit/s | NetworkOutputTraffic | userId and instanceId | Average |
Physical QPS | Count | PhysicsQPS | userId and instanceId | Average |
Physical RT | ms | PhysicsRT | userId and instanceId | Average |
Number of active threads | Count | ThreadCount | userId and instanceId | Average |
Number of active sessions on a private ApsaraDB RDS for MySQL instance | Count | active_session | userId, instanceId, and rdsInstId | Average |
Number of DELETE statements that are executed per second on a private ApsaraDB RDS for MySQL instance | Count | com_delete | userId, instanceId, and rdsInstId | Average |
Number of INSERT statements that are executed per second on a private ApsaraDB RDS for MySQL instance | Count | com_insert | userId, instanceId, and rdsInstId | Average |
Number of INSERT and SELECT statements that are executed per second on a private ApsaraDB RDS for MySQL instance | Count | com_insert_select | userId, instanceId, and rdsInstId | Average |
Number of REPLACE statements that are executed per second on a private ApsaraDB RDS for MySQL instance | Count | com_replace | userId, instanceId, and rdsInstId | Average |
Number of REPLACE and SELECT statements that are executed per second on a private ApsaraDB RDS for MySQL instance | Count | com_replace_select | userId, instanceId, and rdsInstId | Average |
Number of SELECT statements that are executed per second on a private ApsaraDB RDS for MySQL instance | Count | com_select | userId, instanceId, and rdsInstId | Average |
Number of UPDATE statements that are executed per second on a private ApsaraDB RDS for MySQL instance | Count | com_update | userId, instanceId, and rdsInstId | Average |
Connection utilization of a private ApsaraDB RDS for MySQL instance | % | conn_usage | userId, instanceId, and rdsInstId | Average |
CPU utilization of a private ApsaraDB RDS for MySQL instance | % | cpu_usage | userId, instanceId, and rdsInstId | Average |
Disk usage of a private ApsaraDB RDS for MySQL instance | % | disk_usage | userId, instanceId, and rdsInstId | Average |
Dirty page ratio of the buffer pool of a private ApsaraDB RDS for MySQL instance | % | ibuf_dirty_ratio | userId, instanceId, and rdsInstId | Average |
Number of physical reads per second on a private ApsaraDB RDS for MySQL instance | Count | ibuf_pool_reads | userId, instanceId, and rdsInstId | Average |
Read hit ratio of the buffer pool of a private ApsaraDB RDS for MySQL instance | % | ibuf_read_hit | userId, instanceId, and rdsInstId | Average |
Number of logical reads per second on a private ApsaraDB RDS for MySQL instance | Count | ibuf_request_r | userId, instanceId, and rdsInstId | Average |
Number of logical writes per second on a private ApsaraDB RDS for MySQL instance | Count | ibuf_request_w | userId, instanceId, and rdsInstId | Average |
Utilization of the buffer pool of a private ApsaraDB RDS for MySQL instance | % | ibuf_use_ratio | userId, instanceId, and rdsInstId | Average |
Amount of data read per second on a private ApsaraDB RDS for MySQL instance that uses InnoDB | KB | inno_data_read | userId, instanceId, and rdsInstId | Average |
Amount of data written per second to a private ApsaraDB RDS for MySQL instance that uses InnoDB | KB | inno_data_written | userId, instanceId, and rdsInstId | Average |
Number of rows deleted per second from a private ApsaraDB RDS for MySQL instance that uses InnoDB | Count | inno_row_delete | userId, instanceId, and rdsInstId | Average |
Number of rows inserted per second to a private ApsaraDB RDS for MySQL instance that uses InnoDB | Count | inno_row_insert | userId, instanceId, and rdsInstId | Average |
Number of rows read per second on a private ApsaraDB RDS for MySQL instance that uses InnoDB | Count | inno_row_readed | userId, instanceId, and rdsInstId | Average |
Number of rows updated per second on a private ApsaraDB RDS for MySQL instance that uses InnoDB | Count | inno_row_update | userId, instanceId, and rdsInstId | Average |
Number of write requests per second to the logs of a private ApsaraDB RDS for MySQL instance that uses InnoDB | Count | innodb_log_write_requests | userId, instanceId, and rdsInstId | Average |
Number of logical writes per second to the logs of a private ApsaraDB RDS for MySQL instance that uses InnoDB | Count | innodb_log_writes | userId, instanceId, and rdsInstId | Average |
Number of times fsync is called per second to write data to the logs of a private ApsaraDB RDS for MySQL instance that uses InnoDB | Count | innodb_os_log_fsyncs | userId, instanceId, and rdsInstId | Average |
Inbound bandwidth of a private ApsaraDB RDS for MySQL instance | bit/s | input_traffic_ps | userId, instanceId, and rdsInstId | Average |
IOPS usage of a private ApsaraDB RDS for MySQL instance | % | iops_usage | userId, instanceId, and rdsInstId | Average |
Outbound bandwidth of a private ApsaraDB RDS for MySQL instance | bit/s | output_traffic_ps | userId, instanceId, and rdsInstId | Average |
Queries per second (QPS) of a private ApsaraDB RDS for MySQL instance | Count | qps | userId, instanceId, and rdsInstId | Average |
Latency of a private read-only ApsaraDB RDS for MySQL instance | Second | slave_lag | userId, instanceId, and rdsInstId | Average |
Slow queries per second of a private ApsaraDB RDS for MySQL instance | Count | slow_queries | userId, instanceId, and rdsInstId | Average |
Number of temporary tables created per second on a private ApsaraDB RDS for MySQL instance | Count | tb_tmp_disk | userId, instanceId, and rdsInstId | Average |
Transactions per second (TPS) of a private ApsaraDB RDS for MySQL instance | Count | tps | userId, instanceId, and rdsInstId | Average |