All Products
Search
Document Center

PolarDB:Performance metric monitoring

Last Updated:Oct 11, 2023

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

Performance metrics of PolarDB for MySQL clusters

Performance metricMetricData typeUnitDescription
PolarDBDiskUsagemean_data_sizedoubleMBThe storage space occupied by the data.
mean_log_sizedoubleMBThe storage space occupied by logs.
mean_sys_dir_sizedoubleMBThe storage space occupied by the system.
mean_tmp_dir_sizedoubleMBThe storage space occupied by temporary files.
mean_redolog_sizedoubleMBThe storage space occupied by redo logs.
mean_binlog_sizedoubleMBThe storage space occupied by binary logs.
mean_other_log_sizedoubleMBThe size of other logs.
mean_undolog_sizedoubleMBThe storage space used by undo logs.
PolarDBQPSTPSmean_qpsdoubleN/AThe number of requests per second.
mean_tpsdoubleN/AThe number of transactions per second.
mean_mpsdoubleN/AThe number of operations per second.
PolarDBCPUcpu_ratiodoublePercentageThe CPU utilization (%).
PolarDBMemorymem_ratiodoublePercentageThe memory usage (%).
PolarDBConnectionsmean_active_sessiondoubleN/AThe number of active connections.
thread_pool_running_threadsdoubleN/AThe number of threads that are being executed in the thread pool.
mean_total_sessiondoubleN/AThe total number of current connections.
tp_thread_countdoubleN/AThe total number of threads in the thread pool.
PolarDBNetworkTrafficmean_input_trafficdoubleKB/sThe amount of inbound network traffic per second.
mean_output_trafficdoubleKB/sThe amount of outbound network traffic per second.
PolarDBInnoDBBufferRatiomean_innodb_buffer_dirty_ratiodoublePercentageThe dirty ratio (%) in the buffer pool.
mean_innodb_buffer_read_hitdoublePercentageThe read hit ratio (%) of the buffer pool.
mean_innodb_buffer_use_ratiodoublePercentageThe utilization (%) of the buffer pool.
PolarDBInnoDBDataReadWritemean_innodb_data_readdoubleByteThe amount of data that is read from the storage engine per second.
mean_innodb_data_writtendoubleByteThe amount of data that is written to the storage engine per second.
PolarDBInnoDBBufferRequestsmean_innodb_buffer_pool_read_requestsdoubleN/AThe number of reads from the buffer pool per second.
mean_innodb_buffer_pool_write_requestsdoubleN/AThe number of writes to the buffer pool per second.
PolarDBInnoDBLogWritesmean_innodb_log_write_requestsdoubleN/AThe number of physical writes to the log per second.
mean_innodb_os_log_fsyncsdoubleN/AThe number of synchronizations per second.
PolarDBCreatedTempDiskTablemean_created_tmp_disk_tablesdoubleN/AThe number of temporary tables created per second.
PolarDBCOMDMLmean_com_deletedoubleN/AThe number of DELETE statements executed per second.
mean_com_delete_multidoubleN/AThe number of Multi-DELETE statements executed per second.
mean_com_insertdoubleN/AThe number of INSERT statements executed per second.
mean_com_insert_selectdoubleN/AThe number of INSERT_SELECT statements executed per second.
mean_com_replacedoubleN/AThe number of REPLACE statements executed per second.
mean_com_replace_selectdoubleN/AThe number of REPLACE_SELECT statements executed per second.
mean_com_selectdoubleN/AThe number of SELECT statements executed per second.
mean_com_updatedoubleN/AThe number of UPDATE statements executed per second.
mean_com_update_multidoubleN/AThe number of Multi-UPDATE statements executed per second.
PolarDBRowDMLmean_innodb_rows_deleteddoubleN/AThe number of rows deleted per second.
mean_innodb_rows_inserteddoubleN/AThe number of rows inserted per second.
mean_innodb_rows_readdoubleN/AThe number of rows read per second.
mean_innodb_rows_updateddoubleN/AThe number of rows updated per second.
PolarDBIOSTATmean_iops_rdoubleN/AThe read IOPS.
mean_iops_wdoubleN/AThe write IOPS.
mean_iopsdoubleN/AThe total IOPS.
mean_io_throughput_rdoubleMBThe read I/O throughput.
mean_io_throughput_wdoubleMBThe write I/O throughput.
mean_io_throughputdoubleMBThe total I/O throughput.
PolarDBReplicaLagmean_replication_delaydoubleSecondThe replication latency.

Performance metrics of PolarProxy

Performance metricMetricData typeUnitDescription
PolarProxy_CpuUsagedocker_container_cpudoublePercentageThe CPU utilization on PolarProxy.
PolarProxy_Cpsservice_connections_psdoubleN/AThe number of new connections per second on PolarProxy.
PolarProxy_CurrentConnsservice_current_connectionsdoubleN/AThe number of current connections on PolarProxy.
PolarProxy_UpFlowsservice_upstream_netflowdoubleKB/sThe amount of inbound network traffic per second on PolarProxy.
PolarProxy_DownFlowsservice_downstream_netflowdoubleKB/sThe amount of outbound network traffic per second on PolarProxy.
PolarProxy_Qpsservice_queriesdoubleN/AThe number of requests per second on PolarProxy.