PolarDB:Performance metrics

Performance metric

Submetric

Data type

Unit

Description

PolarDBDiskUsage

mean_data_size

double

MB

The storage space occupied by 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 storage space occupied by other logs.

mean_undolog_size

double

MB

The storage space occupied by 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 utilization (%).

PolarDBMemory

mem_ratio

double

Percentage

The memory usage (%).

PolarDBConnections

mean_active_session

double

N/A

The number of connections in the active state.

thread_pool_running_threads

double

N/A

The number of threads that are being executed in the thread pool.

mean_total_session

double

N/A

The total number of connections.

tp_thread_count

double

N/A

The total number of threads in the thread pool.

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 (%) of 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 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

N/A

The number of rows deleted per second.

mean_innodb_rows_inserted

double

N/A

The number of rows inserted per second.

mean_innodb_rows_read

double

N/A

The number of rows read per second.

mean_innodb_rows_updated

double

N/A

The number of rows updated per second.

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.

PolarDBReplicaLag

mean_replication_delay

double

Seconds

The replication latency.

Performance metric

Submetric

Data type

Unit

Description

PolarDBCPU

cpu_ratio

double

Percentage

The total CPU utilization.

cpu_sys_ratio

double

Percentage

The CPU utilization in the system state.

cpu_user_ratio

double

Percentage

The CPU utilization in the user state.

PolarDBMemory

mem_ratio

double

Percentage

The memory usage.

PolarDBMemoryForPCU

pcu_mem_usage

double

Percentage

The memory usage by PCU.

PolarDBCPUForPCU

pcu_cpu_usage

double

Percentage

The CPU utilization by PCU.

PolarDBPCU

pcu_by_cpu_cores

double

Core

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

N/A

The write IOPS.

mean_iops_r

double

N/A

The read IOPS.

mean_iops

double

N/A

The total IOPS.

PolarDBDiskUsage

mean_tmp_size

double

MB

The used temporary space.

mean_log_size

double

MB

The space used by local logs.

mean_wal_size

double

MB

The space used by 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 slot latency.

mean_logical_rep_latency_in_mb

double

MB

The logical replication latency.

mean_send_latency_in_mb

double

MB

The primary node send latency.

mean_replay_latency_in_mb

double

MB

The standby node replay latency.

PolarDBSQL

mean_five_seconds_two_pc_transactions

double

N/A

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

mean_three_seconds_two_pc_transactions

double

N/A

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

mean_one_second_two_pc_transactions

double

N/A

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

mean_five_seconds_long_transactions

double

N/A

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

mean_three_seconds_transactions

double

N/A

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

mean_one_second_transactions

double

N/A

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

mean_five_seconds_idle_transactions

double

N/A

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

mean_three_seconds_idle_transactions

double

N/A

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

mean_one_second_idle_transactions

double

N/A

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

mean_five_seconds_executing_sqls

double

N/A

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

mean_three_seconds_executing_sqls

double

N/A

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

mean_one_second_executing_sqls

double

N/A

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

PolarDBSlowSQLTime

max_executing_sql_last_time

double

ms

The execution duration of the slowest SQL statement.

PolarDBReplicationSlots

total_slots

double

N/A

The number of replication slots.

inactive_slots

double

N/A

The number of inactive replication slots.

PolarDBVacuum

mean_db_age

double

xids

The maximum database age.

PolarDBTransaction

mean_long_two_pc_transactions

double

N/A

The number of long-running two-phase transactions.

mean_two_pc_transactions

double

N/A

The number of two-phase transactions.

mean_long_transactions

double

N/A

The number of long-running transactions.

mean_long_idle_transactions

double

N/A

The number of idle long-running transactions.

mean_idle_transactions

double

N/A

The number of idle transactions.

mean_waiting_transactions

double

N/A

The number of pending transactions.

mean_active_transactions

double

N/A

The number of active transactions.

PolarDBBuffer

mean_blks_hit_delta

double

N/A

The number of block hits per second.

mean_blks_read_delta

double

N/A

The number of block reads per second.

mean_buffers_alloc

double

N/A

The total number of allocated buffers.

mean_buffers_backend_fsync

double

N/A

The total number of backend fsync calls.

mean_buffers_backend

double

N/A

The total number of buffers written by a backend.

mean_buffers_clean

double

N/A

The total number of buffers written by the background writer during checkpoints.

mean_hit_ratio

double

Percentage

The block hit ratio.

PolarDBTemp

mean_temp_bytes

double

Bytes

The size of temporary files that are generated per second.

mean_temp_files

double

N/A

The number of temporary files that are generated per second.

PolarDBQPSTPS

mean_deadlocks_delta

double

N/A

The number of deadlocks per second.

mean_rollbacks_delta

double

N/A

The number of rollbacks per second.

mean_commits_delta

double

N/A

The number of commits per second.

mean_tps

double

N/A

The number of transactions that are processed per second.

PolarDBRowDML

mean_tup_deleted_delta

double

N/A

The number of rows deleted per second.

mean_tup_updated_delta

double

N/A

The number of rows updated per second.

mean_tup_inserted_delta

double

N/A

The number of rows inserted per second.

mean_tup_fetched_delta

double

N/A

The number of rows read per second.

mean_tup_returned_delta

double

N/A

The number of rows returned per second.

PolarDBConnections

mean_idle_connection

double

N/A

The number of connections in the idle state.

mean_waiting_connection

double

N/A

The number of connections in the waiting state.

mean_active_session

double

N/A

The number of active sessions.

mean_total_session

double

N/A

The total number of sessions.

Performance metric

Submetric

Data type

Unit

Description

PolarProxy_CpuUsage

docker_container_cpu

double

Percentage

The CPU utilization on PolarProxy.

PolarProxy_Cps

service_connections_ps

double

Connections per second

The number of new connections per second on PolarProxy.

PolarProxy_CurrentConns

service_current_connections

double

N/A

The number of current connections on PolarProxy.

PolarProxy_UpFlows

service_upstream_netflow

double

KB/s

The amount of inbound network traffic per second on PolarProxy.

PolarProxy_DownFlows

service_downstream_netflow

double

KB/s

The amount of outbound network traffic per second on PolarProxy.

PolarProxy_Qps

service_queries

double

Requests per second

The number of requests per second on PolarProxy.

PolarProxy_DBConns

server_connections

double

N/A

The number of connections from PolarProxy to each node in the database.

PolarProxy_DBQps

server_queries

double

Requests per second

The request rate from PolarProxy to each node in the database.

PolarProxy_DBActionOps

server_active_operations

double

N/A

The number of active requests from PolarProxy to each node in the database.

PolarProxy_LsnNotMatch

service_queries_lsn_not_match

double

Requests per second

The rate at which requests are routed to the primary node due to inconsistency under each cluster endpoint.

PolarProxy_QueriesInTrx

service_queries_in_trx

double

Requests per second

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

PolarProxy_Rt

service_proxy_rt

double

Microseconds

The round-trip latency.

PolarProxy_Db_Rt

service_db_rt

double

Microseconds

The average database time of each request.

PolarProxy_Full_Rt

service_full_rt

double

Microseconds

The average total duration of each request.