Relational Database ServiceRelational Database Service

Compute
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
Domain Name Service
VPC Endpoint
Cloud Connect
Enterprise Switch
Security & Compliance
Anti-DDoS
Web Application Firewall
Host Security Service
Data Encryption Workshop
Database Security Service
Advanced Anti-DDoS
Data Security Center
Container Guard Service
Situation Awareness
Managed Threat Detection
Compass
Cloud Certificate Manager
Anti-DDoS Service
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GaussDB NoSQL
GaussDB(for MySQL)
Distributed Database Middleware
GaussDB(for openGauss)
Developer Services
ServiceStage
Distributed Cache Service
Simple Message Notification
Application Performance Management
Application Operations Management
Blockchain Service
API Gateway
Cloud Performance Test Service
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
DevCloud
ProjectMan
CodeHub
CloudRelease
CloudPipeline
CloudBuild
CloudDeploy
Cloud Communications
Message & SMS
Cloud Ecosystem
Marketplace
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP License Service
Support Plans
Customer Operation Capabilities
Partner Support Plans
Professional Services
enterprise-collaboration
Meeting
IoT
IoT
Intelligent EdgeFabric
DeveloperTools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Updated at: Apr 02, 2022 GMT+08:00

Configuring Displayed Metrics

The RDS Agent monitors RDS DB instances and collects monitoring metrics only.

Description

This section describes the RDS metrics that can be monitored by Cloud Eye as well as their namespaces and dimensions. You can use APIs provided by Cloud Eye to query the monitoring metrics and alarms generated for RDS.

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.RDS

DB Instance Monitoring Metrics

Table 1 lists the performance metrics of RDS for MySQL DB instances.
Table 1 Performance metrics

Metric ID

Name

Description

Value Range

Monitored Object

Monitoring Interval (Raw Data)

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0-100%

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0-100%

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds003_iops

IOPS

Average number of I/O requests processed by the system in a specified period

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds006_conn_count

Total Connections

Total number of connections that attempt to connect to the MySQL server

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds007_conn_active_count

Current Active Connections

Number of current active connections

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds008_qps

QPS

Query times of SQL statements (including stored procedures) per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds009_tps

TPS

Execution times of submitted and rollback transactions per second

≥ 0 transactions/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds010_innodb_buf_usage

Buffer Pool Usage

Ratio of idle pages to the total number of buffer pool pages in the InnoDB buffer

0–1

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds011_innodb_buf_hit

Buffer Pool Hit Ratio

Ratio of read hits to read requests in the InnoDB buffer

0–1

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds012_innodb_buf_dirty

Buffer Pool Dirty Block Ratio

Ratio of dirty data to used pages in the InnoDB buffer

0–1

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds013_innodb_reads

InnoDB Read Throughput

Number of read bytes per second in the InnoDB buffer

≥ 0 bytes/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds014_innodb_writes

InnoDB Write Throughput

Number of write bytes per second in the InnoDB buffer

≥ 0 bytes/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds015_innodb_read_count

InnoDB File Read Frequency

Number of times that InnoDB reads data from files per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds016_innodb_write_count

InnoDB File Write Frequency

Number of times that InnoDB writes data to files per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds017_innodb_log_write_req_count

InnoDB Log Write Requests per Second

Number of InnoDB log write requests per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds018_innodb_log_write_count

InnoDB Log Physical Write Frequency

Number of InnoDB physical write times to log files per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds019_innodb_log_fsync_count

InnoDB Log fsync() Write Frequency

Number of completed fsync() write times to InnoDB log files per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds020_temp_tbl_rate

Temporary Tables Created per Second

Number of temporary tables created on hard disks per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds021_myisam_buf_usage

Key Buffer Usage

MyISAM key buffer usage

0–1

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds022_myisam_buf_write_hit

Key Buffer Write Hit Ratio

MyISAM key buffer write hit ratio

0–1

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds023_myisam_buf_read_hit

Key Buffer Read Hit Ratio

MyISAM key buffer read hit ratio

0–1

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds024_myisam_disk_write_count

MyISAM Disk Write Frequency

Number of times that indexes are written to disks per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds025_myisam_disk_read_count

MyISAM Disk Read Frequency

Number of times that indexes are read from disks per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds026_myisam_buf_write_count

MyISAM Buffer Pool Write Requests per Second

Number of requests for writing indexes into the MyISAM buffer pool per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds027_myisam_buf_read_count

MyISAM Buffer Pool Read Requests per Second

Number of requests for reading indexes from the MyISAM buffer pool per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds028_comdml_del_count

DELETE Statements per Second

Number of DELETE statements executed per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds029_comdml_ins_count

INSERT Statements per Second

Number of INSERT statements executed per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds030_comdml_ins_sel_count

INSERT_SELECT Statements per Second

Number of INSERT_SELECT statements executed per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds031_comdml_rep_count

REPLACE Statements per Second

Number of REPLACE statements executed per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds032_comdml_rep_sel_count

REPLACE_SELECTION Statements per Second

Number of REPLACE_SELECTION statements executed per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds033_comdml_sel_count

SELECT Statements per Second

Number of SELECT statements executed per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds034_comdml_upd_count

UPDATE Statements per Second

Number of UPDATE statements executed per second

≥ 0 queries/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

1 second

rds035_innodb_del_row_count

Row Delete Frequency

Number of rows deleted from the InnoDB table per second

≥ 0 rows/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds036_innodb_ins_row_count

Row Insert Frequency

Number of rows inserted into the InnoDB table per second

≥ 0 rows/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds037_innodb_read_row_count

Row Read Frequency

Number of rows read from the InnoDB table per second

≥ 0 rows/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds038_innodb_upd_row_count

Row Update Frequency

Number of rows updated into the InnoDB table per second

≥ 0 rows/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds039_disk_util

Storage Space Usage

Storage space usage of the monitored object

0-100%

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds047_disk_total_size

Total Storage Space

Total storage space of the monitored object

40–4,000 GB

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds048_disk_used_size

Used Storage Space

Used storage space of the monitored object

0–4,000 GB

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds049_disk_read_throughput

Disk Read Throughput

Number of bytes read from the disk per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds050_disk_write_throughput

Disk Write Throughput

Number of bytes written into the disk per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds072_conn_usage

Connection Usage

Percent of used MySQL connections to the total number of connections

0-100%

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds173_replication_delay_avg

Average Replication Delay

Average replication delay within 60s between standby DB instances or read replicas and primary DB instances, corresponding to seconds_behind_master.

≥ 0s

Monitored object: database

Monitored instance type: RDS for MySQL instance

10 seconds

rds073_replication_delay

Real-Time Replication Delay

Real-time replication delay between standby DB instances or read replicas and primary DB instances, corresponding to seconds_behind_master.

≥ 0s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

5 seconds

rds074_slow_queries

Slow Query Logs

Number of slow query logs generated per minute by MySQL

≥ 0

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds075_avg_disk_ms_per_read

Disk Read Time

Average time required for each disk read in a specified period

≥ 0 ms

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds076_avg_disk_ms_per_write

Disk Write Time

Average time required for each disk write in a specified period

≥ 0 ms

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds077_vma

VMA

Virtual memory area size of an RDS process

≥ 0

counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds078_threads

Threads

Number of threads in a process

≥ 0

counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds079_vm_hwm

Peak Resident Set Size

Peak physical memory usage of an RDS process

≥ 0 KB

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds080_vm_peak

Peak Virtual Memory Size

Peak virtual memory usage of an RDS process

≥ 0 KB

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds081_vm_ioutils

Storage I/O Usage

Percentage of CPU time during which I/O requests were issued to the device

0-1

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds082_semi_sync_tx_avg_wait_time

Transaction Wait Time

Average wait time of transactions in semi-synchronous mode

≥ 0 microseconds

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

sys_swap_usage

SWAP Usage

SWAP usage of the monitored object

0-100%

Monitored object: ECS

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_lock_waits

Row Locks Waits

Number of InnoDB row lock waits

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_bytes_recv_rate

Received Bytes per Second

Number of bytes received by the database per second

≥ 0 bytes/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_bytes_sent_rate

Sent Bytes per Second

Number of bytes sent from the database per second

≥ 0 bytes/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_pages_read_rate

Data Volume Read By InnoDB per Second

Data volume read by InnoDB per second

≥ 0 Pages/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_pages_written_rate

Data Volume Written by InnoDB per Second

Data volume written by InnoDB per second

≥ 0 Pages/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_os_log_written_rate

Redo Log Size Written per Second

Size of redo logs written per second

≥ 0 bytes/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_buffer_pool_read_requests_rate

Innodb_buffer_pool Read Requests per Second

Number of innodb_buffer_pool read requests per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_buffer_pool_write_requests_rate

Innodb_buffer_pool Write Requests per Second

Number of innodb_buffer_pool write requests per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_buffer_pool_pages_flushed_rate

Innodb_buffer_pool Page Flushes per Second

Number of innodb_buffer_pool page flushes per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_log_waits_rate

Flush Times to Disks Due to Insufficient Log Buffer

Times of transaction logs flushed to disks due to insufficient log buffer

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_created_tmp_tables_rate

Temporary Tables Created per Second

Number of temporary tables created per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_wait_thread_count

Waiting Threads

Number of waiting threads

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_row_lock_time_avg

Row Lock Wait Time

Average wait time of InnoDB row locks

> 0 ms

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_row_lock_current_waits

Current Row Lock Waits

Number of current InnoDB row lock waits

≥ 0 counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_mdl_lock_count

MDL Locks

Number of MDL locks

≥ 0

counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_buffer_pool_wait_free

Dirty Pages to Be Flushed to Disks

When InnoDB needs to read or create a page and no clean pages are available, InnoDB flushes some dirty pages first and waits for that operation to finish. This counter counts instances of these waits.

≥ 0

counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_conn_active_usage

Active Connection Usage

Usage of active connections

0-100%

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_innodb_log_waits_count

Log Buffer Status

Number of times that the log buffer was too small and a wait was required for it to be flushed before continuing

≥ 0

counts

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

rds_long_transaction

Long Transaction

Maximum duration for starting a transaction

≥ 0

seconds

Monitored object: database

Monitored instance type: RDS for MySQL instance

1 minute

Table 2 lists the metrics of RDS for MySQL database proxy.
Table 2 RDS for MySQL database proxy metrics

Metric ID

Name

Description

Value Range

Monitored Object

Monitoring Interval (Raw Data)

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0-100%

Monitored object: ECS

Monitored instance type: RDS for MySQL proxy instance

1 minute

5 seconds

1 second

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0-100%

Monitored object: ECS

Monitored instance type: RDS for MySQL proxy instance

1 minute

5 seconds

1 second

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_frontend_connections

Frontend Connections

Number of connections between applications and the proxy

≥ 0 counts

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_backend_connections

Backend Connections

Number of connections between the proxy and RDS database

≥ 0 counts

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_average_response_time

Average Response Time

Average response time

≥ 0 ms

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_query_per_seconds

QPS

Query times of SQL statements

≥ 0 counts

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_read_query_proportions

Read Proportion

Proportion of read requests to total requests

0-100%

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_write_query_proportions

Write Proportion

Proportion of write requests to total requests

0-100%

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

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/s

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_transaction_query

Transaction Queries per Second

Number of SELECT statements executed in transactions per second

≥ 0 counts/s

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

rds_proxy_multi_statement_query

Multi-Statement Queries per Second

Number of multi-statements executed in transactions per second

≥ 0 counts/s

Monitored object: MySQL proxy

Monitored instance type: RDS for MySQL proxy instance

1 minute

Dimension

Key

Value

rds_cluster_id

RDS for MySQL DB instance ID

dbproxy_instance_id

RDS for MySQL proxy instance ID

dbproxy_node_id

RDS for MySQL proxy node ID

Did you find this page helpful?

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel