infiniDB与clickhouse对比
infiniDB与与clickhouse对比对比
机器配置:
测试机: dell R510
cpu: xeon E56202
RAID
卡:
H700
系统
:
ubuntu 14.04
内核:
Linux ubuntu 4.2.0-27-generic
raid
级别:
raid0
文件系统:
ext4
硬盘:
SSD 240G2
IP: 192.168.112.73
一、安装
1、infiniDB的安装见 http://verynull.com/2015/06/24/infiniDB安装配置/
2、clickhouse安装
只支持ubutu14.04,16.04,12.04,但是我在16.04上没有安装起来。
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4# optional
sudo mkdir -p /etc/apt/sources.list.d
echo "deb http://repo.yandex.ru/clickhouse/trusty stable main" |
sudo tee /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update
sudo apt-get install clickhouse-server-common clickhouse-client
sudo service clickhouse-server start
clickhouse-client
3、就安装过程而言,clickhouse方便很多,infiniDB要编译老半天。
二、性能测试
1、创建表
infiniDB:
CREATE TABLE `billing` (
`did` int(11) NOT NULL DEFAULT '0' COMMENT '',
`hit` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`reqs` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`rx` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`tx` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`logtime` bigint(20) NOT NULL DEFAULT '0' COMMENT '',
`tpr` bigint(20) NOT NULL DEFAULT '0' COMMENT ''
) ENGINE=infiniDB DEFAULT CHARSET=latin1
CREATE TABLE billing (id Int32,did Int32,hit Int64,reqs Int64,rx Int64,tx Int64,logtime Int6
4,tpr Int64) ENGINE=Log;
106,9,10,123,11858014,1467133200,330,0
122,0,2,506,621,1467133200,150,0
124,112,249,1131297,1899996,1467133200,49,0
127,3,12,64257,88503,1467133200,66,0
评论0