PolarDB:Performance metrics monitoring

Performance metric

Metric

Data type

Unit

Description

PolarDBDiskUsage

mean_data_size

double

MB

The storage space used by 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 undo log usage.

PolarDBQPSTPS

mean_qps

double

Count

The number of requests per second.

mean_tps

double

Count

The number of transactions per second.

mean_mps

double

Count

The number of operations per second.

PolarDBCPU

cpu_ratio

double

Percent

The CPU utilization (%).

PolarDBMemory

mem_ratio

double

Percent

The memory usage (%).

PolarDBMemoryForPCU

pcu_mem_usage

double

Percent

The memory usage based on PolarDB Capacity Units (PCUs).

PolarDBCPUForPCU

pcu_cpu_usage

double

Percent

The CPU utilization based on PCUs.

PolarDBPCU

pcu

double

Cores

The number of PCU cores.

PolarDBConnections

mean_active_session

double

Count

The number of active connections.

thread_pool_running_threads

double

Item

The number of running threads in the thread pool.

mean_total_session

double

item

The total number of current connections.

tp_thread_count

double

Count

The total number of threads in the thread pool.

PolarDBNetworkTraffic

mean_input_traffic

double

KB/s

The inbound traffic per second.

mean_output_traffic

double

KB/s

The outbound traffic per second.

PolarDBInnoDBBufferRatio

mean_innodb_buffer_dirty_ratio

double

Percent

The dirty block ratio of the buffer pool (%).

mean_innodb_buffer_read_hit

double

Percent

The read hit rate of the buffer pool (%).

mean_innodb_buffer_use_ratio

double

Percent

The utilization of the buffer pool (%).

PolarDBInnoDBDataReadWrite

mean_innodb_data_read

double

Byte

The amount of data read from the storage engine per second.

mean_innodb_data_written

double

Byte

The amount of data written to the storage engine per second.

PolarDBInnoDBBufferRequests

mean_innodb_buffer_pool_read_requests

double

Count

The number of read requests from the buffer pool per second.

mean_innodb_buffer_pool_write_requests

double

Count

The number of write requests to the buffer pool per second.

PolarDBInnoDBLogWrites

mean_innodb_log_write_requests

double

Count

The number of physical log writes per second.

mean_innodb_os_log_fsyncs

double

Times

The number of syncs per second.

PolarDBCreatedTempDiskTable

mean_created_tmp_disk_tables

double

Unit

The number of temporary tables created per second.

PolarDBCOMDML

mean_com_delete

double

Item

The number of DELETE statements executed per second.

mean_com_delete_multi

double

Item

The number of multi-table DELETE statements executed per second.

mean_com_insert

double

Unit

The number of INSERT statements executed per second.

mean_com_insert_select

double

Unit

The number of INSERT...SELECT statements executed per second.

mean_com_replace

double

Statements/second

The number of REPLACE statements executed per second.

mean_com_replace_select

double

Unit

The number of REPLACE...SELECT statements executed per second.

mean_com_select

double

Statements/second

The number of SELECT statements executed per second.

mean_com_update

double

Statements/second

The number of UPDATE statements executed per second.

mean_com_update_multi

double

Unit

The number of multi-table 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

IOPS

The read IOPS.

mean_iops_w

double

IOPS

The write IOPS.

mean_iops

double

IOPS

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

Seconds

The replication delay.

Performance metric

Metric

Data type

Unit

Description

PolarDBCPU

cpu_ratio

double

Percent

The total CPU utilization.

cpu_sys_ratio

double

Percent

The CPU utilization in kernel mode.

cpu_user_ratio

double

Percent

The CPU utilization in user mode.

PolarDBMemory

mem_ratio

double

Percent

The memory usage.

PolarDBMemoryForPCU

pcu_mem_usage

double

Percent

The memory usage based on PCUs.

PolarDBCPUForPCU

pcu_cpu_usage

double

Percent

The CPU utilization based on PCUs.

PolarDBPCU

pcu_by_cpu_cores

double

Cores

The number of PCU cores.

PolarDBIOSTAT

mean_io_throughput_w

double

MB

The write throughput.

mean_io_throughput_r

double

MB

The read throughput.

mean_io_throughput

double

MB

The total throughput.

mean_iops_w

double

Count

The write IOPS.

mean_iops_r

double

Count

The read IOPS.

mean_iops

double

Time

The total IOPS.

PolarDBDiskUsage

mean_tmp_size

double

MB

The temporary space usage.

mean_log_size

double

MB

The usage of local logs.

mean_wal_size

double

MB

The space usage of Write-Ahead Logging (WAL) logs.

mean_ins_total_size

double

MB

The space usage of the cluster.

mean_data_size

double

MB

The total usage of user data.

PolarDBReplication

mean_max_slot_wal_delay_in_mb

double

MB

The maximum replication slot delay.

mean_logical_rep_latency_in_mb

double

MB

The logical replication delay.

mean_send_latency_in_mb

double

MB

The send delay of the primary node.

mean_replay_latency_in_mb

double

MB

The replay delay of the secondary node.

PolarDBSQL

mean_five_seconds_two_pc_transactions

double

Unit

A two-phase transaction has been running for 5 s.

mean_three_seconds_two_pc_transactions

double

Unit

A two-phase transaction has been running for 3 s.

mean_one_second_two_pc_transactions

double

Item

The number of two-phase commit transactions that have been running for 1 second.

mean_five_seconds_long_transactions

double

Unit

The number of transactions that have been running for 5 seconds.

mean_three_seconds_transactions

double

Unit

The number of transactions that have been running for 3 seconds.

mean_one_second_transactions

double

Unit

The number of transactions that have been running for 1 second.

mean_five_seconds_idle_transactions

double

Unit

The number of transactions that have been idle for 5 seconds.

mean_three_seconds_idle_transactions

double

Item

The number of transactions that have been idle for 3 seconds.

mean_one_second_idle_transactions

double

Unit

The number of transactions that have been idle for 1 second.

mean_five_seconds_executing_sqls

double

item

The number of SQL statements that have been running for 5 seconds.

mean_three_seconds_executing_sqls

double

item

The number of SQL statements that have been running for 3 seconds.

mean_one_second_executing_sqls

double

Item

The number of SQL statements that have been running for 1 second.

PolarDBSlowSQLTime

max_executing_sql_last_time

double

ms

The running time of the slowest SQL statement.

PolarDBReplicationSlots

total_slots

double

Unit

The number of replication slots.

inactive_slots

double

Unit

The number of inactive replication slots.

PolarDBVacuum

mean_db_age

double

xids

The maximum age of the database.

PolarDBTransaction

mean_long_two_pc_transactions

double

Count

The number of long-running two-phase commit transactions.

mean_two_pc_transactions

double

Unit

The number of two-phase commit transactions.

mean_long_transactions

double

Unit

The number of long-running transactions.

mean_long_idle_transactions

double

Unit

The number of idle long-running transactions.

mean_idle_transactions

double

Count

The number of idle transactions.

mean_waiting_transactions

double

Unit

The number of waiting transactions.

mean_active_transactions

double

Unit

The number of active transactions.

PolarDBBuffer

mean_blks_hit_delta

double

Count

The number of block hits per second.

mean_blks_read_delta

double

Blocks/second

The number of blocks read per second.

mean_buffers_alloc

double

Count

The total number of allocated cache buffers.

mean_buffers_backend_fsync

double

Count

The total number of fsyncs performed by backends.

mean_buffers_backend

double

Count

The total number of cache buffers written by backends.

mean_buffers_clean

double

Count

The total number of cache buffers written by the checkpointer process.

mean_hit_ratio

double

Percent

The block hit rate.

PolarDBTemp

mean_temp_bytes

double

Bytes

The size of data in temporary files generated per second.

mean_temp_files

double

Item

The number of temporary files generated per second.

PolarDBQPSTPS

mean_deadlocks_delta

double

Number of times

The number of deadlocks per second.

mean_rollbacks_delta

double

Count

The number of rollbacks per second.

mean_commits_delta

double

Count

The number of commits per second.

mean_tps

double

Times

The number of transactions processed per second.

PolarDBRowDML

mean_tup_deleted_delta

double

Row

The number of rows deleted per second.

mean_tup_updated_delta

double

Row

The number of rows updated per second.

mean_tup_inserted_delta

double

Row

The number of rows inserted per second.

mean_tup_fetched_delta

double

Row

The number of rows read per second.

mean_tup_returned_delta

double

Row

The number of rows returned per second.

PolarDBConnections

mean_idle_connection

double

Unit

The number of idle connections.

mean_waiting_connection

double

Unit

The number of waiting connections.

mean_active_session

double

Unit

The number of active sessions.

mean_total_session

double

Unit

The total number of sessions.

Performance metric

Metric

Data type

Unit

Description

PolarProxy_CpuUsage

docker_container_cpu

double

Percent

The CPU utilization of the PolarDB proxy layer (PolarProxy).

PolarProxy_Cps

service_connections_ps

double

Connections/second

The number of new connections to PolarProxy per second.

PolarProxy_CurrentConns

service_current_connections

double

Unit

The number of current connections to PolarProxy.

PolarProxy_UpFlows

service_upstream_netflow

double

KB/s

The inbound traffic to PolarProxy per second.

PolarProxy_DownFlows

service_downstream_netflow

double

KB/s

The outbound traffic from PolarProxy per second.

PolarProxy_Qps

service_queries

double

Requests/second

The number of requests to PolarProxy per second.

PolarProxy_DBConns

server_connections

double

Unit

The number of connections from PolarProxy to each DB node.

PolarProxy_DBQps

server_queries

double

Requests/second

The request rate from PolarProxy to each DB node.

PolarProxy_DBActionOps

server_active_operations

double

Item

The number of active requests from PolarProxy to each DB node.

PolarProxy_LsnNotMatch

service_queries_lsn_not_match

double

Requests/second

The rate at which requests are routed to the primary node because the consistency level is not met for a cluster endpoint.

PolarProxy_QueriesInTrx

service_queries_in_trx

double

Requests/second

The rate at which requests are routed to the primary database due to transactions for a cluster endpoint.

PolarProxy_Rt

service_proxy_rt

double

Microseconds

The round-trip time (RT).

PolarProxy_Db_Rt

service_db_rt

double

Microseconds

The average time that the DB takes to process a request.

PolarProxy_Full_Rt

service_full_rt

double

Microseconds

The average total time that is taken to process a request.