How to Increase the Number of Threads in ClickHouse
Learn how to configure the Global Thread pool in ClickHouse by adjusting settings like `max_thread_pool_size`, `thread_pool_queue_size`, and `max_thread_pool_free_size`.
· One min read
Knowledge Base
How to Ignore Incorrect Settings in ClickHouse
Learn how to use the `skip_check_for_incorrect_settings` option to allow ClickHouse to start even when user-level settings are specified incorrectly.
· One min read
Capturing server logs of queries at the client
Learn how to capture server logs at the client level, even with different log settings, using the `send_logs_level` client setting.
· One min read
Comparing metrics between queries in decibels
A query to compare metrics between two queries in ClickHouse.
· 7 min read
How do I resolve Ingest Failures After ClickHouse 23.9 Release?
Learn how to resolve ingest failures caused by stricter grant checking introduced in ClickHouse 23.9 for tables using `async_inserts`. Update grants to fix errors.
· One min read
Improving Map Lookup Performance in ClickHouse
Learn how to optimize Map column lookups in ClickHouse for better query performance by materializing specific keys as standalone columns.
· 3 min read
Is it possible to delete old records from a ClickHouse table?
The short answer is "yes". ClickHouse has multiple mechanisms that allow freeing up disk space by removing old data. Each mechanism is aimed for different scenarios.
· 2 min read
How to confirm if a Projection is used by the query?
Learn how to check if a projection is used in ClickHouse queries by testing with sample data and using EXPLAIN to verify projection usage.
· 2 min read
Python quick example using HTTP requests module
An example using Python and requests module to write and read to ClickHouse
· 2 min read
Setting a limit on query execution time
How to enforce limit on max query execution time
· One min read
