tencent cloud

Feedback

ClickHouse Monitoring Metrics

Last updated: 2022-05-16 12:45:12

    ClickHouse - metrics

    Title Metric Unit Description
    Network connections tcp - Number of TCP server connections
    http - Number of HTTP server connections
    ZooKeeper event subscriptions watches - Number of ZooKeeper event subscriptions
    Ephemeral nodes held in ZooKeeper ephemeralNode - Number of ephemeral nodes held in ZooKeeper
    Active tasks in BackgroundPool backgroundPoolTask - Number of active tasks in BackgroundProcessingPool
    backgroundSchedulePoolTask - Number of active tasks in BackgroundSchedulePool
    Threads waiting for locks in Context contextLockWait - Number of threads waiting for locks in Context
    Throttled INSERT queries delayedInserts - Number of throttled INSERT queries
    Requests in fly to data sources of dictionaries of cache type dictCacheRequests - Number of requests in fly to data sources of dictionaries of cache type
    Pending files to process for asynchronous insertion into distributed tables distributedSend - Number of pending files to process for asynchronous insertion into distributed tables
    Threads global - Number of threads in the global thread pool
    globalActive - Number of active threads in the global thread pool
    local - Number of threads in the local thread pool
    localActive - Number of active threads in the local thread pool
    Replicas participating in leader election leaderElection - Number of replicas participating in leader election
    Replicated tables leaderReplica - Number of replicated tables that are leaders
    readonlyReplica - Number of replicated tables in read-only status
    Total allocated memory size memoryTracking GB Total memory size allocated to queries being executed
    backgroundProcessingPool GB Total memory size allocated to the background processing pool
    backgroundSchedulePool GB Total memory size allocated to the background scheduling pool
    memoryTrackingForMerges GB Total memory size allocated to background merges
    Merges being executed in the background merge - Number of merges being executed in the background
    Opened files read - Number of opened readable files
    write - Number of opened writable files
    Table changes partMutation - Number of table changes
    Query processing threads queryThread - Number of query processing threads
    Stopped or waiting queries queryPreempted - Number of stopped or waiting queries
    System calls read - Number of read system calls
    write - Number of write system calls
    Blocks fetch - Number of blocks collected from replicas
    send - Number of blocks sent to replicas
    check - Number of blocks for consistency check
    Server change revision - Number of server changes
    Version number version 1 Version number
    Threads waiting for read/write locks waitingRead - Number of threads waiting for read/write locks to read from tables
    waitingWrite - Number of threads waiting for read/write locks to write to tables
    activeRead - Number of threads holding read locks on tables
    activeWrite - Number of threads holding write locks on tables
    Rows in buffer tables storageBufferRows - Number of rows in buffer tables
    Bytes in buffer tables storageBufferBytes MB Number of bytes in buffer tables

    ClickHouse - events

    Title Metric Unit Description
    Queries total - Total number of queries that may be executed
    select - Number of SELECT queries that may be executed
    insert - Number of INSERT queries that may be executed
    Inserted rows insertedRows - Number of rows inserted into all tables
    Inserted bytes insertedBytes - Number of bytes inserted into all tables
    Total time waiting for system calls read μs Total time waiting for read system calls
    write μs Total time waiting for write system calls
    Opened files fileOpen - Number of opened files
    Reads/Writes from/to file descriptors read - Number of reads from file descriptors
    write - Number of writes to file descriptors
    Bytes read/written from/to file descriptors read MB Number of bytes read from file descriptors
    write MB Number of bytes written to file descriptors
    Total time processing threads realtime μs Total time processing threads
    user μs Total time processing threads executing CPU instructions in user space
    system μs Total time processing threads executing CPU instructions in OS kernel space
    Compiled regular expressions regexpCreated - Number of compiled regular expressions

    ClickHouse - asynchronous metrics

    Title Metric Unit Description
    Size of cache of marks of StorageMergeTree markCacheBytes MB Size of cache of marks of StorageMergeTree
    Cache files of marks of StorageMergeTree markCacheFiles - Number of cache files of marks of StorageMergeTree
    Maximum number of active blocks maxPartCountForPartition - Number of largest active data blocks in partition
    Databases databaseCount - Number of databases
    Data tables tableCount - Number of data tables
    Maximum replica latency absolute μs Maximum replica queue latency
    relative μs Maximum difference of the absolute latency from other blocks
    Size of the queue for the operations to be performed replicasMaxQueueSize - Size of the queue for the operations to be performed
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support