TDSQL for MySQL upgraded the monitoring items for server and component services on April 1, 2021 by replacing the legacy alarm policy type and modifying hundreds of monitoring and alarm metrics. You can configure alarm policies of the TDSQL for MySQL type in the Cloud Monitor console.
The legacy TDSQL policy type was deactivated on July 29, 2021. You cannot configure new alarm policies in this type any more, and your previously configured TDSQL alarm polices will be gradually transferred to the new policy type.
Comparison of the legacy and new alarm policy types:
Policy Type | Metric Coverage | Support and Maintenance |
---|---|---|
Tencent Distributed SQL | 8 metrics | This policy type was deactivated on July 29, 2021 and cannot be configured subsequently. All legacy alarm policies will be transferred to the new policy type. |
Cloud Database - TDSQL MySQL - Instance | 37 metrics | This policy type was released on April 1, 2021 with ongoing maintenance available. |
Note:
- The new TDSQL for MySQL policy type has covered all metrics of the legacy TDSQL policy type. For more information, please see Comparison Table of New and Legacy Metrics.
- For the new alarm policies, please see New Metric Description.
After the legacy TDSQL policy type is deactivated, the system will automatically transfer previously configured alarm policies to the new TDSQL for MySQL policy type on the backend.
Note:Alarms may not be automatically transferred to the new alarm policy type by the system for certain instances or users. If this is the case for you, we will notify you through Message Center, email, or SMS. Then, please follow the manual transfer steps below to manually transfer the alarms.
Legacy Policy Type | Metric/Event Alarm | Legacy Metric/Event Alarm Name | New Policy Type | New Metric/Event Alarm Name |
---|---|---|---|---|
Tencent Distributed SQL | Metric alarm | CPU utilization | Cloud Database - TDSQL MySQL - Instance | Maximum CPU utilization of source node |
Metric alarm | Storage space utilization | Cloud Database - TDSQL MySQL - Instance | Maximum data disk utilization of source node | |
Metric alarm | Slow queries | Cloud Database - TDSQL MySQL - Instance | Total slow queries of source nodes | |
Metric alarm | Active connections | Cloud Database - TDSQL MySQL - Instance | Total active threads | |
Metric alarm | Cache hit rate | Cloud Database - TDSQL MySQL - Instance | Minimum cache hit rate of source node | |
Metric alarm | Database connections | Cloud Database - TDSQL MySQL - Instance | Total client connections | |
Metric alarm | Replica lag | Cloud Database - TDSQL MySQL - Instance | Secondary node delay | |
Metric alarm | Primary-Secondary switch | Cloud Database - TDSQL MySQL - Instance | Primary-Secondary switches |
Policy Type | Metric/Event Alarm | Metric/Event Alarm Name |
---|---|---|
Cloud Database - TDSQL MySQL | Metric alarm | CPU utilization |
Metric alarm | Total UPDATE requests of source nodes | |
Metric alarm | Total open connections | |
Metric alarm | Total maximum connections | |
Metric alarm | SQL Throughput | |
Metric alarm | SQL Error Throughput | |
Metric alarm | SQL Success Throughput | |
Metric alarm | Requests consuming less than 5 ms | |
Metric alarm | Requests consuming 5–20 ms | |
Metric alarm | Requests consuming 21–30 ms | |
Metric alarm | Requests consuming more than 30 ms | |
Metric alarm | Minimum remaining binlog disk space in all shards | |
Metric alarm | Total binlog disk space of source nodes | |
Metric alarm | Maximum database connection utilization | |
Metric alarm | Total available data disk space of source nodes | |
Metric alarm | Total DELETE requests of source nodes | |
Metric alarm | Maximum IO utilization of source node | |
Metric alarm | Total logical reads from InnoDB disk | |
Metric alarm | Total pages read into InnoDB buffer pool by read-ahead thread | |
Metric alarm | Total logical reads from InnoDB buffer pool | |
Metric alarm | Total rows deleted from InnoDB tables on source nodes | |
Metric alarm | Total rows inserted to InnoDB tables on source nodes | |
Metric alarm | Total rows read from InnoDB tables | |
Metric alarm | Total rows updated in InnoDB tables on source nodes | |
Metric alarm | Total INSERT requests of source nodes | |
Metric alarm | Total available cache of source nodes | |
Metric alarm | Total REPLACE_SELECT requests of source nodes | |
Metric alarm | Total REPLACE requests of source nodes | |
Metric alarm | Total requests of source and replica nodes | |
Metric alarm | Total SELECT requests |
Was this page helpful?