RDS Monitoring Metrics Description

Function Description

This section describes namespaces, descriptions, and dimensions of monitoring metrics reported to Cloud Eye. You can query 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 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 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 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_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 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
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 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
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 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
rds077_buff_write_rate	Buffer Pool Write Frequency	Write frequency of the database buffer pool	≥ 0 counts/s	Monitored object: database Monitored instance type:
rds078_buff_read_rate	Buffer Pool Read Frequency	Read frequency of the database buffer pool	≥ 0 counts/s	Monitored object: database Monitored instance type:
rds079_disk_write_rate	Disk Write Frequency	Write frequency of the database disk	≥ 0 counts/s	Monitored object: database Monitored instance type:
rds080_disk_read_rate	Disk Read Frequency	Read frequency of the database disk	≥ 0 counts/s	Monitored object: database Monitored instance type:

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

Previous topic: Replication Mode Table