Performance metric monitoring

This topic describes the performance metric of PolarDB clusters that are monitored.

Performance metrics of ApsaraDB PolarDB MySQL-compatible edition clusters

Performance metric	Metric	Data type	Unit	Description
PolarDBDiskUsage	mean_data_size	double	MB	The storage space occupied by the data.
	mean_log_size	double	MB	The storage space occupied by logs.
	mean_sys_dir_size	double	MB	The storage space occupied by the system.
	mean_tmp_dir_size	double	MB	The storage space occupied by temporary files.
	mean_redolog_size	double	MB	The storage space occupied by redo logs.
	mean_binlog_size	double	MB	The storage space occupied by binary logs.
	mean_other_log_size	double	MB	The size of other logs.
	mean_undolog_size	double	MB	The storage space used by undo logs.
PolarDBQPSTPS	mean_qps	double	Times	The number of requests per second.
	mean_tps	double	Times	The number of transactions per second.
	mean_mps	double	Times	The number of operations per second.
PolarDBCPU	cpu_ratio	double	Percentage	The CPU utilization (%).
PolarDBMemory	mem_ratio	double	Percentage	The memory usage (%).
PolarDBConnections	mean_active_session	double	Count	The number of active connections.
	mean_total_session	double	Count	The total number of current connections.
PolarDBNetworkTraffic	mean_input_traffic	double	KB/s	The amount of inbound network traffic per second.
	mean_output_traffic	double	KB/s	The amount of outbound network traffic per second.
PolarDBInnoDBBufferRatio	mean_innodb_buffer_dirty_ratio	double	Percentage	The dirty ratio (%) in the buffer pool.
	mean_innodb_buffer_read_hit	double	Percentage	The read hit ratio (%) of the buffer pool.
	mean_innodb_buffer_use_ratio	double	Percentage	The utilization (%) of the buffer pool.
PolarDBInnoDBDataReadWrite	mean_innodb_data_read	double	Byte	The amount of data that is read from the storage engine per second.
	mean_innodb_data_written	double	Byte	The amount of data that is written to the storage engine per second.
PolarDBInnoDBBufferRequests	mean_innodb_buffer_pool_read_requests	double	Times	The number of reads from the buffer pool per second.
	mean_innodb_buffer_pool_write_requests	double	Times	The number of writes to the buffer pool per second.
PolarDBInnoDBLogWrites	mean_innodb_log_write_requests	double	Times	The number of physical writes to the log per second.
	mean_innodb_os_log_fsyncs	double	Times	The number of synchronizations per second.
PolarDBCreatedTempDiskTable	mean_created_tmp_disk_tables	double	Count	The number of temporary tables created per second.
PolarDBCOMDML	mean_com_delete	double	Count	The number of DELETE statements executed per second.
	mean_com_delete_multi	double	Count	The number of Multi-DELETE statements executed per second.
	mean_com_insert	double	Count	The number of INSERT statements executed per second.
	mean_com_insert_select	double	Count	The number of INSERT_SELECT statements executed per second.
	mean_com_replace	double	Count	The number of REPLACE statements executed per second.
	mean_com_replace_select	double	Count	The number of REPLACE_SELECT statements executed per second.
	mean_com_select	double	Count	The number of SELECT statements executed per second.
	mean_com_update	double	Count	The number of UPDATE statements executed per second.
	mean_com_update_multi	double	Count	The number of Multi-UPDATE statements executed per second.
PolarDBRowDML	mean_innodb_rows_deleted	double	Row	The number of rows deleted per second.
	mean_innodb_rows_inserted	double	Row	The number of rows inserted per second.
	mean_innodb_rows_read	double	Row	The number of rows read per second.
	mean_innodb_rows_updated	double	Row	The number of rows updated per second.
PolarDBIOSTAT	mean_iops_r	double	Times/second	The read input/output operations per second (IOPS).
	mean_iops_w	double	Times/second	The write IOPS.
	mean_iops	double	Times/second	The total IOPS.
	mean_io_throughput_r	double	MB	The read I/O throughput.
	mean_io_throughput_w	double	MB	The write I/O throughput.
	mean_io_throughput	double	MB	The total I/O throughput.
PolarDBReplicaLag	mean_replication_delay	double	Second	The replication delay.

Performance metrics of ApsaraDB PolarDB PostgreSQL-compatible edition and ApsaraDB PolarDB O Edition clusters

Performance metric	Metric	Data type	Unit	Description
PolarDBConnections	mean_total_session	double	Count	The number of current connections.
	mean_active_session	double	Count	The number of current active connections.
	mean_waiting_connection	double	Count	The number of pending connections.
	mean_idle_connection	double	Count	The number of idle connections.
PolarDBRowDML	mean_tup_returned_delta	double	Row	The number of rows returned per second in the full table scan result.
	mean_tup_fetched_delta	double	Row	The number of rows returned per second in the index scan and secondary index result.
	mean_tup_inserted_delta	double	Row	The number of rows inserted per second.
	mean_tup_updated_delta	double	Row	The number of rows updated per second.
	mean_tup_deleted_delta	double	Row	The number of rows deleted per second
PolarDBTransaction	mean_active_transactions	double	Count	The number of active transactions.
	mean_waiting_transactions	double	Count	The number of pending transactions.
	mean_idle_transactions	double	Count	The number of idle transactions.
	mean_long_idle_transactions	double	Count	The number of idle long-running transactions.
	mean_long_transactions	double	Count	The number of long-running transactions.
	mean_two_pc_transactions	double	Count	The number of XA transactions.
	mean_long_two_pc_transactions	double	Count	The number of long-running XA transactions.
PolarDBQPSTPS	mean_tps	double	Times	The number of transactions per second.
	mean_commits_delta	double	Times	The number of transactions committed per second.
	mean_rollbacks_delta	double	Times	The number of transactions rolled back per second.
	mean_deadlocks_delta	double	Times	The number of deadlocks per second.
PolarDBBuffer	mean_blks_read_delta	double	Count	The number of block reads per second.
	mean_blks_hit_delta	double	Count	The number of block hits per second.
	mean_hit_ratio	double	Percentage	The block hit ratio.
	mean_buffers_clean	double	Count	The cumulative number of buffers written by the background writer during checkpoints.
	mean_buffers_backend	double	Count	The cumulative number of buffers written by a backend.
	mean_buffers_backend_fsync	double	Count	The cumulative number of backend fsync calls.
	mean_buffers_alloc	double	Count	The cumulative number of allocated buffers.
PolarDBVacuum	mean_db_age	double	xids	The difference between the current transaction ID and the earliest transaction ID that cannot be recycled.
PolarDBTemp	mean_temp_files	double	Count	The number of temporary files generated per second.
	mean_temp_bytes	double	Bytes	The amount of temporary file data generated per second.
PolarDBCPU	cpu_ratio	double	Percentage	The CPU utilization.
	cpu_user_ratio	double	Percentage	The CPU utilization in the user state.
	cpu_sys_ratio	double	Percentage	The CPU utilization in the system state.
PolarDBMemory	mem_ratio	double	Percentage	The memory usage.
PolarDBDiskUsage	mean_ins_total_size	double	MB	The used PolarStore space of the instance.
	mean_data_size	double	MB	The used PolarStore space of user data.
	mean_wal_size	double	MB	The used PolarStore space of Write-Ahead Logging (WAL) logs.
	mean_tmp_size	double	MB	The used temporary space.
	mean_log_size	double	MB	The used space of local logs.
PolarDBIOSTAT	mean_iops_r	double	Times/second	The read IOPS.
	mean_iops_w	double	Times/second	The write IOPS.
	mean_iops	double	Times/second	The total IOPS.
	mean_io_throughput_r	double	MB	The read I/O throughput.
	mean_io_throughput_w	double	MB	The write I/O throughput.
	mean_io_throughput	double	MB	The total I/O throughput.