This topic describes the performance metrics of PolarDB clusters.

Performance metrics of PolarDB for MySQL clusters

Performance metric Item Data type Unit Description
PolarDBDiskUsage mean_data_size DOUBLE MB The storage space used by the data.
mean_log_size DOUBLE MB The storage space used by logs.
mean_sys_dir_size DOUBLE MB The storage space used by the system.
mean_tmp_dir_size DOUBLE MB The storage space used by temporary files.
mean_redolog_size DOUBLE MB The storage space used by redo logs.
mean_binlog_size DOUBLE MB The storage space used by binary logs.
mean_other_log_size DOUBLE MB The size of other logs
mean_undolog_size DOUBLE MB The size of undo logs.
PolarDBQPSTPS mean_qps DOUBLE N/A The number of requests per second.
mean_tps DOUBLE N/A The number of transactions per second.
mean_mps DOUBLE N/A The number of operations per second.
PolarDBCPU cpu_ratio DOUBLE Percentage The CPU usage.
PolarDBMemory mem_ratio DOUBLE Percentage The memory usage.
PolarDBConnections mean_active_session DOUBLE N/A The number of active connections.
mean_total_session DOUBLE N/A The total number of 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 percentage of dirty data blocks 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 N/A The number of reads from the buffer pool per second.
mean_innodb_buffer_pool_write_requests DOUBLE N/A The number of writes to the buffer pool per second.
PolarDBInnoDBLogWrites mean_innodb_log_write_requests DOUBLE N/A The number of physical writes to the log file per second.
mean_innodb_os_log_fsyncs DOUBLE N/A The number of synchronizations per second.
PolarDBCreatedTempDiskTable mean_created_tmp_disk_tables DOUBLE N/A The number of temporary tables created per second.
PolarDBCOMDML mean_com_delete DOUBLE N/A The number of DELETE statements executed per second.
mean_com_delete_multi DOUBLE N/A The number of Multi-DELETE statements executed per second.
mean_com_insert DOUBLE N/A The number of INSERT statements executed per second.
mean_com_insert_select DOUBLE N/A The number of INSERT_SELECT statements executed per second.
mean_com_replace DOUBLE N/A The number of REPLACE statements executed per second.
mean_com_replace_select DOUBLE N/A The number of REPLACE_SELECT statements executed per second.
mean_com_select DOUBLE N/A The number of SELECT statements executed per second.
mean_com_update DOUBLE N/A The number of UPDATE statements executed per second.
mean_com_update_multi DOUBLE N/A 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 N/A The read input/output operations per second (IOPS).
mean_iops_w DOUBLE N/A The write IOPS.
mean_iops DOUBLE N/A 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-O clusters

Performance metric Item Data type Unit Description
PolarDBConnections mean_total_session DOUBLE N/A The total number of connections.
mean_active_session DOUBLE N/A The number of active connections.
mean_waiting_connection DOUBLE N/A The number of pending connections.
mean_idle_connection DOUBLE N/A 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 N/A The number of active transactions.
mean_waiting_transactions DOUBLE N/A The number of pending transactions.
mean_idle_transactions DOUBLE N/A The number of idle transactions.
mean_long_idle_transactions DOUBLE N/A The number of idle long-running transactions.
mean_long_transactions DOUBLE N/A The number of long-running transactions.
mean_two_pc_transactions DOUBLE N/A The number of XA transactions.
mean_long_two_pc_transactions DOUBLE N/A The number of long-running XA transactions.
PolarDBQPSTPS mean_tps DOUBLE N/A The number of transactions per second.
mean_commits_delta DOUBLE N/A The number of transactions committed per second.
mean_rollbacks_delta DOUBLE N/A The number of transactions rolled back per second.
mean_deadlocks_delta DOUBLE N/A The number of deadlocks per second.
PolarDBBuffer mean_blks_read_delta DOUBLE N/A The number of block reads per second.
mean_blks_hit_delta DOUBLE N/A The number of block hits per second.
mean_hit_ratio DOUBLE Percentage The block hit rate.
mean_buffers_clean DOUBLE N/A The number of buffers written by the background writer during checkpoints.
mean_buffers_backend DOUBLE N/A The number of buffers written by a backend.
mean_buffers_backend_fsync DOUBLE N/A The number of times that a backend was forced to execute its own fsync calls to synchronize buffers with storage.
mean_buffers_alloc DOUBLE N/A The number of allocated buffers.
PolarDBVacuum mean_db_age DOUBLE XID The difference between the current transaction ID and the earliest transaction ID that cannot be reused.
PolarDBTemp mean_temp_files DOUBLE N/A The number of temporary files generated per second.
mean_temp_bytes DOUBLE Byte The amount of temporary file data generated per second.
PolarDBCPU cpu_ratio DOUBLE Percentage The CPU usage.
cpu_user_ratio DOUBLE Percentage The CPU usage in the user mode.
cpu_sys_ratio DOUBLE Percentage The CPU usage in the kernel mode.
PolarDBMemory mem_ratio DOUBLE Percentage The memory usage.
PolarDBDiskUsage mean_ins_total_size DOUBLE MB The storage space of PolarStore occupied by the cluster.
mean_data_size DOUBLE MB The storage space of PolarStore occupied by user data.
mean_wal_size DOUBLE MB The storage space of PolarStore occupied by Write-Ahead Logging (WAL) logs.
mean_tmp_size DOUBLE MB The storage space occupied by temporary data.
mean_log_size DOUBLE MB The storage space occupied by local logs.
PolarDBIOSTAT mean_iops_r DOUBLE N/A The read IOPS.
mean_iops_w DOUBLE N/A The write IOPS.
mean_iops DOUBLE N/A 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.