孤傲然的博客

chproxy是一个用于clickhouse数据库的 HTTP 代理、负载均衡器。 chproxy 实战

创建用户、角色、授权和回收权限access_management create role create user GRANT SELECT ON db.* TO SHOW ACCESS

cickhouse 分区目录的合并过程、分区目录下的文件结构

clickhouse 版本升级、降级、导入导出数据

max_memory_usage_for_user, max_memory_usage, max_bytes_before_external_group_by, max_bytes_before_external_sort, max_memory_usage_for_all_queries, max_concurrent_queries_for_user,max_concurrent_queries_for_all_users,max_concurrent_queries,max_serve

clickhouse 常用引擎CollapsingMergeTree VersionedCollapsingMergeTree AggregatingMergeTree SummingMergeTree RelacingMergeTree kafka 表引擎 ReplicatedMergeTree