Huawei Cloud GaussDB for MySQL¶
GaussDB for MySQL, including metrics related to CPU, memory, network, buffer pool, storage, slow logs, InnoDB, etc.
Configuration¶
Install Func¶
It is recommended to activate TrueWatch Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed, please proceed with the script installation.
If you want to deploy Func yourself, refer to Self-deploy Func
Install Script¶
Note: Please prepare the Huawei Cloud AK that meets the requirements in advance (for simplicity, you can directly grant the global read-only permission
ReadOnlyAccess)
-
Log in to the Func console, click 【Script Market】, enter the TrueWatch Script Market, and search for
ID: integration_huaweicloud_ddm_gaussdb_mysql -
Click 【Install】, then enter the corresponding parameters: Huawei Cloud AK, SK, and account name
-
Click 【Deploy Startup Script】, the system will automatically create the
Startupscript set and configure the corresponding startup script -
After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】 to execute it immediately without waiting for the scheduled time. After a while, you can check the execution task records and corresponding logs
Verification¶
- In 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has the corresponding automatic trigger configuration, and you can also check the corresponding task records and logs to see if there are any exceptions
- In TrueWatch, check if there is asset information in 「Infrastructure / Custom」
- In TrueWatch, check if there is corresponding monitoring data in 「Metrics」
Metrics¶
After configuring GaussDB for MySQL, the default measurement sets are as follows. You can collect more metrics through configuration Huawei Cloud Cloud Monitoring Metrics Details
| Metric ID | Metric Name | Metric Description | Value Range | Measurement Object (Dimension) | Monitoring Cycle (Original Metric) |
|---|---|---|---|---|---|
gaussdb_mysql001_cpu_util |
CPU Utilization | This metric is used to count the CPU utilization of the measurement object. | 0～100% | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql002_mem_util |
Memory Utilization | This metric is used to count the memory utilization of the measurement object. | 0~100% | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql004_bytes_in |
Network Input Throughput | This metric is used to count the average traffic input from all network adapters of the measurement object per second. | ≥0 bytes/s | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql005_bytes_out |
Network Output Throughput | This metric is used to count the average traffic output from all network adapters of the measurement object per second. | ≥0 bytes/s | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql006_conn_count |
Total Database Connections | This metric is used to count the total number of connections to the GaussDB(for MySQL) server. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql007_conn_active_count |
Current Active Connections | This metric is used to count the current number of active connections. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql010_innodb_buf_usage |
Buffer Pool Utilization | This metric is used to count the ratio of used pages to the total number of data pages in the InnoDB buffer. | 0-1 | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql011_innodb_buf_hit |
Buffer Pool Hit Rate | This metric is used to count the ratio of read hits to read requests during this period. | 0-1 | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql012_innodb_buf_dirty |
Buffer Pool Dirty Block Rate | This metric is used to count the ratio of dirty data to total data in the InnoDB buffer. | 0～100% | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql013_innodb_reads |
InnoDB Read Throughput | This metric is used to count the average number of bytes read by Innodb per second. | ≥0 bytes/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql014_innodb_writes |
InnoDB Write Throughput | This metric is used to count the average number of bytes written by Innodb per second. GaussDB(for MySQL) only writes temporary table pages. | ≥0 bytes/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql017_innodb_log_write_req_count |
InnoDB Log Write Request Frequency | This metric is used to count the average number of log write requests per second. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql020_temp_tbl_count |
Temporary Table Count | This metric is used to count the number of temporary tables automatically created on the hard disk when GaussDB(for MySQL) executes statements. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql028_comdml_del_count |
Delete Statement Execution Frequency | This metric is used to count the average number of Delete statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql029_comdml_ins_count |
Insert Statement Execution Frequency | This metric is used to count the average number of Insert statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql030_comdml_ins_sel_count |
Insert_Select Statement Execution Frequency | This metric is used to count the average number of Insert_Select statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql031_comdml_rep_count |
Replace Statement Execution Frequency | This metric is used to count the average number of Replace statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql032_comdml_rep_sel_count |
Replace_Selection Statement Execution Frequency | This metric is used to count the average number of Replace_Selection statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql033_comdml_sel_count |
Select Statement Execution Frequency | This metric is used to count the average number of Select statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql034_comdml_upd_count |
Update Statement Execution Frequency | This metric is used to count the average number of Update statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute5 seconds1 second |
gaussdb_mysql035_innodb_del_row_count |
Row Deletion Rate | This metric is used to count the average number of rows deleted from InnoDB tables per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql036_innodb_ins_row_count |
Row Insertion Rate | This metric is used to count the average number of rows inserted into InnoDB tables per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql037_innodb_read_row_count |
Row Read Rate | This metric is used to count the average number of rows read from InnoDB tables per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql038_innodb_upd_row_count |
Row Update Rate | This metric is used to count the average number of rows updated in InnoDB tables per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql048_disk_used_size |
Disk Usage | This metric is used to count the disk usage size of the measurement object. | 0GB～128TB | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql072_conn_usage |
Connection Utilization | This metric is used to count the percentage of currently used GaussDB(for MySQL) connections to the maximum number of connections. | 0~100% | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql074_slow_queries |
Slow Log Count Statistics | This metric shows the number of slow logs generated by GaussDB(for MySQL) per minute. | ≥0 counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql104_dfv_write_delay |
Storage Write Latency | This metric is used to count the average latency of writing data to the storage layer during a certain period. | ≥0 ms | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql105_dfv_read_delay |
Storage Read Latency | This metric is used to count the average latency of reading data from the storage layer during a certain period. | ≥0 ms | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql106_innodb_row_lock_current_waits |
InnoDB Row Lock Count | This metric is used to collect the number of row locks currently waiting on InnoDB tables. Note: If there are DDL statements, long transactions, or slow SQL that cause blocking, the number of waiting row locks may increase. |
≥0 Locks/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql107_comdml_ins_and_ins_sel_count |
Insert and Insert_Select Statement Execution Frequency | This metric is used to count the average number of Insert and Insert_Select statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql108_com_commit_count |
Commit Statement Execution Frequency | This metric is used to count the average number of Commit statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql109_com_rollback_count |
Rollback Statement Execution Frequency | This metric is used to count the average number of Rollback statements executed per second. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql110_innodb_bufpool_reads |
InnoDB Storage Layer Read Request Frequency | This metric is used to count the average number of requests per second for InnoDB to read data from the storage layer. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql111_innodb_bufpool_read_requests |
InnoDB Read Request Frequency | This metric is used to count the average number of requests per second for InnoDB to read data. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql119_disk_used_ratio |
Disk Utilization | This metric is used to count the disk utilization rate. | 0~100% | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql116_innodb_bufpool_read_ahead_rnd |
Innodb Random Pre-read Page Count | This metric is used to collect the number of random pre-read pages on InnoDB tables. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql117_innodb_pages_read |
Innodb Physical Page Read Count | This metric is used to collect the number of physical pages read on InnoDB tables. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql118_innodb_pages_written |
Innodb Physical Page Write Count | This metric is used to collect the number of physical pages written on InnoDB tables. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql342_iostat_iops_write |
IO Write IOPS | This metric is used to collect the number of write operations per second on the disk. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql344_iostat_iops_read |
IO Read IOPS | This metric is used to collect the number of read operations per second on the disk. | ≥0 counts/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql346_iostat_throughput_write |
IO Write Bandwidth | This metric is used to collect the write bandwidth per second on the disk. | ≥0 bytes/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql348_iostat_throughput_read |
IO Read Bandwidth | This metric is used to collect the read bandwidth per second on the disk. | ≥0 bytes/s | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql123_sort_range |
Range Sort Count | This metric is used to count the number of sorts completed using range scans during this period. | ≥0 counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql121_innodb_row_lock_time |
Row Lock Time Spent | This metric is used to count the time spent on row locks in InnoDB tables during this period. | ≥0 ms | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql122_innodb_row_lock_waits |
Row Lock Wait Count | This metric is used to count the number of row locks in InnoDB tables during this period. | ≥0 counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql126_table_open_cache_hits |
Table Open Cache Hit Count | This metric is used to count the number of hits in the table open cache lookup during this period. | ≥0 counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql124_sort_rows |
Row Sort Count | This metric is used to count the number of rows sorted during this period. | ≥0 counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql125_sort_scan |
Table Scan Sort Count | This metric is used to count the number of sorts completed by scanning tables during this period. | ≥0 counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql060_rx_errors |
Receive Packet Error Rate | This metric is used to count the ratio of error packets to all received packets during the monitoring period. | 0~100% | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql127_table_open_cache_misses |
Table Open Cache Miss Count | This metric is used to count the number of misses in the table open cache lookup during this period. | ≥0 counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql128_long_trx_count |
Long Unclosed Transaction Count | This metric is used to count the number of long unclosed transactions. | ≥0 counts | GaussDB(for MySQL) Instance | 150 seconds |
gaussdb_mysql063_tx_dropped |
Send Packet Drop Rate | This metric is used to count the ratio of lost packets to all sent packets during the monitoring period. | 0~100% | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql061_rx_dropped |
Receive Packet Drop Rate | This metric is used to count the ratio of lost packets to all received packets during the monitoring period. | 0~100% | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql062_tx_errors |
Send Packet Error Rate | This metric is used to count the ratio of error packets to all sent packets during the monitoring period. | 0~100% | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql114_innodb_bufpool_read_ahead |
Innodb Sequential Pre-read Page Count | This metric is used to collect the number of sequential pre-read pages on InnoDB tables. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql378_create_temp_tbl_per_min |
Temporary Table Creation Count Per Minute | This metric is used to count the number of temporary tables automatically created on the hard disk per minute when GaussDB(for MySQL) executes statements. | ≥0counts/min | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql371_taurus_binlog_total_file_counts |
Binlog File Count | This metric is used to count the number of Binlog files in GaussDB(for MySQL). | ≥0 | GaussDB(for MySQL) Instance | 5 minutes |
gaussdb_mysql115_innodb_bufpool_read_ahead_evicted |
Innodb Sequential Pre-read, but Unaccessed Page Count | This metric is used to collect the number of sequential pre-read pages on InnoDB tables that have not been accessed. | ≥0 counts | GaussDB(for MySQL) Instance | 1 minute |
gaussdb_mysql120_innodb_buffer_pool_bytes_data |
Buffer Pool Data Total Bytes | This metric is used to count the total number of bytes of data contained in the InnoDB buffer pool. | ≥0 bytes | GaussDB(for MySQL) Instance | 1 minute |
Objects¶
The collected HUAWEI SYS.CBR object data structure can be seen in 「Infrastructure-Custom」
{
"measurement": "huaweicloud_gaussdb_mysql",
"tags": {
"RegionId" : "cn-north-4",
"db_user_name" : "root",
"name" : "2e10f990e139xxxxxx5fac6b59de7eein07",
"port" : "3306",
"project_id" : "c631f046252d4xxxxxxx5f253c62d48585",
"status" : "BUILD",
"type" : "Cluster",
"vpc_id" : "f6bc2c55-2a95-xxxx-xxxx-7b09e9a8de13",
"instance_id" : "2e10f990e139xxxxxx5fac6b59de7eein07",
"instance_name" : "nosql-efa7"
},
"fields": {
"charge_info" : "{Billing type information, supports yearly/monthly and pay-as-you-go, default is pay-as-you-go}",
"create_time" : "2023-08-01T14:17:40+0800",
"update_time" : "2023-08-01T14:17:42+0800",
"private_ips" : "[\"192.168.0.223\"]",
"proxy_ips" : "[]",
"readonly_private_ips" : "[Instance read internal IP address list]",
"message" : "{Instance JSON data}"
}
}
Note: The fields in
tags,fieldsmay change with subsequent updatesTip 1: The value of
tags.nameis the instance ID, used as a unique identifierTip 2:
fields.message,fields.charge_info,fields.private_ips,fields.proxy_ips,fields.readonly_private_ipsare all JSON serialized strings
```