clickhouse一个测试报告

测试语句

-- 9亿数据的表中做如下测试
select CLLXDM, count() from t1 group by CLLXDM ;

配置信息

124配置

[root@localhost ~]# free -m
              total        used        free      shared  buff/cache   available
Mem:          15887        2258        9978           4        3649       13027
Swap:          4095         473        3622
[root@localhost ~]# grep "model name" /proc/cpuinfo | cut -f2 -d:
 Intel(R) Xeon(R) CPU E5-2658 v4 @ 2.30GHz
 Intel(R) Xeon(R) CPU E5-2658 v4 @ 2.30GHz
 Intel(R) Xeon(R) CPU E5-2658 v4 @ 2.30GHz
 Intel(R) Xeon(R) CPU E5-2658 v4 @ 2.30GHz

103配置

[root@dswhhadoop-5 ~]# free -m
              total        used        free      shared  buff/cache   available
Mem:          48137       13931       15762         161       18444       32907
Swap:         16383           3       16380
[root@dswhhadoop-5 ~]# grep "model name" /proc/cpuinfo | cut -f2 -d:
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz
 Intel(R) Xeon(R) CPU E5-2640 v3 @ 2.60GHz

测试结果

124上
出结果：

15 rows in set. Elapsed: 5.463 sec. Processed 962.05 million rows,
9.64 GB (176.11 million rows/s., 1.77 GB/s.)

103上出结果：

15 rows in set. Elapsed: 1.772 sec. Processed 962.05 million rows,
9.64 GB (542.98 million rows/s., 5.44 GB/s.)

结论

cpu核 and 内存 是硬道理