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. |