# 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
Metric | Name | Description | Value Range | Remarks
--- | --- | --- | --- | ---

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 count/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 byte/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 byte/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 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 | 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 used pages to total 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 byte/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 byte/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 count/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 times/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 times/s | Monitored object: database Monitored instance type: MySQL instances
rds020_temp_tbl_count | Temporary Tables | Number of temporary tables automatically created on hard disks when MySQL statements are executed | ≥ 0 counts | 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 count/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 count/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 count/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 count/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 count/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 count/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 count/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 count/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 count/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 count/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 count/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 count/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 count/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

rds047_disk_total_size

Total Storage Space

Total storage space of the monitored object

40–4000 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–4000 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 byte/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 byte/s

Monitored object: ECS. Monitored DB instance type:

- MySQL
- PostgreSQL
- Microsoft SQL Server

rds051_avg_disk_sec_per_read

Disk Read Time

Average time required for each disk read in a specified period

≥ 0 ms

Monitored object: ECS. Monitored DB instance type:

- MySQL
- PostgreSQL
- Microsoft SQL Server

rds052_avg_disk_sec_per_write

Disk Write Time

Average time required for each disk write in a specified period

> 0 ms

Monitored object: ECS. Monitored DB instance type:

- MySQL
- PostgreSQL
- Microsoft SQL Server

rds053_avg_disk_queue_length

Average Disk Queue Length

Number of processes to be written into the monitored object

≥ 0

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

#### 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"
    }
    }

Parent topic: Appendix