Tencent Cloud TDSQL-C MySQL Monitoring Integration

Utilize Site24x7 Tencent Cloud TDSQL-C MySQL Monitoring Integration to:

Track DML query volumes (SELECT, INSERT, UPDATE, DELETE) to understand workload patterns.
Monitor transaction throughput and detect slow queries that impact response times.
Observe network bytes sent and received to identify traffic anomalies.
Track storage usage growth to plan capacity for this cloud-native MySQL-compatible database.

This help document contains instructions to set up Tencent Cloud TDSQL-C MySQL Monitoring Integration and related information.

Setup and configuration

During your Tencent Cloud monitor setup, if you have selected TDSQL-C MySQL in the Services/Resources drop-down, all your TDSQL-C MySQL resources will be auto-detected and monitored without the need to manually create a monitor for each resource.

If you haven't selected TDSQL-C MySQL during Tencent Cloud monitor creation, follow these instructions:

Log in to your Site24x7 account.
Go to Cloud > Tencent Cloud, select your Tencent Cloud monitor, then go to any of the dashboards on the left pane.
Click the hamburger icon and select Edit, which brings you to the Edit Tencent Cloud Monitor page.
On the Edit Tencent Cloud Monitor page, select TDSQL-C MySQL from the Services/Resources drop-down and click Save.
After successful configuration, go to Cloud > Tencent Cloud > TDSQL-C MySQL. Now you can view the discovered resources.

Data collection frequency

Performance metrics of your Tencent Cloud TDSQL-C MySQL resources will be collected every five minutes and updated in the Site24x7 portal every five minutes by default; metrics are also collected based on the selected poll interval.

Supported metrics

Metric name	Description	Unit
Bytes Received	Volume of data received by the database instance from clients per second	Bytes/second
Bytes Sent	Volume of data sent from the database instance to clients per second	Bytes/second
DELETE Queries	Number of DELETE statement executions per second	Queries/second
INSERT Queries	Number of INSERT statement executions per second	Queries/second
SELECT Queries	Number of SELECT statement executions per second	Queries/second
UPDATE Queries	Number of UPDATE statement executions per second	Queries/second
Slow Queries	Number of queries exceeding the slow query threshold per second	Queries/second
Storage Usage	Total disk space consumed by the TDSQL-C MySQL cluster	GB
Transactions Per Second	Number of transactions committed or rolled back per second	Transactions/second

Threshold configuration

Global configuration

Go to the Admin section in the left navigation pane.
Select Configuration Profiles from the left pane and choose the Threshold and Availability (+) tab from the drop-down menu. Click Add Threshold Profile from the top-right corner.
Set the monitor type as Tencent Cloud TDSQL-C MySQL. Now you can set the threshold values for all the metrics mentioned above.

Monitor-level configuration

Go to Cloud > Tencent Cloud > TDSQL-C MySQL.
Choose a resource for which you would like to set a threshold, then click the hamburger icon . Select Edit, which directs you to the Edit Tencent Cloud TDSQL-C MySQL Monitor page.
You can set the threshold values for the metrics by selecting Threshold and Availability. You can also configure IT Automation at the attribute level.

IT Automation

Site24x7's IT Automation tools help with automatically resolving performance degradation issues. When a breach occurs, the alarm engine continuously examines the system events for which thresholds have been defined and performs the mapped automation.

How to configure IT Automation for a monitor

Configuration Rules

With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors and automate the configuration settings of your monitoring resources.

How to add a Configuration Rule