Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Situation Awareness
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive
Help Center/ Relational Database Service/ API Reference/ Appendix/ RDS Monitoring Metrics Description

RDS Monitoring Metrics Description

Updated on 2024-01-29 GMT+08:00

Function Description

This section describes namespaces, descriptions, and dimensions of monitoring metrics reported to Cloud Eye. You can query monitoring metrics and alarm information over the Cloud Eye API.

Namespace

SYS.RDS

Monitoring Metrics

Table 1 RDS performance metrics

Metric ID

Name

Description

Value Range

Monitored Object and Instance Type

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0%–100%

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0-100%

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds003_iops

IOPS

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

≥ 0 counts/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥ 0 bytes/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

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: MySQL instances

rds007_conn_active_count

Current Active Connections

Number of current active connections

≥ 0 counts

Monitored object: database

Monitored instance type: MySQL instances

rds008_qps

QPS

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

≥ 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds009_tps

TPS

Execution times of submitted and rollback transactions per second

≥ 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

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: MySQL instances

rds011_innodb_buf_hit

Buffer Pool Hit Rate

Ratio of read hits to read requests in the InnoDB buffer

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds012_innodb_buf_dirty

Buffer Pool Dirty Block Rate

Ratio of dirty data to used pages in the InnoDB buffer

0-1

Monitored object: database

Monitored instance type: MySQL instances

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: MySQL instances

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: MySQL instances

rds015_innodb_read_count

InnoDB File Read Frequency

Number of times that InnoDB reads data from files per second

≥ 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds016_innodb_write_count

InnoDB File Write Frequency

Number of times that InnoDB writes data to files per second

≥ 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

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: MySQL instances

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: MySQL instances

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: MySQL instances

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: MySQL instances

rds021_myisam_buf_usage

Key Buffer Usage

MyISAM key buffer usage

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds022_myisam_buf_write_hit

Key Buffer Write Hit Ratio

MyISAM key buffer write hit ratio

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds023_myisam_buf_read_hit

Key Buffer Read Hit Ratio

MyISAM key buffer read hit ratio

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds024_myisam_disk_write_count

MyISAM Disk Write Frequency

Number of times that indexes are written to disks per second

≥ 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

rds025_myisam_disk_read_count

MyISAM Disk Read Frequency

Number of times that indexes are read from disks per second

≥ 0 times/s

Monitored object: database

Monitored instance type: MySQL instances

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: MySQL instances

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: MySQL instances

rds028_comdml_del_count

DELETE Statements per Second

Number of DELETE statements executed per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds029_comdml_ins_count

INSERT Statements per Second

Number of INSERT statements executed per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds030_comdml_ins_sel_count

INSERT_SELECT Statements per Second

Number of INSERT_SELECT statements executed per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds031_comdml_rep_count

REPLACE Statements per Second

Number of REPLACE statements executed per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds032_comdml_rep_sel_count

REPLACE_SELECTION Statements per Second

Number of REPLACE_SELECTION statements executed per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds033_comdml_sel_count

SELECT Statements per Second

Number of SELECT statements executed per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds034_comdml_upd_count

UPDATE Statements per Second

Number of UPDATE statements executed per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds035_innodb_del_row_count

Row Delete Frequency

Number of rows deleted from the InnoDB table per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds036_innodb_ins_row_count

Row Insert Frequency

Number of rows inserted into the InnoDB table per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds037_innodb_read_row_count

Row Read Frequency

Number of rows read from the InnoDB table per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds038_innodb_upd_row_count

Row Update Frequency

Number of rows updated into the InnoDB table per second

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds039_disk_util

Storage Space Usage

Storage space usage of the monitored object

0-100%

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds040_transaction_logs_usage

Transaction Logs Usage

Storage space usage of transaction logs

≥ 0 MB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds041_replication_slot_usage

Replication Slot Usage

Storage space usage of replication slot files

≥ 0 MB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds042_database_connections

Database Connections in Use

Number of database connections in use

≥ 0 counts

Monitored object: database

Monitored instance type: PostgreSQL instances

rds043_maximum_used_transaction_ids

Maximum Used Transaction IDs

Maximum number of transaction IDs that have been used

≥ 0 counts

Monitored object: database

Monitored instance type: PostgreSQL instances

rds044_transaction_logs_generations

Transaction Logs Generation

Size of transaction logs generated per second

≥ 0 MB/s

Monitored object: database

Monitored instance type: PostgreSQL instances

rds045_oldest_replication_slot_lag

Oldest Replication Slot Lag

Lagging size of the most lagging replica in terms of WAL data received

≥ 0 MB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds046_replication_lag

Replication Lag

Replication lag delay

≥ 0 ms

Monitored object: database

Monitored instance type: PostgreSQL instances

read_count_per_second

Read IOPS

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

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: PostgreSQL instances

write_count_per_second

Write IOPS

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

≥ 0 counts/s

Monitored object: ECS

Monitored instance type: PostgreSQL instances

inactive_logical_replication_slot

Inactive Logical Replication Slots

Number of inactive logical replication slots

≥ 0

Monitored object: database

Monitored instance type: PostgreSQL instances

pgaudit_log_size

Audit Log Size

Size of audit logs

≥ 0 GB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds047_disk_total_size

Total Storage Space

Total storage space of the monitored object

40–4,000 GB

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds048_disk_used_size

Used Storage Space

Used storage space of the monitored object

0–4,000 GB

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds049_disk_read_throughput

Disk Read Throughput

Number of bytes read from the disk per second

≥ 0 bytes/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds050_disk_write_throughput

Disk Write Throughput

Number of bytes written into the disk per second

≥ 0 bytes/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds054_db_connections_in_use

Database Connections in Use

Number of database connections in use

≥ 0 counts

Monitored object: database

Monitored instance type: Microsoft SQL Server instances

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: MySQL instance

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: MySQL instance

Dimension

Key

Value

rds_cluster_id

RDS for MySQL DB instance ID

postgresql_cluster_id

RDS for PostgreSQL DB instance ID

rds_cluster_sqlserver_id

RDS for SQL Server DB instance ID

API Calling

Use APIs to search for RDS monitoring metrics. For details about calling methods and parameter description, see Querying Monitoring Data in the Cloud Eye API Reference.

Examples:

  • Request
/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_util&dim.0=rds_cluster_id,5ea170ad-cc6b-49cd-9020-e94fdbeea391&from=1484123686000&to=1568188853000&period=300&filter=average
  • Response:
{
    "datapoints": [
        {
            "average": 0.35, 
            "timestamp": 1484123400000, 
            "unit": "Ratio"
        },
        {
            "average": 0.11, 
            "timestamp": 1484123700000, 
            "unit": "Ratio"
        }
    ], 
    "metric_name": "rds001_cpu_util",
    "httpcode" : 200,
    "header" : {
    "Transfer-Encoding" : "chunked",
    "Server" : "Web Server",
    "X-Request-Id" : "te-I-CES-APISVR25.id-0418d62a-1e76-46ff-9a5f-9ce40b336e29.ts-1484123744291.c-15046",
    "X-Content-Type-Options" : "nosniff",
    "Connection" : "keep-alive",
    "X-Download-Options" : "noopen",
    "Date" : "Wed, 11 Jan 2017 08:35:44 GMT",
    "X-Frame-Options" : "DENY",
    "Strict-Transport-Security" : "max-age=31536000; includeSubdomains;",
    "Cache-Control" : "no-cache",
    "X-XSS-Protection" : "1; mode=block;",
    "Content-Length" : "165",
    "Content-Type" : "application/json"
}
}

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback