docker安装运行单机版clickhouse-21.9.2.17 1、安装好docker并下载最新镜像 docker pull yandex/clickhouse-server:21.9.2.17 2、为了方便修改配置将配置信息从docker拷贝出来 临时运行一个clickhouse实例 docker run -it --rm yandex/clickhouse-server:21.9.2.17 bash cd /etc/clickhouse-server 新打开一个命令窗口拷贝文件 cd /etc/clickhouse-server tar -czvf...
clickhouse查看数据库及表空间大小语句 1、查看数据库容量、行数、压缩率 SELECT sum(ROWS) AS `总行数`, formatReadableSize(sum(data_uncompressed_bytes)) AS `原始大小`, formatReadableSize(sum(data_compressed_bytes)) AS `压缩大小`, round((sum(data_compressed_bytes) / sum(data_uncompressed_bytes)) * 100, 0) AS `压缩率`...