Tencent Cloud ClickHouse Monitoring Integration

Utilize Site24x7 Tencent Cloud ClickHouse Monitoring Integration to:

Track query, select, and insert counts to understand analytical workload volumes.
Monitor inserted and selected row counts to measure data ingestion and query throughput.
Detect sudden spikes in query activity that could indicate runaway queries or load increases.
Ensure ClickHouse analytical performance meets SLA requirements for reporting workloads.

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

Setup and configuration

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

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

Data collection frequency

Performance metrics of your Tencent Cloud ClickHouse 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
Insert Count	Number of INSERT operations executed per second	Ops/second
Inserted Rows	Number of rows inserted per second across all tables	Rows/second
Query Count	Total number of queries (all types) executed per second	Queries/second
Select Count	Number of SELECT queries executed per second	Queries/second
Selected Rows	Number of rows returned by SELECT queries per second	Rows/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 ClickHouse. Now you can set the threshold values for all the metrics mentioned above.

Monitor-level configuration

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