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, see Configuring Monitoring by Seconds.

Namespace

Namespace of RDS for MySQL single or primary/standby instance metrics: SYS. RDS
Namespace of database proxy metrics: SYS.DBPROXY

DB Instance Monitoring Metrics

Table 1 lists the performance metrics of RDS for MySQL 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%	RDS for MySQL instance	1 minute 5 seconds 1 second
rds002_mem_util	Memory Usage	Memory usage of the monitored object	0-100%	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	RDS for MySQL instance	1 minute
rds004_bytes_in	Network Input Throughput	Incoming traffic in bytes per second	≥ 0 bytes/s	RDS for MySQL instance	1 minute
rds005_bytes_out	Network Output Throughput	Outgoing traffic in bytes per second	≥ 0 bytes/s	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	RDS for MySQL instance	1 minute 5 seconds 1 second
rds007_conn_active_count	Current Active Connections	Number of connections not in the sleep state	≥ 0 counts	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	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	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	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	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	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	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	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	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	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	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	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	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	RDS for MySQL instance	1 minute
rds021_myisam_buf_usage	Key Buffer Usage	MyISAM key buffer usage	0–1	RDS for MySQL instance	1 minute
rds022_myisam_buf_write_hit	Key Buffer Write Hit Ratio	MyISAM key buffer write hit ratio	0–1	RDS for MySQL instance	1 minute
rds023_myisam_buf_read_hit	Key Buffer Read Hit Ratio	MyISAM key buffer read hit ratio	0–1	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	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	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	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	RDS for MySQL instance	1 minute
rds028_comdml_del_count	DELETE Statements per Second	Number of DELETE statements executed per second	≥ 0 queries/s	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	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	RDS for MySQL instance	1 minute
rds031_comdml_rep_count	REPLACE Statements per Second	Number of REPLACE statements executed per second	≥ 0 queries/s	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	RDS for MySQL instance	1 minute
rds033_comdml_sel_count	SELECT Statements per Second	Number of SELECT statements executed per second	≥ 0 queries/s	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	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	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	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	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	RDS for MySQL instance	1 minute
rds039_disk_util	Storage Space Usage	Storage space usage of the monitored object	0-100%	RDS for MySQL instance	1 minute
rds047_disk_total_size	Total Storage Space	Total storage space of the monitored object	40 GB~4000 GB	RDS for MySQL instance	1 minute
rds048_disk_used_size	Used Storage Space	Used storage space of the monitored object	0 GB~4000 GB	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	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	RDS for MySQL instance	1 minute
rds072_conn_usage	Connection Usage	Percent of used MySQL connections to the total number of connections	0-100%	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	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	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 counts/min	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	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	RDS for MySQL instance	1 minute
rds077_vma	VMA	Virtual memory area size of an RDS process	≥ 0 counts	RDS for MySQL instance	1 minute
rds078_threads	Threads	Number of threads in a process	≥ 0 counts	RDS for MySQL instance	1 minute
rds079_vm_hwm	Peak Resident Set Size	Peak physical memory usage of an RDS process	≥ 0 KB	RDS for MySQL instance	1 minute
rds080_vm_peak	Peak Virtual Memory Size	Peak virtual memory usage of an RDS process	≥ 0 KB	RDS for MySQL instance	1 minute
rds081_vm_ioutils	The time percentage of disk I/O in a non idle state	Percentage of time when the disk is not idle (there is I/O activity). This parameter indicates how busy the disk is. The disk can process I/O requests in parallel. If the value of this parameter reaches 100%, the disk may not reach its maximum processing capability.	0-100%	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	RDS for MySQL instance	1 minute
sys_swap_usage	SWAP Usage	SWAP usage of the monitored object	0-100%	RDS for MySQL instance	1 minute
rds_innodb_lock_waits	Row Locks Waits Transactions	Number of InnoDB transactions waiting for row lock	≥ 0 counts	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	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	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	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	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	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	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	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	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	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	RDS for MySQL instance	1 minute
rds_wait_thread_count	Waiting Threads	Number of waiting threads	≥ 0 counts	RDS for MySQL instance	1 minute
rds_innodb_row_lock_time_avg	Average Row Lock Wait Time	Average wait time of historical InnoDB row locks	> 0 ms	RDS for MySQL instance	1 minute
rds_innodb_row_lock_current_waits	Current Row Lock Waits	Number of current InnoDB row lock waits This metric indicates the number of transactions that are currently waiting for row locks.	≥ 0 counts	RDS for MySQL instance	1 minute
rds_mdl_lock_count	MDL Locks	Number of MDL locks	≥ 0 counts	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	≥ 0 counts	RDS for MySQL instance	1 minute
rds_conn_active_usage	Active Connection Usage	Usage of active connections	0-100%	RDS for MySQL instance	1 minute
rds_innodb_log_waits_count	Log Waits	Number of times that the log buffer was too small and a wait was required for it to be flushed before continuing The value is an accumulated value and increases by 1 each time a wait occurs.	≥ 0 counts	RDS for MySQL instance	1 minute
rds_long_transaction	Long Transaction	Maximum duration for starting a transaction A complete long transaction is counted only when the BEGIN and COMMIT commands exist before and after the related operation commands, respectively.	≥ 0 seconds	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%	RDS for MySQL proxy instance	1 minute 5 seconds 1 second
rds002_mem_util	Memory Usage	Memory usage of the monitored object	0-100%	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	RDS for MySQL proxy instance	1 minute
rds005_bytes_out	Network Output Throughput	Outgoing traffic in bytes per second	≥ 0 bytes/s	RDS for MySQL proxy instance	1 minute
rds_proxy_frontend_connections	Frontend Connections	Number of connections between applications and the proxy	≥ 0 counts	RDS for MySQL proxy instance	1 minute
rds_proxy_backend_connections	Backend Connections	Number of connections between the proxy and RDS database	≥ 0 counts	RDS for MySQL proxy instance	1 minute
rds_proxy_average_response_time	Average Response Time	Average response time	≥ 0 ms	RDS for MySQL proxy instance	1 minute
rds_proxy_query_per_seconds	QPS	Query times of SQL statements	≥ 0 counts	RDS for MySQL proxy instance	1 minute
rds_proxy_read_query_proportions	Read Proportion	Proportion of read requests to total requests	0-100%	RDS for MySQL proxy instance	1 minute
rds_proxy_write_query_proportions	Write Proportion	Proportion of write requests to total requests	0-100%	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	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	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	RDS for MySQL proxy instance	1 minute