Why is my primary key not used? How can I check?
Covers a common reason why a primary key is not used in ordering and how we can confirm
· 약 6분
Knowledge Base
"Performance and Optimizations" 태그로 연결된 15개 게시물개의 게시물이 있습니다.
Profiling ClickHouse with LLVM's XRay
Learn how to profile ClickHouse using LLVM's XRay instrumentation profiler, visualize traces, and analyze performance.
· 약 4분
Tips and tricks on optimizing basic data types in ClickHouse
Tips and tricks on optimizing basic data types in ClickHouse
· 약 4분
How to achieve data read consistency in ClickHouse?
Learn how to ensure data consistency when reading from ClickHouse, whether you're connected to the same node or a random node.
· 약 2분
How to Verify Query Cache Usage in ClickHouse
Learn how to check if query cache is being utilized in ClickHouse using `clickhouse-client` trace logs or SQL commands.
· 약 7분
How to Measure Query Processing Time Without Returning Rows
Learn how to use the `FORMAT Null` option in ClickHouse to measure query processing time without returning any rows to the client.
· 약 1분
Identifying Expensive Queries by Memory Usage in ClickHouse
Learn how to use the `system.query_log` table to find the most memory-intensive queries in ClickHouse, with examples for clustered and standalone setups.
· 약 2분
How to calculate the ratio of empty/zero values in every column in a table
Learn how to calculate the ratio of empty or zero values in every column of a ClickHouse table to optimize sparse column serialization.
· 약 2분
How to Identify the Most Expensive Queries in ClickHouse
Learn how to use the `query_log` table in ClickHouse to identify the most memory and CPU-intensive queries across distributed nodes.
· 약 6분
Synchronous data reading
The new setting `allow_asynchronous_read_from_io_pool_for_merge_tree` allows the number of reading threads (streams) to be higher than the number of threads in the rest of the query execution pipeline.
· 약 4분
