RDS for MySQL Metrics
Description
This section describes namespaces, descriptions, and dimensions of metrics reported by RDS for MySQL to Cloud Eye. You can use APIs provided by Cloud Eye to retrieve metrics and alarms generated for RDS for MySQL.
Namespace
SYS.RDS
Metrics
Metric ID |
Name |
Description |
Value Range |
Monitored Object and Instance Type |
---|---|---|---|---|
rds001_cpu_util |
CPU Usage |
CPU usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds002_mem_util |
Memory Usage |
Memory usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds003_iops |
IOPS |
Average number of I/O requests processed by the system in a specified period |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds004_bytes_in |
Network Input Throughput |
Incoming traffic in bytes per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds005_bytes_out |
Network Output Throughput |
Outgoing traffic in bytes per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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: RDS for MySQL instance |
rds007_conn_active_count |
Current Active Connections |
Number of current active connections |
≥ 0 counts |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds008_qps |
QPS |
Query times of SQL statements (including stored procedures) per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds009_tps |
TPS |
Execution times of submitted and rollback transactions per second |
≥ 0 transactions/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds011_innodb_buf_hit |
Buffer Pool Hit Ratio |
Ratio of read hits to read requests in the InnoDB buffer |
0–1 |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds012_innodb_buf_dirty |
Buffer Pool Dirty Block Ratio |
Ratio of dirty data to used pages in the InnoDB buffer |
0–1 |
Monitored object: database Monitored instance type: RDS for MySQL instance |
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: RDS for MySQL instance |
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: RDS for MySQL instance |
rds015_innodb_read_count |
InnoDB File Read Frequency |
Number of times that InnoDB reads data from files per second |
≥ 0 counts/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds016_innodb_write_count |
InnoDB File Write Frequency |
Number of times that InnoDB writes data to files per second |
≥ 0 counts/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
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: RDS for MySQL instance |
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: RDS for MySQL instance |
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: RDS for MySQL instance |
rds020_temp_tbl_rate |
Temporary Tables Created per Second |
Number of temporary tables created on hard disks per second |
≥ 0 counts/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds021_myisam_buf_usage |
Key Buffer Usage |
MyISAM key buffer usage |
0–1 |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds022_myisam_buf_write_hit |
Key Buffer Write Hit Ratio |
MyISAM key buffer write hit ratio |
0–1 |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds023_myisam_buf_read_hit |
Key Buffer Read Hit Ratio |
MyISAM key buffer read hit ratio |
0–1 |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds024_myisam_disk_write_count |
MyISAM Disk Write Frequency |
Number of times that indexes are written to disks per second |
≥ 0 counts/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds025_myisam_disk_read_count |
MyISAM Disk Read Frequency |
Number of times that indexes are read from disks per second |
≥ 0 counts/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds026_myisam_buf_write_count |
MyISAM Buffer Pool Write Requests per Second |
Number of requests for writing indexes into the buffer pool per second |
≥ 0 counts/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds027_myisam_buf_read_count |
MyISAM Buffer Pool Read Requests per Second |
Number of requests for reading indexes from the buffer pool per second |
≥ 0 counts/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds028_comdml_del_count |
DELETE Statements per Second |
Number of DELETE statements executed per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds029_comdml_ins_count |
INSERT Statements per Second |
Number of INSERT statements executed per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds030_comdml_ins_sel_count |
INSERT_SELECT Statements per Second |
Number of INSERT_SELECT statements executed per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds031_comdml_rep_count |
REPLACE Statements per Second |
Number of REPLACE statements executed per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds032_comdml_rep_sel_count |
REPLACE_SELECTION Statements per Second |
Number of REPLACE_SELECTION statements executed per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds033_comdml_sel_count |
SELECT Statements per Second |
Number of SELECT statements executed per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds034_comdml_upd_count |
UPDATE Statements per Second |
Number of UPDATE statements executed per second |
≥ 0 queries/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds035_innodb_del_row_count |
Row Delete Frequency |
Number of rows deleted from the InnoDB table per second |
≥ 0 rows/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds036_innodb_ins_row_count |
Row Insert Frequency |
Number of rows inserted into the InnoDB table per second |
≥ 0 rows/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds037_innodb_read_row_count |
Row Read Frequency |
Number of rows read from the InnoDB table per second |
≥ 0 rows/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds038_innodb_upd_row_count |
Row Update Frequency |
Number of rows updated into the InnoDB table per second |
≥ 0 rows/s |
Monitored object: database Monitored instance type: RDS for MySQL instance |
rds039_disk_util |
Storage Space Usage |
Storage space usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds047_disk_total_size |
Total Storage Space |
Total storage space of the monitored object |
40–4000, in GB |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds048_disk_used_size |
Used Storage Space |
Used storage space of the monitored object |
0–4000, in GB |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds049_disk_read_throughput |
Disk Read Throughput |
Number of bytes read from the disk per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds050_disk_write_throughput |
Disk Write Throughput |
Number of bytes written into the disk per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds072_conn_usage |
Connection Usage |
Percent of used MySQL connections to the total number of connections |
0–100% |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds074_slow_queries |
Slow Query Logs |
Number of slow query logs generated per minute on RDS for MySQL. This metric counts the number of SQL statements whose execution duration exceeds the threshold specified by long_query_time. |
≥ 0 counts/min |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds075_avg_disk_ms_per_read |
Disk Read Time |
Average time required for each disk read in a specified period |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds076_avg_disk_ms_per_write |
Disk Write Time |
Average time required for each disk write in a specified period |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds077_vma |
VMA |
Virtual memory area size of an RDS process |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds078_threads |
Threads |
Number of threads in a process |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds079_vm_hwm |
Peak Resident Set Size |
Peak physical memory usage of an RDS process |
≥ 0 KB |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds080_vm_peak |
Peak Virtual Memory Size |
Peak virtual memory usage of an RDS process |
≥ 0 KB |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 are I/O activities). 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% |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds082_semi_sync_tx_avg_wait_time |
Transaction Wait Time |
Average wait time of transactions in semi-synchronous mode |
≥ 0 μs |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
sys_swap_usage |
SWAP Usage |
SWAP usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_innodb_lock_waits |
Row Locks Waits Transactions |
Number of InnoDB transactions waiting for row lock |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_bytes_recv_rate |
Received Bytes per Second |
Number of bytes received by the database per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_bytes_sent_rate |
Sent Bytes per Second |
Number of bytes sent from the database per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_innodb_pages_read_rate |
Data Volume Read By InnoDB per Second |
Data volume read by InnoDB per second |
≥ 0 pages/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_innodb_pages_written_rate |
Data Volume Written by InnoDB per Second |
Data volume written by InnoDB per second |
≥ 0 pages/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_innodb_os_log_written_rate |
Redo Log Size Written per Second |
Size of redo logs written per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_created_tmp_tables_rate |
Temporary Tables Created per Second |
Number of temporary tables created per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_wait_thread_count |
Waiting Threads |
Total number of waiting threads in an instance. |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_threadpool_waiting_threads |
Number of Waiting Threads in the Thread Pool |
Number of waiting threads in the thread pool |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_innodb_row_lock_time_avg |
Average Row Lock Wait Time |
Average wait time of historical InnoDB row locks |
> 0 ms |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_mdl_lock_count |
MDL Locks |
Number of MDL locks |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
rds_conn_active_usage |
Active Connection Usage |
Usage of active connections |
0–100% |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 is incremented by 1 each time a wait occurs. |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
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 |
Monitored object: ECS Monitored instance type: RDS for MySQL instance |
Dimension
Key |
Value |
---|---|
rds_cluster_id |
RDS for MySQL instance ID |
API Calling
Use APIs to search for RDS monitoring metrics. For details about calling methods and parameter description, see Querying Monitoring Data in the Cloud Eye API Reference.
Examples:
- Request
/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_util&dim.0=rds_cluster_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_util", "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" } }
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot