Shulou(Shulou.com)06/01 Report--

What are the commonly used monitoring indicators of ClickHouse? in view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Today, let's talk about the commonly used monitoring indicators in ClickHouse.

In a production environment, most of the operations are done around MergeTree, and generally speaking

Operations such as INSERT, ALTER, MERGE, and SELECT.

As there are so many indicators recorded in ClickHouse, it is impossible to list them all here, so today it can only be regarded as throwing a brick to attract jade for your reference.

INSERT:

Index

Description

Number of INSERT statements executed by events.InsertQuery

Data rows that have been written by events.InsertedRows

Number of Block delayed writes by events.DelayedInserts due to high write load

The number of Block that cannot be written by events.RejectedInserts due to Too many parts exception events.DuplicatedInsertedBlocks the number of Block ignored because of the same Block ID when writing ReplicatedMergeTree

MERGE:

Index

Description

Data rows of events.MergedRowsMerge

Number of threads executing tasks in the metrics.BackgroundPoolTask background

Number of times metrics.Merge ‍‍ Merge

Total memory allocated by metrics.MemoryTrackingForMerges to merge operations

ALTER TABLE:

Index

Description

Number of times metrics.PartMutation executes ALTER UPDATE/DELETE

SELECT:

Index

Description

Total number of events.Query queries, including the number of INSERTevents.SelectQuerySELECT queries

Number of events.SlowRead slow queries

Metrics.MemoryTracking

Total memory allocated to server

MarkCacheHits/MarkCacheMisses

Hit ratio of MarkCache cache

In addition to the above routine operations, there are also some common monitoring indicators for replicas.

ReplicaMergeTree:

Index

Description

Number of current read-only copies of metrics.ReadonlyReplica number of metrics.ReplicatedFetch copies fetch part

Metrics.ReplicatedSend

Number of copies sent part

Events.ZooKeeperTransactions

Number of transactions for ZK

Number of sessions for metrics.ZooKeeperSessionZK

The number of Watch of metrics.ZooKeeperWatchZK

In addition to the above listed parts, there are many related indicators, I did not list all of them, you can continue to add your favorite indicators along the way of thinking.

Finally, combined with the integration with Prometheus and Grafana, it is very easy to control the running state of ClickHouse.

The answers to the questions about the commonly used monitoring indicators of ClickHouse are shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.