• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. API Reference
  4. Public Parameters
  5. RDS Monitoring Metrics Description

RDS Monitoring Metrics Description

Function Description

This section describes namespaces, descriptions, and dimensions of monitoring metrics to be reported to Cloud Eye. Users can retrieve monitoring metrics and alarm information reported to Cloud Eye over its API.

Namespace

SYS.RDS

Monitoring Metrics

Table 1 RDS performance metrics

Metrics

Metrics Name

Description

Value Range

Remarks

rds001_cpu_util

CPU Usage

Measures the CPU usage of the monitored object.

0-1

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds002_mem_util

Memory Usage

Measures the memory usage of the monitored object.

0-1

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds003_iops

IOPS

Measures the average number of I/O requests processed by the system per second.

≥ 0 counts/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds004_bytes_in

Network Input Throughput

Measures all network adapter 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

Measures all network adapter 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

Measures the total number of connection attempts to the MySQL server.

≥ 0 counts

Monitored object: database

Monitored instance type: MySQL instances

rds007_conn_active_count

Current Active Connections

Measures the number of current active connections.

≥ 0 counts

Monitored object: database

Monitored instance type: MySQL instances

rds008_qps

QPS

Measures the number of SQL statement queries (including the storage process) per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds009_tps

TPS

Measures the number of transaction executions (including transaction submitting and rollback) per second.

≥ 0 transactions/s

Monitored object: database

Monitored instance type: MySQL instances

rds010_innodb_buf_usage

Buffer Pool Usage

Measures the ratio of dirty data to all data in the InnoDB buffer.

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds011_innodb_buf_hit

Buffer Pool Hit Rate

Measures the ratio of hit read requests to all read requests.

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds012_innodb_buf_dirty

Buffer Pool Dirty Block Rate

Measures the ratio of used pages to all data in the InnoDB buffer.

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds013_innodb_reads

InnoDB Read Throughput

Measures the average number of read bytes per second for the InnoDB buffer. The unit is byte/s.

≥ 0 bytes/s

Monitored object: database

Monitored instance type: MySQL instances

rds014_innodb_writes

InnoDB Write Throughput

Measures the number of write bytes per second for the InnoDB buffer. The unit is byte/s.

≥ 0 bytes/s

Monitored object: database

Monitored instance type: MySQL instances

rds015_innodb_read_count

InnoDB File Read Frequency

Measures the average number of times that InnoDB reads files per second.

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds016_innodb_write_count

InnoDB File Write Frequency

Measures the average number of times that InnoDB writes data into files per second.

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds017_innodb_log_write_req_count

InnoDB Log Write Request Frequency

Measures the average number of 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

Measures the average number of physical writes for 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

Measures the average number of fsync() write requests on log files per second.

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds020_temp_tbl_count

Temporary Tables Qty

Measures the number of temporary tables automatically created on hard disks when MySQL statements are executed.

≥ 0 tables

Monitored object: database

Monitored instance type: MySQL instances

rds021_myisam_buf_usage

Key Buffer Usage

Measures the MyISAM key buffer usage ratio.

0-1

Monitored object: database

Monitored instance type: MySQL instances

rds022_myisam_buf_write_hit

Key Buffer Write Hit Rate

Measures the 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 Rate

Measures the 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

Measures the number of times that indexes are written into disks per second.

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds025_myisam_disk_read_count

MyISAM Disk Read Frequency

Measures the number of times that indexes are read from disks per second.

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds026_myisam_buf_write_count

MyISAM Buffer Pool Write Frequency

Measures the number of requests on 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 Frequency

Measures the number of times that indexes are read from the MyISAM buffer pool per second.

≥ 0 counts/s

Monitored object: database

Monitored instance type: MySQL instances

rds028_comdml_del_count

Delete Operations per Second

Measures the average number of Delete statement executions per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds029_comdml_ins_count

Insert Operations per Second

Measures the average number of Insert statement executions per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds030_comdml_ins_sel_count

Insert_Select Operations per Second

Measures the average number of Insert_Select statement executions per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds031_comdml_rep_count

Replace Operations per Second

Measures the average number of Replace statement executions per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds032_comdml_rep_sel_count

Replace_Selection Operations per Second

Measures the average number of Replace_Selection statement executions per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds033_comdml_sel_count

Select Operations per Second

Measures the average number of Select statement executions per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds034_comdml_upd_count

Update Operations per Second

Measures the average number of Update statement executions per second.

≥ 0 queries/s

Monitored object: database

Monitored instance type: MySQL instances

rds035_innodb_del_row_count

Row Delete Speed

Measures the average number of rows that are deleted from the InnoDB table per second.

≥ 0 rows/s

Monitored object: database

Monitored instance type: MySQL instances

rds036_innodb_ins_row_count

Row Insert Speed

Measures the average number of rows that are inserted into the InnoDB table per second.

≥ 0 rows/s

Monitored object: database

Monitored instance type: MySQL instances

rds037_innodb_read_row_count

Row Read Speed

Measures the average number of rows that are read from the InnoDB table per second.

≥ 0 rows/s

Monitored object: database

Monitored instance type: MySQL instances

rds038_innodb_upd_row_count

Row Update Speed

Measures the number of updated rows in the InnoDB table per second.

≥ 0 rows/s

Monitored object: database

Monitored instance type: MySQL instances

rds039_disk_util

Disk Utilization

Measures the disk usage ratio of the monitored object.

0-1

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds040_transaction_logs_usage

Transaction Logs Usage

Measures the disk capacity used by transaction logs.

≥ 0 MB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds041_replication_slot_usage

Replication Slot Usage

Measures the disk capacity used by replication slot files.

≥ 0 MB

Monitored object: database

Monitored instance type: PostgreSQL instances

rds042_database_connections

Database Connections

Measures the 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

Measures the maximum transaction ID that has been used.

≥ 0 counts

Monitored object: database

Monitored instance type: PostgreSQL instances

rds044_transaction_logs_generations

Transaction Logs Generation

Measures the 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

Measures the 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

Measures the replication lag delay.

≥ 0 ms

Monitored object: database

Monitored instance type: PostgreSQL instances

rds047_disk_total_size

Total Disk Size

Measures the total disk size of the monitored object.

40–4000 GB

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds048_disk_used_size

Disk Usage

Measures the disk usage of the monitored object.

0–4000 GB

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds049_disk_read_throughput

Disk Read Throughput

Measures the number of bytes read from a disk per second.

≥ 0 bytes/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds050_disk_write_throughput

Disk Read Throughput

Measures the number of bytes written to a disk per second.

≥ 0 bytes/s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds051_avg_disk_sec_per_read

Average Time per Disk Read

Measures the average time per disk read operation.

> 0s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds052_avg_disk_sec_per_write

Average Time per Disk Write

Measures the average time per disk write operation.

> 0s

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds053_avg_disk_queue_length

Average Disk Queue Length

Measures the number of threads waiting to be written to the monitored object.

≥ 0

Monitored object: ECS. Monitored DB instance type:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server

rds054_db_connections_in_use

Number of Database Connections in Use

Measures the number of database connections in use.

≥ 0 counts

Monitored object: database

Monitored instance type: Microsoft SQL Server instances

Dimension

Key

Value

rds_instance_id

Specifies the MySQL DB instance ID.

postgresql_instance_id

Specifies the PostgreSQL DB instance ID.

rds_instance_sqlserver_id

Specifies the Microsoft SQL Server DB instance ID.

API Calling

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

Examples:

  • Request
/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_usage&dim.0=rds_instance_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_usage",
    "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"
}
}