# HELP jmx_scrape_error Non-zero if this scrape failed.
# TYPE jmx_scrape_error gauge
jmx_scrape_error 0.0

docker build --tag myrepo/clickhouse-exporter:latest .

docker run -ti myrepo/clickhouse-exporter:latest
exec /usr/local/bin/clickhouse_exporter: no such file or directory

~ $ ldd /usr/local/bin/clickhouse_exporter
        /lib64/ld-linux-x86-64.so.2 (0x7f2b1739c000)
        libc.so.6 => /lib64/ld-linux-x86-64.so.2 (0x7f2b1739c000)

apk add libc6-compat 

clickhouse_exporter.go:16:2: cannot find package "github.com/prometheus/client_golang/prometheus" in any of:
	/usr/src/github.com/prometheus/client_golang/prometheus (from $GOROOT)
	/home/user/go/src/github.com/prometheus/client_golang/prometheus (from $GOPATH)

root@clickhouse1 ~ # curl -k  https://localhost:8443/?query=select+%2A+from+system.metrics
Query	1
Merge	0
PartMutation	0
ReplicatedFetch	0
ReplicatedSend	0
ReplicatedChecks	0
BackgroundPoolTask	0
BackgroundSchedulePoolTask	0
DiskSpaceReservedForMerge	0
DistributedSend	0
QueryPreempted	0
TCPConnection	126
HTTPConnection	1
InterserverConnection	0
OpenFileForRead	0
OpenFileForWrite	0
Read	1
Write	0
SendExternalTables	0
QueryThread	0
ReadonlyReplica	0
LeaderReplica	116
MemoryTracking	8704
MemoryTrackingInBackgroundProcessingPool	29216
MemoryTrackingInBackgroundSchedulePool	0
MemoryTrackingForMerges	0
LeaderElection	116
EphemeralNode	232
ZooKeeperSession	1
ZooKeeperWatch	349
ZooKeeperRequest	0
DelayedInserts	0
ContextLockWait	0
StorageBufferRows	0
StorageBufferBytes	0
DictCacheRequests	0
Revision	54388
RWLockWaitingReaders	0
RWLockWaitingWriters	0
RWLockActiveReaders	1
RWLockActiveWriters	0

root@ch1 ~ # curl -k   https://localhost:8443/?query=select+%2A+from+system.metrics
Query	1	Number of executing queries
Merge	0	Number of executing background merges
PartMutation	0	Number of mutations (ALTER DELETE/UPDATE)
ReplicatedFetch	0	Number of data parts fetching from replica
ReplicatedSend	0	Number of data parts sending to replicas
ReplicatedChecks	0	Number of data parts checking for consistency
BackgroundPoolTask	0	Number of active tasks in BackgroundProcessingPool (merges, mutations, fetches or replication queue bookkeeping)
BackgroundSchedulePoolTask	0	Number of active tasks in BackgroundSchedulePool. This pool is used for periodic tasks of ReplicatedMergeTree like cleaning old data parts, altering data parts, replica re-initialization, etc.
DiskSpaceReservedForMerge	0	Disk space reserved for currently running background merges. It is slightly more than total size of currently merging parts.
DistributedSend	0	Number of connections sending data, that was INSERTed to Distributed tables, to remote servers. Both synchronous and asynchronous mode.
QueryPreempted	0	Number of queries that are stopped and waiting due to \'priority\' setting.
TCPConnection	0	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
OpenFileForRead	0	Number of files open for reading
OpenFileForWrite	0	Number of files open for writing
Read	1	Number of read (read, pread, io_getevents, etc.) syscalls in fly
Write	0	Number of write (write, pwrite, io_getevents, etc.) syscalls in fly
SendExternalTables	0	Number of connections that are sending data for external tables to remote servers. External tables are used to implement GLOBAL IN and GLOBAL JOIN operators with distributed subqueries.
QueryThread	0	Number of query processing threads
ReadonlyReplica	0	Number of Replicated tables that are currently in readonly state due to re-initialization after ZooKeeper session loss or due to startup without ZooKeeper configured.
LeaderReplica	21	Number of Replicated tables that are leaders. Leader replica is responsible for assigning merges, cleaning old blocks for deduplications and a few more bookkeeping tasks. There may be no more than one leader across all replicas at one moment of time. If there is no leader it will be elected soon or it indicate an issue.
MemoryTracking	69847347	Total amount of memory (bytes) allocated in currently executing queries. Note that some memory allocations may not be accounted.
MemoryTrackingInBackgroundProcessingPool	0	Total amount of memory (bytes) allocated in background processing pool (that is dedicated for backround merges, mutations and fetches). Note that this value may include a drift when the memory was allocated in a context of background processing pool and freed in other context or vice-versa. This happens naturally due to caches for tables indexes and doesn\'t indicate memory leaks.
MemoryTrackingInBackgroundSchedulePool	0	Total amount of memory (bytes) allocated in background schedule pool (that is dedicated for bookkeeping tasks of Replicated tables).
MemoryTrackingForMerges	0	Total amount of memory (bytes) allocated for background merges. Included in MemoryTrackingInBackgroundProcessingPool. Note that this value may include a drift when the memory was allocated in a context of background processing pool and freed in other context or vice-versa. This happens naturally due to caches for tables indexes and doesn\'t indicate memory leaks.
LeaderElection	21	Number of Replicas participating in leader election. Equals to total number of replicas in usual cases.
EphemeralNode	42	Number of ephemeral nodes hold in ZooKeeper.
ZooKeeperSession	1	Number of sessions (connections) to ZooKeeper. Should be no more than one, because using more than one connection to ZooKeeper may lead to bugs due to lack of linearizability (stale reads) that ZooKeeper consistency model allows.
ZooKeeperWatch	64	Number of watches (event subscriptions) in ZooKeeper.
ZooKeeperRequest	0	Number of requests to ZooKeeper in fly.
DelayedInserts	0	Number of INSERT queries that are throttled due to high number of active data parts for partition in a MergeTree table.
ContextLockWait	0	Number of threads waiting for lock in Context. This is global lock.
StorageBufferRows	0	Number of rows in buffers of Buffer tables
StorageBufferBytes	0	Number of bytes in buffers of Buffer tables
DictCacheRequests	0	Number of requests in fly to data sources of dictionaries of cache type.
Revision	54407	Revision of the server. It is a number incremented for every release or release candidate.
RWLockWaitingReaders	0	Number of threads waiting for read on a table RWLock.
RWLockWaitingWriters	0	Number of threads waiting for write on a table RWLock.
RWLockActiveReaders	1	Number of threads holding read lock in a table RWLock.
RWLockActiveWriters	0	Number of threads holding write lock in a table RWLock
.```

-- SELECT
--     type,
--     user,
--     sum(count) AS count,
--     sum(query_duration_ms) AS query_duration_ms,
--     sum(read_rows) AS read_rows,
--     sum(read_bytes) AS read_bytes
-- FROM system.clickhouse_query_stats_by_user
-- GROUP BY
--     type,
--     user
--
-- Example output:
--
-- ┌─type─┬─user─────┬─count─┬─query_duration_ms─┬───read_rows─┬───read_bytes─┐
-- │    2 │ mvavrusa │    78 │            104566 │ 75332316665 │ 422028872602 │
-- │    1 │ mvavrusa │    78 │                 0 │           0 │            0 │
-- │    3 │ mvavrusa │     8 │                 0 │           0 │            0 │
-- └──────┴──────────┴───────┴───────────────────┴─────────────┴──────────────┘
--
-- The column `type` has the following meaning:
--
-- 1 - successful start of query execution
-- 2 - successful end of query execution
-- 3 - exception before start of query execution
-- 4 - exception while query execution

clickhouse_user_query_read_rows{cluster="http",type="end_success",user="mvavrusa"} 660593724120

curl  http://localhost:8123?user=bob&password=secret

curl -H "X-ClickHouse-User: user" -H "X-ClickHouse-Key: password"  'http://localhost:8123/'

clickhouse_exporter -scrape_uri=http://localhost:8123?user=bob&password=secret

http://localhost:8123?user=bob&password=secret?query=select%20*%20from%20system.metrics

# HELP clickhouse_block_active_time_dm-0 Number of BlockActiveTime_dm-0 async processed
# TYPE clickhouse_block_active_time_dm-0 gauge

Step 5/11 : RUN make init && make
 ---> Running in 408022b2de85
go get -u github.com/AlekSi/gocoverutil
go: downloading github.com/AlekSi/gocoverutil v0.2.0
go: downloading golang.org/x/tools v0.1.9
go get: added github.com/AlekSi/gocoverutil v0.2.0
go get: upgraded golang.org/x/sys v0.0.0-20170710161658-abf9c25f5445 => v0.0.0-20211019181941-9d821ace8654
go get: added golang.org/x/tools v0.1.9
go install -v
go: inconsistent vendoring in /go/src/github.com/ClickHouse/clickhouse_exporter:
        github.com/AlekSi/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
        golang.org/x/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
        golang.org/x/[email protected]: is marked as explicit in vendor/modules.txt, but not explicitly required in go.mod

        To ignore the vendor directory, use -mod=readonly or -mod=mod.
        To sync the vendor directory, run:
                go mod vendor
make: *** [Makefile:7: build] Error 1
The command '/bin/sh -c make init && make' returned a non-zero code: 2

Dec 13 19:00:35 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:35 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 5ms
Dec 13 19:00:35 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:35 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 10ms
Dec 13 19:00:35 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:35 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 20ms
Dec 13 19:00:35 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:35 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 40ms
Dec 13 19:00:35 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:35 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 80ms
Dec 13 19:00:35 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:35 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 160ms
Dec 13 19:00:36 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:36 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 320ms
Dec 13 19:00:36 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:36 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 640ms
Dec 13 19:00:37 localhost prometheus-clickhouse-exporter[61675]: 2018/12/13 19:00:37 http: Accept error: accept tcp 127.0.0.1:3000: accept4: too many open files; retrying in 1s

:~$ sudo netstat -ntp | grep 3010 | grep CLOSE_WAIT | wc -l
3912

step 1:
mkdir -p $GOPATH/src/github.com/Percona-Lab
cd $GOPATH/src/github.com/Percona-Lab
git clone https://github.com/Percona-Lab/clickhouse_exporter

step2 : mac本地编译
cd $GOPATH/src/github.com/Percona-Lab/clickhouse_exporter
GO111MODULE=off CGO_ENABLED=0 GOOS=linux GOARCH=amd64 go build clickhouse_exporter.go

step3: 上传服务器 centos6

step4:执行
./clickhouse_exporter -scrape_uri=http://clickhouse_server_ip:8123/ -log.level=info