To provide you with more comprehensive and convenient instance monitoring services, TencentDB for MySQL now supports advanced metrics for alarms, performance analysis, and failure alarming. If needed, you can go to the integration center to select the metric set.
Note:
- You can use the advanced metric set for free before July 1, 2022, after which you will be charged based on the actual number of data points generated by the advanced metrics at the minimum granularity.
- To enable or disable the advanced metrics, go to the integration center to do so in the TCOP console.
##List of Advanced Metrics for TencentDB for MySQL
Parameter | Metric Name | Description | Unit | Dimension | Statistical Period |
---|---|---|---|---|---|
AbortedClients | Numbers of abnormally closed client connections | Number of suspended connections due to improper client disconnection | Count | InstanceId, InstanceType (optional) | 5s, 60s, 300s, 3,600s, 86,400s |
AbortedConnects | Number of failed connection attempts | Number of failed connections to MySQL server | Times/sec | InstanceId, InstanceType (optional) | 5s, 60s, 300s, 3,600s, 86,400s |
SelectFullJoin | Full-table scans in join queries | If this value is not 0 , check the index of the table carefully. |
Times/sec | InstanceId, InstanceType (optional) | 5s, 60s, 300s, 3,600s, 86,400s |
SelectFullRangeJoin | Range search counts in join queries | Number of multi-table join operations using range search on auxiliary reference tables. This value represents the number of times tables were joined using range search. | Times/sec | InstanceId, InstanceType (optional) | 5s, 60s, 300s, 3600s, 86400s |
TableOpenCacheHits | Table cache hits | Table opened cache hits | Times/sec | InstanceId, InstanceType (optional) | 5s, 60s, 300s, 3,600s, 86,400s |
TableOpenCacheMisses | Table cache misses | Table opened cache misses | Times/sec | InstanceId, InstanceType (optional) | 5s, 60s, 300s, 3,600s, 86,400s |
TableOpenCacheOverflows | Table cache overflows | Table opened cache overflows | Times/sec | InstanceId, InstanceType (optional) | 5s, 60s, 300s, 3,600s, 86,400s |
Was this page helpful?