Available versions




Clickhouse

Overview

Template to monitor main Clickhouse parameters without using additional scripts

It uses HTTP interface to read metrics from system database using Zabbix Agent’s HTTP client

Gathered metrics:

<p style=”box-sizing: border-box; margin-top: 0px; margin-bottom: 16px; color: #24292e; font-family: -apple-system, system-ui, ‘Segoe UI’, Helvetica, Arial, sans-serif, ‘Apple Color Emoji’,

Author

Igor Novgorodov

Macros used

Name Description Default Type
{$CH_MAX_INACTIVE_PARTS} <p>-</p> 2000 Text macro
{$CH_MAX_PARTS} <p>-</p> 50 Text macro
{$CH_MAX_REPLICA_QUEUE} <p>-</p> 5 Text macro
{$CH_URL} <p>-</p> http://127.0.0.1:8123 Text macro

There are no template links in this template.

Discovery rules

There are no discovery rules in this template.

Items collected

Name Description Type Key and additional info
Clickhouse Metrics - LeaderReplica <p>-</p> Dependent item metrics.LeaderReplica<p>Update: 0</p>
Clickhouse Metrics - Query <p>-</p> Dependent item metrics.Query<p>Update: 0</p>
Clickhouse Ping <p>-</p> Zabbix agent web.page.regexp[{$CH_URL}/ping,,,HTTP/1.1 (\d+),,\1]<p>Update: 1m</p>
Clickhouse Events - SelectQuery <p>-</p> Dependent item events.SelectQuery<p>Update: 0</p>
Clickhouse AsyncMetrics <p>SELECT metric, value FROM system.asynchronous_metrics FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20metric%2C%20value%20FROM%20system.asynchronous_metrics%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Events <p>SELECT event, value FROM system.events FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20event%2C%20value%20FROM%20system.events%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Events - InsertedRows <p>-</p> Dependent item events.InsertedRows<p>Update: 0</p>
Clickhouse Events - Query <p>-</p> Dependent item events.Query<p>Update: 0</p>
Clickhouse Inactive Parts <p>Number of inactive parts SELECT COUNT(*) AS c FROM system.parts WHERE active = 0 FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20COUNT%28%2A%29%20AS%20c%20FROM%20system.parts%20WHERE%20active%20%3D%200%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Metrics - Merge <p>-</p> Dependent item metrics.Merge<p>Update: 0</p>
Clickhouse Events - InsertedBytes <p>-</p> Dependent item events.InsertedBytes<p>Update: 0</p>
Clickhouse AsyncMetrics - MaxPartCountForPartition <p>-</p> Dependent item metrics.async.MaxPartCountForPartition<p>Update: 0</p>
Clickhouse Events - InsertQuery <p>-</p> Dependent item events.InsertQuery<p>Update: 0</p>
Clickhouse Events - Merge <p>-</p> Dependent item events.Merge<p>Update: 0</p>
Clickhouse AsyncMetrics - Memory <p>-</p> Dependent item metrics.async.Memory<p>Update: 0</p>
Clickhouse Metrics - TCPConnection <p>-</p> Dependent item metrics.TCPConnection<p>Update: 0</p>
Clickhouse Metrics - HTTPConnection <p>-</p> Dependent item metrics.HTTPConnection<p>Update: 0</p>
Clickhouse Metrics - InterserverConnection <p>-</p> Dependent item metrics.InterserverConnection<p>Update: 0</p>
Clickhouse AsyncMetrics - ReplicasMaxQueueSize <p>-</p> Dependent item metrics.async.ReplicasMaxQueueSize<p>Update: 0</p>
Clickhouse AsyncMetrics - Uptime <p>-</p> Dependent item metrics.async.Uptime<p>Update: 0</p>
Clickhouse Metrics <p>SELECT metric, value FROM system.metrics FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20metric%2C%20value%20FROM%20system.metrics%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Metrics - ReadonlyReplica <p>-</p> Dependent item metrics.ReadonlyReplica<p>Update: 0</p>

Triggers

There are no triggers in this template.

Clickhouse

Overview

Template to monitor main Clickhouse parameters without using additional scripts

It uses HTTP interface to read metrics from system database using Zabbix Agent’s HTTP client

Gathered metrics:

<p style=”box-sizing: border-box; margin-top: 0px; margin-bottom: 16px; color: #24292e; font-family: -apple-system, system-ui, ‘Segoe UI’, Helvetica, Arial, sans-serif, ‘Apple Color Emoji’,

Author

Igor Novgorodov

Macros used

Name Description Default Type
{$CH_MAX_INACTIVE_PARTS} <p>-</p> 2000 Text macro
{$CH_MAX_PARTS} <p>-</p> 50 Text macro
{$CH_MAX_REPLICA_QUEUE} <p>-</p> 5 Text macro
{$CH_URL} <p>-</p> http://127.0.0.1:8123 Text macro

There are no template links in this template.

Discovery rules

There are no discovery rules in this template.

Items collected

Name Description Type Key and additional info
Clickhouse Metrics - ReadonlyReplica <p>-</p> Dependent item metrics.ReadonlyReplica<p>Update: 0</p>
Clickhouse AsyncMetrics - Memory <p>-</p> Dependent item metrics.async.Memory<p>Update: 0</p>
Clickhouse Events <p>SELECT event, value FROM system.events FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20event%2C%20value%20FROM%20system.events%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Metrics - TCPConnection <p>-</p> Dependent item metrics.TCPConnection<p>Update: 0</p>
Clickhouse Events - InsertedBytes <p>-</p> Dependent item events.InsertedBytes<p>Update: 0</p>
Clickhouse Events - InsertedRows <p>-</p> Dependent item events.InsertedRows<p>Update: 0</p>
Clickhouse Events - InsertQuery <p>-</p> Dependent item events.InsertQuery<p>Update: 0</p>
Clickhouse Metrics - LeaderReplica <p>-</p> Dependent item metrics.LeaderReplica<p>Update: 0</p>
Clickhouse Inactive Parts <p>Number of inactive parts SELECT COUNT(*) AS c FROM system.parts WHERE active = 0 FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20COUNT%28%2A%29%20AS%20c%20FROM%20system.parts%20WHERE%20active%20%3D%200%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Metrics - HTTPConnection <p>-</p> Dependent item metrics.HTTPConnection<p>Update: 0</p>
Clickhouse Events - Query <p>-</p> Dependent item events.Query<p>Update: 0</p>
Clickhouse Metrics <p>SELECT metric, value FROM system.metrics FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20metric%2C%20value%20FROM%20system.metrics%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Events - Merge <p>-</p> Dependent item events.Merge<p>Update: 0</p>
Clickhouse Metrics - Merge <p>-</p> Dependent item metrics.Merge<p>Update: 0</p>
Clickhouse Events - SelectQuery <p>-</p> Dependent item events.SelectQuery<p>Update: 0</p>
Clickhouse AsyncMetrics - MaxPartCountForPartition <p>-</p> Dependent item metrics.async.MaxPartCountForPartition<p>Update: 0</p>
Clickhouse AsyncMetrics - ReplicasMaxQueueSize <p>-</p> Dependent item metrics.async.ReplicasMaxQueueSize<p>Update: 0</p>
Clickhouse Metrics - Query <p>-</p> Dependent item metrics.Query<p>Update: 0</p>
Clickhouse AsyncMetrics <p>SELECT metric, value FROM system.asynchronous_metrics FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20metric%2C%20value%20FROM%20system.asynchronous_metrics%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse AsyncMetrics - Uptime <p>-</p> Dependent item metrics.async.Uptime<p>Update: 0</p>
Clickhouse Metrics - InterserverConnection <p>-</p> Dependent item metrics.InterserverConnection<p>Update: 0</p>
Clickhouse Ping <p>-</p> Zabbix agent web.page.regexp[{$CH_URL}/ping,,,HTTP/1.1 (\d+),,\1]<p>Update: 1m</p>

Triggers

There are no triggers in this template.

Clickhouse

Overview

Template to monitor main Clickhouse parameters without using additional scripts

It uses HTTP interface to read metrics from system database using Zabbix Agent’s HTTP client

Gathered metrics:

<p style=”box-sizing: border-box; margin-top: 0px; margin-bottom: 16px; color: #24292e; font-family: -apple-system, system-ui, ‘Segoe UI’, Helvetica, Arial, sans-serif, ‘Apple Color Emoji’,

Author

Igor Novgorodov

Macros used

Name Description Default Type
{$CH_MAX_INACTIVE_PARTS} <p>-</p> 2000 Text macro
{$CH_MAX_PARTS} <p>-</p> 50 Text macro
{$CH_MAX_REPLICA_QUEUE} <p>-</p> 5 Text macro
{$CH_URL} <p>-</p> http://127.0.0.1:8123 Text macro

There are no template links in this template.

Discovery rules

There are no discovery rules in this template.

Items collected

Name Description Type Key and additional info
Clickhouse Metrics - ReadonlyReplica <p>-</p> Dependent item metrics.ReadonlyReplica<p>Update: 0</p>
Clickhouse AsyncMetrics - Memory <p>-</p> Dependent item metrics.async.Memory<p>Update: 0</p>
Clickhouse Events <p>SELECT event, value FROM system.events FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20event%2C%20value%20FROM%20system.events%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Metrics - TCPConnection <p>-</p> Dependent item metrics.TCPConnection<p>Update: 0</p>
Clickhouse Events - InsertedBytes <p>-</p> Dependent item events.InsertedBytes<p>Update: 0</p>
Clickhouse Events - InsertedRows <p>-</p> Dependent item events.InsertedRows<p>Update: 0</p>
Clickhouse Events - InsertQuery <p>-</p> Dependent item events.InsertQuery<p>Update: 0</p>
Clickhouse Metrics - LeaderReplica <p>-</p> Dependent item metrics.LeaderReplica<p>Update: 0</p>
Clickhouse Inactive Parts <p>Number of inactive parts SELECT COUNT(*) AS c FROM system.parts WHERE active = 0 FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20COUNT%28%2A%29%20AS%20c%20FROM%20system.parts%20WHERE%20active%20%3D%200%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Metrics - HTTPConnection <p>-</p> Dependent item metrics.HTTPConnection<p>Update: 0</p>
Clickhouse Events - Query <p>-</p> Dependent item events.Query<p>Update: 0</p>
Clickhouse Metrics <p>SELECT metric, value FROM system.metrics FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20metric%2C%20value%20FROM%20system.metrics%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse Events - Merge <p>-</p> Dependent item events.Merge<p>Update: 0</p>
Clickhouse Metrics - Merge <p>-</p> Dependent item metrics.Merge<p>Update: 0</p>
Clickhouse Events - SelectQuery <p>-</p> Dependent item events.SelectQuery<p>Update: 0</p>
Clickhouse AsyncMetrics - MaxPartCountForPartition <p>-</p> Dependent item metrics.async.MaxPartCountForPartition<p>Update: 0</p>
Clickhouse AsyncMetrics - ReplicasMaxQueueSize <p>-</p> Dependent item metrics.async.ReplicasMaxQueueSize<p>Update: 0</p>
Clickhouse Metrics - Query <p>-</p> Dependent item metrics.Query<p>Update: 0</p>
Clickhouse AsyncMetrics <p>SELECT metric, value FROM system.asynchronous_metrics FORMAT JSON</p> Zabbix agent web.page.get[{$CH_URL}/?query=SELECT%20metric%2C%20value%20FROM%20system.asynchronous_metrics%20FORMAT%20JSON]<p>Update: 1m</p>
Clickhouse AsyncMetrics - Uptime <p>-</p> Dependent item metrics.async.Uptime<p>Update: 0</p>
Clickhouse Metrics - InterserverConnection <p>-</p> Dependent item metrics.InterserverConnection<p>Update: 0</p>
Clickhouse Ping <p>-</p> Zabbix agent web.page.regexp[{$CH_URL}/ping,,,HTTP/1.1 (\d+),,\1]<p>Update: 1m</p>

Triggers

There are no triggers in this template.