2 回复
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.
用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