Help Center> GaussDB(for MySQL)> User Guide> Metrics and Alarms> Introducing GaussDB(for MySQL) Metrics
Updated on 2024-03-01 GMT+08:00

Introducing GaussDB(for MySQL) Metrics

Function

You can monitor the status of your instances using Cloud Eye. The namespaces, descriptions, and dimensions of monitoring metrics of instances can be reported to Cloud Eye.

The monitoring interval can be 1 minute, 1 second, or 5 seconds. The default monitoring interval is 1 minute. To enable Monitoring by Seconds, contact customer service to apply for the required permissions.

Namespace

SYS.GAUSSDB

Monitoring Metrics Supported by Instances

Table 1 Monitoring metrics supported by GaussDB(for MySQL) instances

Metric ID

Metric

Metric Description

Value Range

Monitored Object

Monitoring Interval (Raw Data)

gaussdb_mysql001_cpu_util

CPU Usage

CPU usage of the monitored object

0–100%

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql002_mem_util

Memory Usage

Memory usage of the monitored object

0–100%

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥0 bytes/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥0 bytes/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql006_conn_count

Total Connections

Total number of connections that attempt to connect to the GaussDB(for MySQL) server

≥0 counts

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql007_conn_active_count

Current Active Connections

Number of active connections

≥0 counts

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql008_qps

QPS

Query times of SQL statements (including DDL, DML, SHOW, SET statements and storage procedures) per second

≥0 times/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql009_tps

TPS

Execution times of submitted and rollback transactions per second

≥0 times/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql010_innodb_buf_usage

Buffer Pool Usage

Ratio of used pages to total pages in the InnoDB buffer

0-1

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql011_innodb_buf_hit

Buffer Pool Hit Ratio

Ratio of read hits to read requests in the InnoDB buffer

0-1

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql012_innodb_buf_dirty

Buffer Pool Dirty Block Ratio

Ratio of dirty data to all data in the InnoDB buffer

0–100%

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql013_innodb_reads

InnoDB Read Throughput

Number of read bytes per second in the InnoDB buffer

≥0 bytes/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql014_innodb_writes

InnoDB Write Throughput

Bytes written to pages by InnoDB per second. GaussDB(for MySQL) writes data only to temporary tables

≥0 bytes/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql017_innodb_log_write_req_count

InnoDB Log Write Request Frequency

Number of InnoDB log write requests per second

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql019_innodb_log_writes

InnoDB Log Writes

Number of physical writes to the InnoDB redo log file

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql020_temp_tbl_count

Temporary Tables

Number of temporary tables automatically created on disks when GaussDB(for MySQL) statements are executed

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql028_comdml_del_count

DELETE Statements per Second

Number of DELETE statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql029_comdml_ins_count

INSERT Statements per Second

Number of INSERT statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql030_comdml_ins_sel_count

INSERT_SELECT Statements per Second

Number of INSERT_SELECT statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql031_comdml_rep_count

REPLACE Statements per Second

Number of REPLACE statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql032_comdml_rep_sel_count

REPLACE_SELECTION Statements per Second

Number of REPLACE_SELECTION statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql033_comdml_sel_count

SELECT Statements per Second

Number of SELECT statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql034_comdml_upd_count

UPDATE Statements per Second

Number of UPDATE statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

5 seconds

1 second

gaussdb_mysql035_innodb_del_row_count

Row Delete Frequency

Number of rows deleted from the InnoDB table per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql036_innodb_ins_row_count

Row Insert Frequency

Number of rows inserted into the InnoDB table per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql037_innodb_read_row_count

Row Read Frequency

Number of rows read from the InnoDB table per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql038_innodb_upd_row_count

Row Update Frequency

Number of rows updated into the InnoDB table per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql048_disk_used_size

Used Storage Space

Used storage space of the monitored object

0 GB-128 TB

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql060_rx_errors

Error Rate of Received Packets

Ratio of the number of error packets to the total number of received packets during the monitoring period

0–100%

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql061_rx_dropped

Loss Rate of Received Packets

Ratio of the number of lost packets to the total number of received packets during the monitoring period

0–100%

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql062_tx_errors

Error Rate of Sent Packets

Ratio of the number of error packets to the total number of sent packets during the monitoring period

0–100%

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql063_tx_dropped

Loss Rate of Sent Packets

Ratio of the number of lost packets to the total number of sent packets during the monitoring period

0–100%

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql072_conn_usage

Connection Usage

Percent of used GaussDB(for MySQL) connections to the total number of connections

0–100%

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql074_slow_queries

Slow Query Logs

Number of GaussDB(for MySQL) slow query logs generated per minute

≥0 counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql077_replication_delay

Replication Delay

Delay between the primary node and read replicas

NOTE:

This metric is used only for read replicas.

≥ 0s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql104_dfv_write_delay

Storage Write Delay

Average delay of writing data to the storage layer in a specified period

≥0 ms

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql105_dfv_read_delay

Storage Read Delay

Average delay of reading data from the storage layer in a specified period

≥0 ms

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql106_innodb_row_lock_current_waits

InnoDB Row Locks

Number of row locks being waited by operations on the InnoDB table

NOTE:

If there are DDL statements, long transactions, or slow SQL statements, the number of row locks being waited may increase.

≥0 locks/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql107_comdml_ins_and_ins_sel_count

INSERT and INSERT_SELECT Statements per Second

Number of INSERT and INSERT_SELECT statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql108_com_commit_count

COMMIT Statements per Second

Number of COMMIT statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql109_com_rollback_count

ROLLBACK Statements per Second

Number of ROLLBACK statements executed per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql110_innodb_bufpool_reads

InnoDB Storage Layer Read Requests per Second

Number of times that InnoDB reads data from the storage layer per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql111_innodb_bufpool_read_requests

InnoDB Read Requests per Second

Number of InnoDB read requests per second

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql114_innodb_bufpool_read_ahead

InnoDB Bufpool Read Ahead

Number of pages read into the InnoDB buffer pool by the read-ahead background thread

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql115_innodb_bufpool_read_ahead_evicted

InnoDB Bufpool Read Ahead Evicted

Number of pages read into the InnoDB buffer pool by the read-ahead background thread that were subsequently evicted without having been accessed by queries

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql116_innodb_bufpool_read_ahead_rnd

InnoDB Bufpool Read Ahead Rnd

Number of random read-aheads initiated by InnoDB

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql117_innodb_pages_read

InnoDB Pages Read

Number of pages read from the InnoDB buffer pool by operations on InnoDB tables

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql118_innodb_pages_written

InnoDB Pages Written

Number of pages written by operations on InnoDB tables

≥0 counts

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql119_disk_used_ratio

Disk Usage

Disk usage of the monitored object

0–100%

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql120_innodb_buffer_pool_bytes_data

Total Bytes of Buffer Pool

Total number of bytes in the InnoDB buffer pool containing data

≥0 bytes

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql121_innodb_row_lock_time

Row Lock Time

Total time spent in acquiring row locks for InnoDB tables

≥0 ms

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql122_innodb_row_lock_waits

Row Lock Waits

Number of times operations on InnoDB tables had to wait for a row lock

≥0 counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql123_sort_range

Sorts Using Ranges

Number of sorts that were done using ranges

≥0 counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql124_sort_rows

Sorted Rows

Number of sorted rows

≥0 counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql125_sort_scan

Sorts by Scanning Tables

Number of sorts that were done by scanning tables.

≥0 counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql126_table_open_cache_hits

Hits for Open Tables Cache Lookups

Number of hits for open tables cache lookups

≥0 counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql127_table_open_cache_misses

Misses for Open Tables Cache Lookups

Number of misses for open tables cache lookups

≥0 counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql128_long_trx_count

Long-Running Transactions

Number of long transactions that are not closed

≥0 counts

GaussDB(for MySQL) instances

150s

gaussdb_mysql342_iostat_iops_write

I/O Write IOPS

I/O write IOPS

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql344_iostat_iops_read

I/O Read IOPS

I/O read IOPS

≥0 counts/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql346_iostat_throughput_write

I/O Write Bandwidth

Disk write bandwidth per second

≥0 bytes/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql348_iostat_throughput_read

I/O Read Bandwidth

Disk read bandwidth per second

≥0 bytes/s

GaussDB(for MySQL) instances

1 minute

gaussdb_mysql371_taurus_binlog_total_file_counts

Binlog Files

Number of GaussDB(for MySQL) binlog files

≥0

GaussDB(for MySQL) instances

5 minutes

gaussdb_mysql378_create_temp_tbl_per_min

Temporary Tables Created per Minute

Number of temporary tables automatically created on disks per minute when GaussDB(for MySQL) statements are executed

≥0

counts/min

GaussDB(for MySQL) instances

1 minute

gaussdb386_undo_spaces_trx_count

Existing Transactions in Undo Space

Number of transactions that are not cleared in the undo space.

≥0

GaussDB(for MySQL) instances

30s

Monitoring Metrics Supported By Proxy

Table 2 GaussDB(for MySQL) Proxy metrics

Metric ID

Metric

Metric Description

Value Range

Monitored Object

Monitoring Interval (Raw Data)

rds_proxy_frontend_connections

Frontend Connections

Number of connections between applications and the proxy

≥ 0 counts

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_backend_connections

Backend Connections

Number of connections between the proxy and GaussDB(for MySQL) databases

≥ 0 counts

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_average_response_time

Average Response Time

Average response time

≥0 ms

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_query_per_seconds

QPS

Query times of SQL statements

≥ 0 counts

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_read_query_proportions

Read Proportion

Proportion of read requests to total requests

0–100%

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_write_query_proportions

Write Proportion

Proportion of write requests to total requests

0–100%

GaussDB(for MySQL) proxy instances

1 minute

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0–100%

GaussDB(for MySQL) proxy instances

1 minute

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0–100%

GaussDB(for MySQL) proxy instances

1 minute

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥0 bytes/s

GaussDB(for MySQL) proxy instances

1 minute

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥0 bytes/s

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_frontend_connection_creation

Front-End Connections Created per Second

Number of connections created per second between the database proxy and applications

≥ 0 counts

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_multi_statement_query

Multi-Statement Queries per Second

Number of multi-statements executed in transactions per second

≥ 0 counts

GaussDB(for MySQL) proxy instances

1 minute

rds_proxy_transaction_query

Transaction Queries per Second

Number of SELECT statements executed in transactions per second

≥ 0 counts

GaussDB(for MySQL) proxy instances

1 minute

Dimension

Table 3 Monitoring metric dimension

Key

Value

gaussdb_mysql_instance_id

GaussDB(for MySQL) instance ID.

gaussdb_mysql_node_id

GaussDB(for MySQL) node ID.

dbproxy_instance_id

GaussDB(for MySQL) proxy instance ID

dbproxy_node_id

GaussDB(for MySQL) proxy node ID