Introducing GaussDB(for MySQL) Metrics
Function
You can monitor the status of your instances using Cloud Eye. The namespaces, descriptions, and dimensions of monitoring metrics of instances can be reported to Cloud Eye.
The monitoring interval can be 1 minute, 1 second, or 5 seconds. The default monitoring interval is 1 minute. To enable Monitoring by Seconds, contact customer service to apply for the required permissions.
Namespace
SYS.GAUSSDB
Monitoring Metrics Supported by Instances
Metric ID |
Metric |
Metric Description |
Value Range |
Monitored Object |
Monitoring Interval (Raw Data) |
---|---|---|---|---|---|
gaussdb_mysql001_cpu_util |
CPU Usage |
CPU usage of the monitored object |
0–100% |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql002_mem_util |
Memory Usage |
Memory usage of the monitored object |
0–100% |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql004_bytes_in |
Network Input Throughput |
Incoming traffic in bytes per second |
≥0 bytes/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql005_bytes_out |
Network Output Throughput |
Outgoing traffic in bytes per second |
≥0 bytes/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql006_conn_count |
Total Connections |
Total number of connections that attempt to connect to the GaussDB(for MySQL) server |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql007_conn_active_count |
Current Active Connections |
Number of active connections |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql008_qps |
QPS |
Query times of SQL statements (including DDL, DML, SHOW, SET statements and storage procedures) per second |
≥0 times/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql009_tps |
TPS |
Execution times of submitted and rollback transactions per second |
≥0 times/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql010_innodb_buf_usage |
Buffer Pool Usage |
Ratio of used pages to total pages in the InnoDB buffer |
0-1 |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql011_innodb_buf_hit |
Buffer Pool Hit Ratio |
Ratio of read hits to read requests in the InnoDB buffer |
0-1 |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql012_innodb_buf_dirty |
Buffer Pool Dirty Block Ratio |
Ratio of dirty data to all data in the InnoDB buffer |
0–100% |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql013_innodb_reads |
InnoDB Read Throughput |
Number of read bytes per second in the InnoDB buffer |
≥0 bytes/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql014_innodb_writes |
InnoDB Write Throughput |
Bytes written to pages by InnoDB per second. GaussDB(for MySQL) writes data only to temporary tables |
≥0 bytes/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql017_innodb_log_write_req_count |
InnoDB Log Write Request Frequency |
Number of InnoDB log write requests per second |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql019_innodb_log_writes |
InnoDB Log Writes |
Number of physical writes to the InnoDB redo log file |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql020_temp_tbl_count |
Temporary Tables |
Number of temporary tables automatically created on disks when GaussDB(for MySQL) statements are executed |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql028_comdml_del_count |
DELETE Statements per Second |
Number of DELETE statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql029_comdml_ins_count |
INSERT Statements per Second |
Number of INSERT statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql030_comdml_ins_sel_count |
INSERT_SELECT Statements per Second |
Number of INSERT_SELECT statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql031_comdml_rep_count |
REPLACE Statements per Second |
Number of REPLACE statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql032_comdml_rep_sel_count |
REPLACE_SELECTION Statements per Second |
Number of REPLACE_SELECTION statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql033_comdml_sel_count |
SELECT Statements per Second |
Number of SELECT statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql034_comdml_upd_count |
UPDATE Statements per Second |
Number of UPDATE statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute 5 seconds 1 second |
gaussdb_mysql035_innodb_del_row_count |
Row Delete Frequency |
Number of rows deleted from the InnoDB table per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql036_innodb_ins_row_count |
Row Insert Frequency |
Number of rows inserted into the InnoDB table per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql037_innodb_read_row_count |
Row Read Frequency |
Number of rows read from the InnoDB table per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql038_innodb_upd_row_count |
Row Update Frequency |
Number of rows updated into the InnoDB table per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql048_disk_used_size |
Used Storage Space |
Used storage space of the monitored object |
0 GB-128 TB |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql060_rx_errors |
Error Rate of Received Packets |
Ratio of the number of error packets to the total number of received packets during the monitoring period |
0–100% |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql061_rx_dropped |
Loss Rate of Received Packets |
Ratio of the number of lost packets to the total number of received packets during the monitoring period |
0–100% |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql062_tx_errors |
Error Rate of Sent Packets |
Ratio of the number of error packets to the total number of sent packets during the monitoring period |
0–100% |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql063_tx_dropped |
Loss Rate of Sent Packets |
Ratio of the number of lost packets to the total number of sent packets during the monitoring period |
0–100% |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql072_conn_usage |
Connection Usage |
Percent of used GaussDB(for MySQL) connections to the total number of connections |
0–100% |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql074_slow_queries |
Slow Query Logs |
Number of GaussDB(for MySQL) slow query logs generated per minute |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql077_replication_delay |
Replication Delay |
Delay between the primary node and read replicas
NOTE:
This metric is used only for read replicas. |
≥ 0s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql104_dfv_write_delay |
Storage Write Delay |
Average delay of writing data to the storage layer in a specified period |
≥0 ms |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql105_dfv_read_delay |
Storage Read Delay |
Average delay of reading data from the storage layer in a specified period |
≥0 ms |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql106_innodb_row_lock_current_waits |
InnoDB Row Locks |
Number of row locks being waited by operations on the InnoDB table
NOTE:
If there are DDL statements, long transactions, or slow SQL statements, the number of row locks being waited may increase. |
≥0 locks/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql107_comdml_ins_and_ins_sel_count |
INSERT and INSERT_SELECT Statements per Second |
Number of INSERT and INSERT_SELECT statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql108_com_commit_count |
COMMIT Statements per Second |
Number of COMMIT statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql109_com_rollback_count |
ROLLBACK Statements per Second |
Number of ROLLBACK statements executed per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql110_innodb_bufpool_reads |
InnoDB Storage Layer Read Requests per Second |
Number of times that InnoDB reads data from the storage layer per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql111_innodb_bufpool_read_requests |
InnoDB Read Requests per Second |
Number of InnoDB read requests per second |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql114_innodb_bufpool_read_ahead |
InnoDB Bufpool Read Ahead |
Number of pages read into the InnoDB buffer pool by the read-ahead background thread |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql115_innodb_bufpool_read_ahead_evicted |
InnoDB Bufpool Read Ahead Evicted |
Number of pages read into the InnoDB buffer pool by the read-ahead background thread that were subsequently evicted without having been accessed by queries |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql116_innodb_bufpool_read_ahead_rnd |
InnoDB Bufpool Read Ahead Rnd |
Number of random read-aheads initiated by InnoDB |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql117_innodb_pages_read |
InnoDB Pages Read |
Number of pages read from the InnoDB buffer pool by operations on InnoDB tables |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql118_innodb_pages_written |
InnoDB Pages Written |
Number of pages written by operations on InnoDB tables |
≥0 counts |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql119_disk_used_ratio |
Disk Usage |
Disk usage of the monitored object |
0–100% |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql120_innodb_buffer_pool_bytes_data |
Total Bytes of Buffer Pool |
Total number of bytes in the InnoDB buffer pool containing data |
≥0 bytes |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql121_innodb_row_lock_time |
Row Lock Time |
Total time spent in acquiring row locks for InnoDB tables |
≥0 ms |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql122_innodb_row_lock_waits |
Row Lock Waits |
Number of times operations on InnoDB tables had to wait for a row lock |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql123_sort_range |
Sorts Using Ranges |
Number of sorts that were done using ranges |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql124_sort_rows |
Sorted Rows |
Number of sorted rows |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql125_sort_scan |
Sorts by Scanning Tables |
Number of sorts that were done by scanning tables. |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql126_table_open_cache_hits |
Hits for Open Tables Cache Lookups |
Number of hits for open tables cache lookups |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql127_table_open_cache_misses |
Misses for Open Tables Cache Lookups |
Number of misses for open tables cache lookups |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql128_long_trx_count |
Long-Running Transactions |
Number of long transactions that are not closed |
≥0 counts |
GaussDB(for MySQL) instances |
150s |
gaussdb_mysql342_iostat_iops_write |
I/O Write IOPS |
I/O write IOPS |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql344_iostat_iops_read |
I/O Read IOPS |
I/O read IOPS |
≥0 counts/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql346_iostat_throughput_write |
I/O Write Bandwidth |
Disk write bandwidth per second |
≥0 bytes/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql348_iostat_throughput_read |
I/O Read Bandwidth |
Disk read bandwidth per second |
≥0 bytes/s |
GaussDB(for MySQL) instances |
1 minute |
gaussdb_mysql371_taurus_binlog_total_file_counts |
Binlog Files |
Number of GaussDB(for MySQL) binlog files |
≥0 |
GaussDB(for MySQL) instances |
5 minutes |
gaussdb_mysql378_create_temp_tbl_per_min |
Temporary Tables Created per Minute |
Number of temporary tables automatically created on disks per minute when GaussDB(for MySQL) statements are executed |
≥0 counts/min |
GaussDB(for MySQL) instances |
1 minute |
gaussdb386_undo_spaces_trx_count |
Existing Transactions in Undo Space |
Number of transactions that are not cleared in the undo space. |
≥0 |
GaussDB(for MySQL) instances |
30s |
Monitoring Metrics Supported By Proxy
Metric ID |
Metric |
Metric Description |
Value Range |
Monitored Object |
Monitoring Interval (Raw Data) |
---|---|---|---|---|---|
rds_proxy_frontend_connections |
Frontend Connections |
Number of connections between applications and the proxy |
≥ 0 counts |
GaussDB(for MySQL) proxy instances |
1 minute |
rds_proxy_backend_connections |
Backend Connections |
Number of connections between the proxy and GaussDB(for MySQL) databases |
≥ 0 counts |
GaussDB(for MySQL) proxy instances |
1 minute |
rds_proxy_average_response_time |
Average Response Time |
Average response time |
≥0 ms |
GaussDB(for MySQL) proxy instances |
1 minute |
rds_proxy_query_per_seconds |
QPS |
Query times of SQL statements |
≥ 0 counts |
GaussDB(for MySQL) proxy instances |
1 minute |
rds_proxy_read_query_proportions |
Read Proportion |
Proportion of read requests to total requests |
0–100% |
GaussDB(for MySQL) proxy instances |
1 minute |
rds_proxy_write_query_proportions |
Write Proportion |
Proportion of write requests to total requests |
0–100% |
GaussDB(for MySQL) proxy instances |
1 minute |
rds001_cpu_util |
CPU Usage |
CPU usage of the monitored object |
0–100% |
GaussDB(for MySQL) proxy instances |
1 minute |
rds002_mem_util |
Memory Usage |
Memory usage of the monitored object |
0–100% |
GaussDB(for MySQL) proxy instances |
1 minute |
rds004_bytes_in |
Network Input Throughput |
Incoming traffic in bytes per second |
≥0 bytes/s |
GaussDB(for MySQL) proxy instances |
1 minute |
rds005_bytes_out |
Network Output Throughput |
Outgoing traffic in bytes per second |
≥0 bytes/s |
GaussDB(for MySQL) proxy instances |
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 |
GaussDB(for MySQL) proxy instances |
1 minute |
rds_proxy_multi_statement_query |
Multi-Statement Queries per Second |
Number of multi-statements executed in transactions per second |
≥ 0 counts |
GaussDB(for MySQL) proxy instances |
1 minute |
rds_proxy_transaction_query |
Transaction Queries per Second |
Number of SELECT statements executed in transactions per second |
≥ 0 counts |
GaussDB(for MySQL) proxy instances |
1 minute |
Dimension
Key |
Value |
---|---|
gaussdb_mysql_instance_id |
GaussDB(for MySQL) instance ID. |
gaussdb_mysql_node_id |
GaussDB(for MySQL) node ID. |
dbproxy_instance_id |
GaussDB(for MySQL) proxy instance ID |
dbproxy_node_id |
GaussDB(for MySQL) proxy node ID |
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