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

Performance metrics of PolarDB for MySQL 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 PolarDB for PostgreSQL and PolarDB for Oracle 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.