PolarDB:Performance metric monitoring

Performance metrics

Monitoring items

Data type

Unit

Description

PolarDBDiskUsage

mean_data_size

double

MB

Storage used by data.

mean_log_size

double

MB

Storage used by logs.

mean_sys_dir_size

double

MB

Storage used by the system.

mean_tmp_dir_size

double

MB

Storage used by temporary files.

mean_redolog_size

double

MB

Storage used by redo logs.

mean_binlog_size

double

MB

Storage used by binlogs.

mean_other_log_size

double

MB

Other log size.

mean_undolog_size

double

MB

Undo log usage.

PolarDBQPSTPS

mean_qps

double

Times

Requests per second.

mean_tps

double

Times

Transactions per second.

mean_mps

double

Times

Operations per second.

PolarDBCPU

cpu_ratio

double

Percentage

CPU utilization (%).

PolarDBMemory

mem_ratio

double

Percentage

Memory utilization (%).

PolarDBMemoryForPCU

pcu_mem_usage

double

Percentage

PCU-based memory utilization.

PolarDBCPUForPCU

pcu_cpu_usage

double

Percentage

PCU-based CPU utilization.

PolarDBPCU

pcu

double

Cores

PCU count.

PolarDBConnections

mean_active_session

double

Count

Active connections.

thread_pool_running_threads

double

Count

Number of running threads in the thread pool.

mean_total_session

double

Count

Current total connections.

tp_thread_count

double

Count

Total threads in the thread pool.

PolarDBNetworkTraffic

mean_input_traffic

double

KB/s

Inbound traffic per second.

mean_output_traffic

double

KB/s

Outbound traffic per second.

PolarDBInnoDBBufferRatio

mean_innodb_buffer_dirty_ratio

double

Percentage

Buffer pool dirty block ratio (%).

mean_innodb_buffer_read_hit

double

Percentage

Buffer pool read hit ratio (%).

mean_innodb_buffer_use_ratio

double

Percentage

Buffer pool utilization (%).

PolarDBInnoDBDataReadWrite

mean_innodb_data_read

double

Byte

Data read from storage engine per second.

mean_innodb_data_written

double

Byte

Data written to storage engine per second.

PolarDBInnoDBBufferRequests

mean_innodb_buffer_pool_read_requests

double

Times

Buffer pool reads per second.

mean_innodb_buffer_pool_write_requests

double

Times

Buffer pool writes per second.

PolarDBInnoDBLogWrites

mean_innodb_log_write_requests

double

Times

Physical log writes per second.

mean_innodb_os_log_fsyncs

double

Times

Synchronizations per second.

PolarDBCreatedTempDiskTable

mean_created_tmp_disk_tables

double

Count

Temporary tables created per second.

PolarDBCOMDML

mean_com_delete

double

Count

DELETE statements per second.

mean_com_delete_multi

double

Count

Multi-DELETE statements per second.

mean_com_insert

double

Count

INSERT statements per second.

mean_com_insert_select

double

Count

INSERT_SELECT statements per second.

mean_com_replace

double

Count

REPLACE statements per second.

mean_com_replace_select

double

Count

REPLACE_SELECT statements per second.

mean_com_select

double

Count

SELECT statements per second.

mean_com_update

double

Count

UPDATE statements per second.

mean_com_update_multi

double

Count

Multi-UPDATE statements per second.

PolarDBRowDML

mean_innodb_rows_deleted

double

Rows

Rows deleted per second.

mean_innodb_rows_inserted

double

Rows

Rows inserted per second.

mean_innodb_rows_read

double

Rows

Rows read per second.

mean_innodb_rows_updated

double

Rows

Rows updated per second.

PolarDBIOSTAT

mean_iops_r

double

Times/s

Read IOPS.

mean_iops_w

double

Times/s

Write IOPS.

mean_iops

double

Times/s

Total IOPS.

mean_io_throughput_r

double

MB

Read I/O throughput.

mean_io_throughput_w

double

MB

Write I/O throughput.

mean_io_throughput

double

MB

Total I/O throughput.

PolarDBReplicaLag

mean_replication_delay

double

Second

Replication lag.

Performance metrics

Monitoring items

Data type

Unit

Description

PolarDBCPU

cpu_ratio

double

Percentage

Total CPU utilization.

cpu_sys_ratio

double

Percentage

System CPU utilization.

cpu_user_ratio

double

Percentage

User CPU utilization.

PolarDBMemory

mem_ratio

double

Percentage

Memory utilization.

PolarDBMemoryForPCU

pcu_mem_usage

double

Percentage

PCU-based memory utilization.

PolarDBCPUForPCU

pcu_cpu_usage

double

Percentage

PCU-based CPU utilization.

PolarDBPCU

pcu_by_cpu_cores

double

Cores

PCU count.

PolarDBIOSTAT

mean_io_throughput_w

double

MB

Write throughput.

mean_io_throughput_r

double

MB

Read throughput.

mean_io_throughput

double

MB

Total throughput.

mean_iops_w

double

Times

Write IOPS.

mean_iops_r

double

Times

Read IOPS.

mean_iops

double

Times

Total IOPS.

PolarDBDiskUsage

mean_tmp_size

double

MB

Temporary space usage.

mean_log_size

double

MB

Local log usage.

mean_wal_size

double

MB

WAL log space usage.

mean_ins_total_size

double

MB

Cluster space usage.

mean_data_size

double

MB

Total user data usage.

PolarDBReplication

mean_max_slot_wal_delay_in_mb

double

MB

Maximum slot lag.

mean_logical_rep_latency_in_mb

double

MB

Logical replication lag.

mean_send_latency_in_mb

double

MB

Primary node send lag.

mean_replay_latency_in_mb

double

MB

Standby node replay lag.

PolarDBSQL

mean_five_seconds_two_pc_transactions

double

Count

Two-phase transactions executed for 5s.

mean_three_seconds_two_pc_transactions

double

Count

Two-phase transactions executed for 3s.

mean_one_second_two_pc_transactions

double

Count

Two-phase transactions executed for 1s.

mean_five_seconds_long_transactions

double

Count

Transactions executed for 5s.

mean_three_seconds_transactions

double

Count

Transactions executed for 3s.

mean_one_second_transactions

double

Count

Transactions executed for 1s.

mean_five_seconds_idle_transactions

double

Count

Transactions idle for 5s.

mean_three_seconds_idle_transactions

double

Count

Transactions idle for 3s.

mean_one_second_idle_transactions

double

Count

Transactions idle for 1s.

mean_five_seconds_executing_sqls

double

Count

SQL statements executed for 5s.

mean_three_seconds_executing_sqls

double

Count

SQL statements executed for 3s.

mean_one_second_executing_sqls

double

Count

SQL statements executed for 1s.

PolarDBSlowSQLTime

max_executing_sql_last_time

double

ms

Execution time of the slowest SQL statement.

PolarDBReplicationSlots

total_slots

double

Count

Number of replication slots.

inactive_slots

double

Count

Inactive replication slots.

PolarDBVacuum

mean_db_age

double

xids

Maximum database age.

PolarDBTransaction

mean_long_two_pc_transactions

double

Count

Two-phase long transactions.

mean_two_pc_transactions

double

Count

Two-phase transactions.

mean_long_transactions

double

Count

Long transactions.

mean_long_idle_transactions

double

Count

Idle long transactions.

mean_idle_transactions

double

Count

Idle transactions.

mean_waiting_transactions

double

Count

Waiting transactions.

mean_active_transactions

double

Count

Active transactions.

PolarDBBuffer

mean_blks_hit_delta

double

Times

Block hits per second.

mean_blks_read_delta

double

Count

Blocks read per second.

mean_buffers_alloc

double

Times

Cumulative cache allocations.

mean_buffers_backend_fsync

double

Times

Cumulative backend fsyncs.

mean_buffers_backend

double

Times

Cumulative backend buffer writes.

mean_buffers_clean

double

Times

Cumulative checkpoint backend buffer writes.

mean_hit_ratio

double

Percentage

Block hit ratio.

PolarDBTemp

mean_temp_bytes

double

Bytes

Temporary file data generated per second.

mean_temp_files

double

Count

Temporary files generated per second.

PolarDBQPSTPS

mean_deadlocks_delta

double

Times

Deadlocks per second.

mean_rollbacks_delta

double

Times

Rollbacks per second.

mean_commits_delta

double

Times

Commits per second.

mean_tps

double

Times

Transactions per second.

PolarDBRowDML

mean_tup_deleted_delta

double

Rows

Rows deleted per second.

mean_tup_updated_delta

double

Rows

Rows updated per second.

mean_tup_inserted_delta

double

Rows

Rows inserted per second.

mean_tup_fetched_delta

double

Rows

Rows read per second.

mean_tup_returned_delta

double

Rows

Rows returned per second.

PolarDBConnections

mean_idle_connection

double

Count

Idle connections.

mean_waiting_connection

double

Count

Waiting connections.

mean_active_session

double

Count

Active sessions.

mean_total_session

double

Count

Total sessions.

Performance metrics

Monitoring items

Data type

Unit

Description

PolarProxy_CpuUsage

docker_container_cpu

double

Percentage

CPU utilization of the PolarDB proxy layer (PolarProxy).

PolarProxy_Cps

service_connections_ps

double

Count/s

New connections per second of the PolarDB proxy layer (PolarProxy).

PolarProxy_CurrentConns

service_current_connections

double

Count

Current connections of the PolarDB proxy layer (PolarProxy).

PolarProxy_UpFlows

service_upstream_netflow

double

KB/s

Inbound traffic per second of the PolarDB proxy layer (PolarProxy).

PolarProxy_DownFlows

service_downstream_netflow

double

KB/s

Outbound traffic per second of the PolarDB proxy layer (PolarProxy).

PolarProxy_Qps

service_queries

double

Times/s

Requests per second of the PolarDB proxy layer (PolarProxy).

PolarProxy_DBConns

server_connections

double

Count

Connections from the PolarDB proxy layer (PolarProxy) to each DB node.

PolarProxy_DBQps

server_queries

double

Count/s

Request rate from the PolarDB proxy layer (PolarProxy) to each DB node.

PolarProxy_DBActionOps

server_active_operations

double

Count

Current active requests from the PolarDB proxy layer (PolarProxy) to each DB node.

PolarProxy_LsnNotMatch

service_queries_lsn_not_match

double

Count/s

Rate of requests routed to the primary node due to consistency failures under each cluster endpoint.

PolarProxy_QueriesInTrx

service_queries_in_trx

double

Count/s

Rate of requests routed to the primary node due to transactions under each cluster endpoint.

PolarProxy_Rt

service_proxy_rt

double

Microsecond

Round-trip latency.

PolarProxy_Db_Rt

service_db_rt

double

Microsecond

Average DB time per request.

PolarProxy_Full_Rt

service_full_rt

double

Microsecond

Average total time per request.