Instana Announces AI Powered Monitoring for ClickHouse

Instana is pleased to announce our official, first class support for Yandex ClickHouse. The important question is, what do I mean when I say, “first-class support”?

For Instana users, first-class support means the following:

  • Automatic discovery and monitoring of ClickHouse components
  • Full integration into the Instana Dynamic Graph (Click here for an explanation of the dynamic graph) – This model is used for correlation and causation.
  • Automatic selection and collection of all relevant metrics
  • Fully AI enabled behavioral learning
    • Predictive analytics
    • Automatic root cause analysis
  • Traces generated for EVERY request
  • Fully curated expert knowledge to identify problems and suggest remediation possibilities

So what is the value to you?

  • Know with certainty when one component is impacting other components or the service as a whole
  • Monitor the metrics that most clearly indicate problems. No guesswork required.
  • Know what is normal for any metric
  • Get warned BEFORE an issue occurs to take corrective action
  • Immediate troubleshooting by a single person
  • Troubleshoot any individual request. Never miss sporadic issues.
  • Expert in a box. Supplement the knowledge of your internal experts with expert knowledge from the Instana team.

Yandex ClickHouse Monitoring

It’s always a good idea to refer back to the official documentation for the latest details but this release tracks the following information:

The following configuration values are automatically tracked by parsing the ClickHouse configuration file.

  • http_port
  • tcp_port
  • https_port
  • tcp_ssl_port
  • log
  • error_log
  • interserver_http_port
  • listen_hosts
  • max_connections
  • keep_alive_timeout
  • max_concurrent_queries
  • uncompressed_cache_size
  • mark_cache_size
  • path
  • tmp_path
  • user_config_file_name
  • default_profile
  • default_database
  • timezone
  • umask
  • builtin_dictionaries_reload_interval
  • max_session_timeout
  • default_session_timeout

Metrics

  • Merge
  • ReplicatedFetch
  • ReplicatedSend
  • ReplicatedChecks
  • BackgroundPoolTask
  • DiskSpaceReservedForMerge
  • DistributedSend
  • QueryPreempted
  • TCPConnection
  • HTTPConnection
  • InterserverConnection
  • OpenFileForRead
  • OpenFileForWrite
  • Read
  • Write
  • SendExternalTables
  • QueryThread
  • ReadonlyReplica
  • LeaderReplica
  • MemoryTracking
  • MemoryTrackingInBackgroundProcessingPool
  • MemoryTrackingForMerges
  • LeaderElection
  • EphemeralNode
  • ZooKeeperWatch
  • DelayedInserts
  • ContextLockWait
  • StorageBufferRows
  • StorageBufferBytes
  • DictCacheRequests
  • Revision
  • RWLockWaitingReaders
  • RWLockWaitingWriters
  • RWLockActiveReaders
  • RWLockActiveWriters

Screenshot of Instana infrastructure dashboard showing ClickHouse metrics

Instana continues to build upon our world class AI powered monitoring for the many components used in modern application architectures. Be sure to sign up for a free trial of Instana in your environment today.

Start your FREE TRIAL today!

Full Stack Visibility in 5 minutes! Instana makes it easy to
manage the performance of your applications.

Free Trial

See how Instana's technology works!

Maximum Understanding, Minimum Effort! Check out
how Instana can help you managing your applications.

How Instana Works