修改存储路径:
CK 默认的配置文件位置:/etc/clickhouse-server/
[root@A02-R05-I45-170-J33FE0D ~]# ls /etc/clickhouse-server/
config.xml users.xml
默认数据存储路径位于:/var/lib/clickhouse/, 需要将其修改到大磁盘下面;
1, 先备份配置文件
2, 确认server哪个盘最大,在下面建立目录; 我创建了/export/clickhouse
2, 编辑配置文件,修改内容:
#数据存储目录修改为:
<path>/var/lib/clickhouse/</path>
#临时数据目录
<tmp_path>/var/lib/clickhouse/tmp/</tmp_path>
#用户文件目录
<user_files_path>/var/lib/clickhouse/user_files/</user_files_path>
#分别修改为:
<path>/export/clickhouse/</path>
<tmp_path>/export/clickhouse/tmp/</tmp_path>
<user_files_path>//export/clickhouse/user_files/</user_files_path>
3, 修改目录的数组和数主
chown -R clickhouse.clickhouse /export/clickhouse/
4, 重启服务,使之生效;service clickhouse-server restart
[root@A02-R05-I45-170-J33FE0D ~]# service clickhouse-server restart
Stop clickhouse-server service: DONE
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /export/clickhouse/
DONE