RDS Metrics

Function

This section describes metrics reported by Cloud Eye to the Relational Database Service (RDS) as well as their namespaces and dimensions. You can use APIs provided by Cloud Eye to query the metrics of the monitored object and alarms generated for RDS.

Namespace

SYS.RDS

Metrics

**Table 1** MySQL metrics
Metric	Name	Description	Value Range	Remarks
rds001_cpu_usage	CPU Usage	CPU usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: MySQL instance
rds002_mem_usage	Memory Usage	Memory usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: MySQL instance
rds003_iops	IOPS	Average rate at which I/O requests are processed during a specified period Unit: Count/s	≥ 0 counts/s	Monitored object: ECS Monitored instance type: MySQL instance
rds004_bytes_in	Network Input Throughput	Rate at which all incoming traffic passes through the network adapter Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: MySQL instance
rds005_bytes_out	Network Output Throughput	Rate at which all outgoing traffic passes through the network adapter Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: MySQL instance
rds006_conn_count	Total Connections	Total number of connection attempts to the MySQL server Unit: Count	≥ 0 counts	Monitored object: database Monitored instance type: MySQL instance
rds007_conn_active_count	Current Active Connections	Number of current active connections Unit: Count	≥ 0 counts	Monitored object: database Monitored instance type: MySQL instance
rds008_qps	QPS	Rate at which SQL statement queries (including the stored procedure) are executed Unit: Query/s	≥ 0 queries/s	Monitored object: database Monitored instance type: MySQL instance
rds009_tps	TPS	Rate at which transactions (including those submitted and rolled back) are executed Unit: Transaction/s	≥ 0 transactions/s	Monitored object: database Monitored instance type: MySQL instance
rds010_innodb_buf_usage	Buffer Pool Usage	Ratio of dirty data from all data in the InnoDB buffer Unit: Ratio	0-1	Monitored object: database Monitored instance type: MySQL instance
rds011_innodb_buf_hit	Buffer Pool Hit Rate	Ratio of read hits to read requests in the InnoDB buffer Unit: Ratio	0-1	Monitored object: database Monitored instance type: MySQL instance
rds012_innodb_buf_dirty	Buffer Pool Dirty Block Rate	Ratio of used pages to total data in the InnoDB buffer Unit: Ratio	0-1	Monitored object: database Monitored instance type: MySQL instance
rds013_innodb_reads	InnoDB Read Throughput	Average rate at which data is read by the InnoDB buffer Unit: byte/s	≥ 0 bytes/s	Monitored object: database Monitored instance type: MySQL instance
rds014_innodb_writes	InnoDB Write Throughput	Average rate at which data is written by the InnoDB buffer Unit: byte/s	≥ 0 bytes/s	Monitored object: database Monitored instance type: MySQL instance
rds015_innodb_read_count	InnoDB File Read Frequency	Average rate at which the InnoDB reads files Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds016_innodb_write_count	InnoDB File Write Frequency	Average rate at which the InnoDB writes data Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds017_innodb_log_write_req_count	InnoDB Log Write Request Frequency	Average rate at which log write requests are received Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds018_innodb_log_write_count	InnoDB Log Physical Write Frequency	Average rate at which log write requests are received Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds019_innodb_log_fsync_count	InnoDB Log fsync() Write Frequency	Average rate at which fsync() write requests on log files are received Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds020_temp_tbl_count	Temporary Tables Qty	Number of temporary tables automatically created on hard disks when MySQL statements are executed Unit: Table	≥ 0 tables	Monitored object: database Monitored instance type: MySQL instance
rds021_myisam_buf_usage	Key Buffer Usage	MyISAM key buffer usage ratio Unit: Ratio	0-1	Monitored object: database Monitored instance type: MySQL instance
rds022_myisam_buf_write_hit	Key Buffer Write Hit Rate	MyISAM Key buffer write hit ratio of the monitored object Unit: Ratio	0-1	Monitored object: database Monitored instance type: MySQL instance
rds023_myisam_buf_read_hit	Key Buffer Read Hit Rate	MyISAM Key buffer read hit ratio of the monitored object Unit: Ratio	0-1	Monitored object: database Monitored instance type: MySQL instance
rds024_myisam_disk_write_count	MyISAM Disk Write Frequency	Rate at which indexes are written into disks Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds025_myisam_disk_read_count	MyISAM Disk Read Frequency	Rate at which indexes are read from disks Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds026_myisam_buf_write_count	MyISAM Buffer Pool Write Frequency	Rate at which requests on writing indexes into the MyISAM buffer pool are received Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds027_myisam_buf_read_count	MyISAM Buffer Pool Read Frequency	Rate at which requests on reading indexes from the MyISAM buffer pool are received Unit: Count/s	≥ 0 counts/s	Monitored object: database Monitored instance type: MySQL instance
rds028_comdml_del_count	Delete Operations per Second	Average rate at which Delete statements are executed Unit: Count/s	≥ 0 executions/s	Monitored object: database Monitored instance type: MySQL instance
rds029_comdml_ins_count	Insert Operations per Second	Average rate at which Insert statements are executed Unit: Execution/s	≥ 0 executions/s	Monitored object: database Monitored instance type: MySQL instance
rds030_comdml_ins_sel_count	Insert_Select Operations per Second	Average rate at which Insert-Select statements are executed Unit: Execution/s	≥ 0 executions/s	Monitored object: database Monitored instance type: MySQL instance
rds031_comdml_rep_count	Replace Operations per Second	Average rate at which Replace statements are executed Unit: Execution/s	≥ 0 executions/s	Monitored object: database Monitored instance type: MySQL instance
rds032_comdml_rep_sel_count	Replace_Selection Operations per Second	Average rate at which Replace_Selection statements are executed Unit: Execution/s	≥ 0 executions/s	Monitored object: database Monitored instance type: MySQL instance
rds033_comdml_sel_count	Select Operations per Second	Average rate at which Select statements are executed Unit: Execution/s	≥ 0 executions/s	Monitored object: database Monitored instance type: MySQL instance
rds034_comdml_upd_count	Update Operations per Second	Average rate at which Update statements are executed Unit: Execution/s	≥ 0 executions/s	Monitored object: database Monitored instance type: MySQL instance
rds035_innodb_del_row_count	Row Delete Speed	Average rate at which rows are deleted from the InnoDB table Unit: Row/s	≥ 0 rows/s	Monitored object: database Monitored instance type: MySQL instance
rds036_innodb_ins_row_count	Row Insert Speed	Average rate at which rows are inserted into the InnoDB table Unit: Row/s	≥ 0 rows/s	Monitored object: database Monitored instance type: MySQL instance
rds037_innodb_read_row_count	Row Read Speed	Average rate at which rows are read from the InnoDB table Unit: Row/s	≥ 0 rows/s	Monitored object: database Monitored instance type: MySQL instance
rds038_innodb_upd_row_count	Row Update Speed	Average rate at which rows are updated in the InnoDB table Unit: Row/s	≥ 0 rows/s	Monitored object: database Monitored instance type: MySQL instance
rds039_disk_usage	Disk Utilization	Disk usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: MySQL instance
rds047_disk_total_size	Total Disk Size	Total disk size of the monitored object Unit: GB	40-2000 GB	Monitored object: ECS Monitored instance type: MySQL instance
rds048_disk_used_size	Storage Space Used	Amount of used storage space size of the monitored object Unit: GB	0-2000 GB	Monitored object: ECS Monitored instance type: MySQL instance
rds049_disk_read_throughput	Disk Read Throughput	Rate at which data is read from a disk Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: MySQL instance
rds050_disk_write_throughput	Disk Write Throughput	Rate at which data is written to a disk Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: MySQL instance
rds051_avg_disk_sec_per_read	Average Time per Disk Read	Time required for reading 1 KB disk data Unit: Second	> 0s	Monitored object: ECS Monitored instance type: MySQL instance
rds052_avg_disk_sec_per_write	Average Time per Disk Write	Time required for writing 1 KB data to a disk Unit: Second	> 0s	Monitored object: ECS Monitored instance type: MySQL instance
rds053_avg_disk_queue_length	Average Disk Queue Length	Number of processes waiting to be written to the monitored object	≥ 0	Monitored object: ECS Monitored instance type: MySQL instance

**Table 2** PostgreSQL metrics
Metric	Name	Description	Value Range	Remarks
rds001_cpu_usage	CPU Usage	CPU usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds002_mem_usage	Memory Usage	Memory usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds003_iops	IOPS	Average rate at which I/O requests are processed during a specified period Unit: Count/s	≥ 0 counts/s	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds004_bytes_in	Network Input Throughput	Rate at which all incoming traffic passes through the network adapter Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds005_bytes_out	Network Output Throughput	Rate at which all outgoing traffic passes through the network adapter Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds039_disk_usage	Disk Utilization	Disk usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds040_transaction_logs_usage	Transaction Logs Usage	Disk capacity used by transaction logs Unit: MB	≥ 0 MB	Monitored object: database Monitored instance type: PostgreSQL instance
rds041_replication_slot_usage	Replication Slot Usage	Disk capacity used by replication slot files Unit: MB	≥ 0 MB	Monitored object: database Monitored instance type: PostgreSQL instance
rds042_database_connections	Database Connections	Number of database connections in use Unit: Count	≥ 0 counts	Monitored object: database Monitored instance type: PostgreSQL instance
rds043_maximum_used_transaction_ids	Maximum Used Transaction IDs	Maximum transaction IDs that have been used Unit: Count	≥ 0 counts	Monitored object: database Monitored instance type: PostgreSQL instance
rds044_transaction_logs_generations	Transaction Logs Generations	Size of transaction logs generated per second Unit: MB/s	≥ 0 MB/s	Monitored object: database Monitored instance type: PostgreSQL instance
rds045_oldest_replication_slot_lag	Oldest Replication Slot Lag	Lagging size of the most lagging replica in terms of WAL data received Unit: MB	≥ 0 MB	Monitored object: database Monitored instance type: PostgreSQL instance
rds046_replication_lag	Replication Lag	Replication lag delay Unit: ms	≥ 0 ms	Monitored object: database Monitored instance type: PostgreSQL instance
rds047_disk_total_size	Total Disk Size	Total disk size of the monitored object Unit: GB	40-2000 GB	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds048_disk_used_size	Storage Space Used	Amount of used storage space size of the monitored object Unit: GB	0-2000 GB	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds049_disk_read_throughput	Disk Read Throughput	Rate at which data is read from a disk Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds050_disk_write_throughput	Disk Write Throughput	Rate at which data is written to a disk Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds051_avg_disk_sec_per_read	Average Time per Disk Read	Time required for reading 1 KB disk data Unit: Second	> 0s	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds052_avg_disk_sec_per_write	Average Time per Disk Write	Time required for writing 1 KB data to a disk Unit: Second	> 0s	Monitored object: ECS Monitored instance type: PostgreSQL instance
rds053_avg_disk_queue_length	Average Disk Queue Length	Number of processes waiting to be written to the monitored object	≥ 0	Monitored object: ECS Monitored instance type: PostgreSQL instance

**Table 3** Microsoft SQL Server metrics
Metric	Name	Description	Value Range	Remarks
rds001_cpu_usage	CPU Usage	CPU usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds002_mem_usage	Memory Usage	Memory usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds003_iops	IOPS	Average rate at which I/O requests are processed during a specified period Unit: Count/s	≥ 0 counts/s	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds004_bytes_in	Network Input Throughput	Rate at which all incoming traffic passes through the network adapter Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds005_bytes_out	Network Output Throughput	Rate at which all outgoing traffic passes through the network adapter Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds039_disk_usage	Disk Utilization	Disk usage of the monitored object Unit: Ratio	0-1	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds047_disk_total_size	Total Disk Size	Total disk size of the monitored object Unit: GB	40-2000 GB	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds048_disk_used_size	Storage Space Used	Amount of used storage space size of the monitored object Unit: GB	0-2000 GB	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds049_disk_read_throughput	Disk Read Throughput	Rate at which data is read from a disk Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds050_disk_write_throughput	Disk Write Throughput	Rate at which data is written to a disk Unit: byte/s	≥ 0 bytes/s	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds051_avg_disk_sec_per_read	Average Time per Disk Read	Time required for reading 1 KB disk data Unit: Second	> 0s	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds052_avg_disk_sec_per_write	Average Time per Disk Write	Time required for writing 1 KB data to a disk Unit: Second	> 0s	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds053_avg_disk_queue_length	Average Disk Queue Length	Number of processes waiting to be written to the monitored object	≥ 0	Monitored object: ECS Monitored instance type: Microsoft SQL Server instance
rds054_db_connections_in_use	Number of Database Connections In Use	Number of database connections in use Unit: Count	≥ 0 counts	Monitored object: database Monitored instance type: Microsoft SQL Server instance