Tencent Cloud MySQL Monitoring Integration

Utilize Site24x7 Tencent Cloud MySQL Monitoring Integration to:

Track query throughput (QPS/TPS) and catch performance regressions early.
Monitor disk and data usage to anticipate storage capacity limits.
Identify slow or inefficient queries by observing InnoDB cache hit rate and IOPS trends.
Monitor replication delay to ensure read replicas stay in sync with the primary instance.

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

Setup and configuration

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

If you haven't selected 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 MySQL from the Services/Resources drop-down and click Save.
After successful configuration, go to Cloud > Tencent Cloud > MySQL. Now you can view the discovered resources.

Data collection frequency

Performance metrics of your Tencent Cloud 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
Disk Usage	Total disk space consumed by the MySQL instance including data, logs, and temporary files	MB
Data Usage	Disk space used exclusively by the database data files	MB
Inbound Traffic	Volume of data received by the MySQL instance from clients	Bytes/second
Outbound Traffic	Volume of data sent from the MySQL instance to clients	Bytes/second
IO Operations Per Second	Number of read and write I/O operations completed per second	Ops/second
Queries Per Second	Total number of SQL queries executed per second	Queries/second
Transactions Per Second	Number of database transactions committed or rolled back per second	Transactions/second
Current Connections	Number of active client connections to the MySQL instance at the time of measurement	Count
Delete Operations	Number of DELETE statement executions per second	Ops/second
Insert Operations	Number of INSERT statement executions per second	Ops/second
Update Operations	Number of UPDATE statement executions per second	Ops/second
Select Operations	Number of SELECT statement executions per second	Ops/second
InnoDB Cache Hit Rate	Percentage of read requests served from the InnoDB buffer pool without disk access	%
Replication Delay	Time difference in seconds between the replica and the primary databases for replication lag monitoring	Seconds

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 MySQL. Now you can set the threshold values for all the metrics mentioned above.

Monitor-level configuration

Go to Cloud > Tencent Cloud > 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 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