Tag: devops

Posts tagged "devops"

Fix ClickHouse Slow Startup and Lost Queries on Restart

Fix slow ClickHouse startup and lost queries on restart. Tune async table loading, max_waiting_queries, and shutdown_wait_unfinished_queries in production.

November 19, 20269 min read

ClickHouse DROP TABLE Fails: Table Is Too Large to Drop

DROP TABLE, TRUNCATE or DROP PARTITION fails with TABLE_SIZE_EXCEEDS_MAX_DROP_SIZE_LIMIT. Learn why this happens and pick the right one of the three fixes.

November 18, 20268 min read

One User or Tool Takes All Resources: ClickHouse Limits

Find the user or BI tool that takes most CPU and memory in ClickHouse. Use settings profiles, constraints, and quotas to set fair limits for each workload.

November 2, 20269 min read

Fix MEMORY_LIMIT_EXCEEDED While the Server Has Free RAM

One ClickHouse query fails with MEMORY_LIMIT_EXCEEDED but the server has spare memory. Learn to read the error, then set query, user and overcommit limits.

October 31, 202611 min read

ClickHouse® Alerts in Slack, Teams, Google Chat & PagerDuty in CH-Ops PRO

Send ClickHouse® alerts to Slack, Teams, Google Chat, and PagerDuty with CH-Ops Pro. Route alerts to the tools your team already uses.

August 26, 20269 min read

Install CH-Ops in 10 Minutes: Docker, Binary, or Source

Install CH-Ops in 10 minutes using Docker, a standalone binary, or source. Follow this step-by-step guide to get started quickly.

August 6, 20269 min read

Set Up a Local Kubernetes Cluster: minikube and k3s for Beginners

A hands-on, beginner-friendly guide to running Kubernetes on your own machine with minikube and k3s. Install kubectl, start a local cluster, run your first.

May 1, 20265 min read

Kubernetes for Absolute Beginners: A Gentle Introduction (with ClickHouse® in Mind)

A beginner-friendly introduction to Kubernetes for data engineers who want to run the ClickHouse® database on it.

April 28, 20269 min read