systemctl stop clickhouse-server.service
3、重启clickhouse服务
sudo /etc/init.d/clickhouse-server restart
service clickhouse-server restart
systemctl restart clickhouse-server.service
4、查看clickhouse服务
sudo /etc/init.d/clickhouse-server status
service clickhouse-server status
systemctl status clickhouse-server.service
5、启动clickhouse客户端
clickhouse-client
6、查看clickhouse进程
ps -ef | grep clickhouse
7、停止clickhouse相关服务
ps -ef | grep clickhouse | grep -v grep | awk ‘{print $2}’ | xargs kill -9
8、查看clickhouse正常日志
tail -n 300 /var/log/clickhouse-server/clickhouse-server.log
9、查看clickhouse错误日志
tail -n 300 /var/log/clickhouse-server/clickhouse-server.err.log
10、关闭clickhouse开机自启（非生产环境）
sudo systemctl disable clickhouse-server
11、查看clickhouse集群配置
clickhouse-client -u default --password “” --query “SELECT * FROM system.clusters”
12、查看clickhouse所有表
echo “SELECT database,name,engine FROM system.tables WHERE database != ‘system’” | clickhouse-client
13、查看系统用户内存用量
ps aux | tail -n +2 | awk ‘{ printf(“%s\t%s\n”, $1, $4) }’ | clickhouse local -S “user String, memory Float” -q “SELECT user, round(sum(memory), 2) as memoryTotal FROM table GROUP BY user ORDER BY memoryTotal DESC FORMAT Pretty”
14、查询clickhouse执行指标
echo “SELECT * FROM system.numbers LIMIT 1000” | clickhouse-benchmark -i 5 -h localhost -h localhost
15、修改clickhouse用户密码
①方法一：配置 /etc/clickhouse-server/users.xml 文件
vim /etc/clickhouse-server/users.xml
123456
②方法二：配置 /etc/clickhouse-client/config.xml 文件
vim /etc/clickhouse-client/config.xml
username
password
False
五、ClickHouse集群
ClickHouse集群部署：
ClickHouse集群配置：
ClickHouse副本引擎：
ClickHouse分布式配置：
该集群配置为分片副本集群， ClickHouse只有 MergeTree 系列里的表可支持副本
副本配置提供高可用，分片配置提供数据的横向扩展和容灾
ClickHouse在单个节点创建表，表只会创建在单个节点上。如果想要使用复制表，
在建表时必须指定带 Replicated 前缀的
