Configuring Displayed Metrics¶
Function¶
You can use Cloud Eye to monitor the running statuses of DB instances. This section describes namespaces, descriptions, and dimensions of monitoring metrics to be reported to Cloud Eye.
DB Instance Monitoring Metrics¶
Metric ID | Metric | Description | Value Range | Monitored Object | Monitoring Interval (Raw Data) |
|---|---|---|---|---|---|
gaussdb_mysql001_cpu_util | CPU Usage | CPU usage of the monitored object | 0-100% | Monitored object: ECS Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql002_mem_util | Memory Usage | Memory usage of the monitored object | 0-100% | Monitored object: ECS Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql004_bytes_in | Network Input Throughput | Incoming traffic in bytes per second | >=0 bytes/s | Monitored object: ECS Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql005_bytes_out | Network Output Throughput | Outgoing traffic in bytes per second | >= 0 bytes/s | Monitored object: ECS Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql006_conn_count | Total Connections | Total number of connections that attempt to connect to the GaussDB(for MySQL) server | >= 0 counts | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql007_conn_active_count | Current Active Connections | Number of current active connections | >= 0 counts | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql008_qps | QPS | Query times of SQL statements (including storage procedures) per second | >=0 times/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql009_tps | TPS | Execution times of submitted and rollback transactions per second | >=0 times/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql010_innodb_buf_usage | Buffer Pool Usage | Ratio of dirty data to all data in the InnoDB buffer | 0-100% | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql011_innodb_buf_hit | Buffer Pool Hit Ratio | Ratio of read hits to read requests in the InnoDB buffer | 0-100% | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql012_innodb_buf_dirty | Buffer Pool Dirty Block Ratio | Ratio of used pages to total pages in the InnoDB buffer | 0-100% | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql013_innodb_reads | InnoDB Read Throughput | Number of read bytes per second in the InnoDB buffer | >=0 bytes/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 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 | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql017_innodb_log_write_req_count | InnoDB Log Write Requests per Second | Number of InnoDB log write requests per second | >= 0 times/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 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 | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql028_comdml_del_count | DELETE Statements per Second | Number of DELETE statements executed per second | >=0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql029_comdml_ins_count | INSERT Statements per Second | Number of INSERT statements executed per second | >=0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql030_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: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql031_comdml_rep_count | REPLACE Statements per Second | Number of REPLACE statements executed per second | >=0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql032_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: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql033_comdml_sel_count | SELECT Statements per Second | Number of SELECT statements executed per second | >=0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql034_comdml_upd_count | UPDATE Statements per Second | Number of UPDATE statements executed per second | >=0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql035_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: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql036_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: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql037_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: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql038_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: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql048_disk_used_size | Used Storage Space | Used storage space of the monitored object | 0-4000 GB | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql072_conn_usage | Connection Usage | Percentage of used GaussDB(for MySQL) connections to the total number of connections | 0-100% | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql074_slow_queries | Slow Query Logs | Number of GaussDB(for MySQL) slow query logs generated per minute | >= 0 counts/min | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql077_replication_delay | Replication Delay | Delay between the primary node and read replicas | >= 0s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 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 | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 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 | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql106_innodb_row_lock_current_waits | InnoDB Row Locks | Number of row locks being waited by operations on the InnoDB table | >= 0 counts | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 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 | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql108_com_commit_count | COMMIT Statements per Second | Number of COMMIT statements executed per second | >= 0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql109_com_rollback_count | ROLLBACK Statements per Second | Number of ROLLBACK statements executed per second | >= 0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 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 | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql111_innodb_bufpool_read_requests | InnoDB Read Requests per Second | Number of InnoDB read requests per second | >= 0 counts/s | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql112_ data_disk_used_size | Used Data Disk Size | Used local data disk size. | 0-20 GB | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |
gaussdb_mysql113_ data_disk_used_ratio | Data Disk Usage | Local data disk usage | 0-100% | Monitored object: database Monitored instance type: GaussDB(for MySQL) instance | 1 minute |