如何监控Clickhouse的连接数

请教一下如何监控Clickhouse的连接数

bogon.localdomain :) select * from system.metrics where metric like '%Connection%' SELECT * FROM system.metrics WHERE metric LIKE ‘%Connection%’

─metric─────────────────value──description─────────────────────────────────────────────────────────

TCPConnection * 1 * Number of connections to TCP server (clients with native interface) *
HTTPConnection * 0 * Number of connections to HTTP server *
InterserverConnection * 0 * Number of connections from other replicas to fetch parts * ───────────────────────────────────────────────────────────────────────────────────────────────────

3 rows in set. Elapsed: 0.008 sec.

Fanduzi 2楼•4 个月前

用SQL是一种方法还有就是用clickhouse exporter 或者 native的prometheus config.xml增加如下内容

 <prometheus>
        <endpoint>/metrics</endpoint>
        <port>8001</port>
        <metrics>true</metrics>
        <events>true</events>
        <asynchronous_metrics>true</asynchronous_metrics>
</prometheus>

我这测试这个参数需要重启生效, 这种就不需要装exporter了, 使用是一样的

ClickHouseMetrics_TCPConnection
ClickHouseMetrics_HTTPConnection
ClickHouseMetrics_InterserverConnection