#转载# Clickhouse 常用的运维SQL
当前连接数
|
1 2 3 4 5 6 7 8 9 10 11 |
ch7.nauu.com :) SELECT * FROM system.metrics WHERE metric LIKE '%Connection'; SELECT * FROM system.metrics WHERE metric LIKE '%Connection' ┌─metric────────────────┬─value─┬─description─────────────────────────────────────────────────────────┐ │ TCPConnection │ 2 │ Number of connections to TCP server (clients with native interface) │ │ HTTPConnection │ 1 │ Number of connections to HTTP server │ │ InterserverConnection │ 0 │ Number of connections from other replicas to fetch parts │ └───────────────────────┴───────┴─────────────────────────────────────────────────────────────────────┘ |
当前正在执行的查询 通过 sys…