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