【IT168 专稿】在上一篇文章中，我们介绍了主流商业列存储数据库Sybase IQ 15.2版的功能特点，并给出了tpc-h scala=10,ssb (星型模式)scala=10性能测试的数据。在本文写作之际， Infobright和InfiniDB刚刚发布了新版本，并声称比之前版本性能上有了进一步提升，而sybase IQ的新版v15.3可能要在4、5月份才能推出，据说在压缩、查询和多节点上也有了大幅度提升，这次测试专门基于它们目前各自的最新版本，以反映各种软件的最大性能表现。另外，基于相同的原因，不再测试性能受限的社区版，只测试企业版。
系列文章回顾：
一、测试平台
比较测试的平台沿用上篇Sybase IQ安装的机器，是基于Intel Xeon 7550*8的PC服务器上用VMWare VSphere 4.1管理的虚拟机，虚拟机的逻辑CPU个数是8，内存100GB，存储为8个300GB本地磁盘的RAID5阵列。操作系统采用和RHEL 5相同的核心级别的Red Flag Asian Linux Sever 3.0 x64。用于比较的Oracle采用11.2.0.2版本，本次测试采用了并行查询的方式。由于Linux是互联网公司常用的服务器操作系统，因此这一测评，对更大范围的用户也有参考价值。
二、安装
我们先来安装Infobright和InfiniDB这两个轻量级的数据库的Linux版，虽然比Windows版本复杂一些，但Infobright官方wiki提供的安装文章只有一页，可想而知安装是多么容易，InfiniDB的安装手册页数略多，但包含了升级、集群等复杂安装模式，总体而言，单服务器新装软件还是相当快捷的。下面分别是各种软件的安装步骤。
(一) Infobright的安装步骤
1. 注册新用户从http://support.infobright.com/Support/Downloads下载对应操作系统的安装包IEE v3.5.2 64-Bit RPM (Red Hat Enterprise 5.x and CentOS 5.x)(69M) ，infobright-3.5.2-0-x86_64-eval.rpm，如果没有测试授权lic文件，也要申请一个。
2.登录到操作系统，在软件存放目录输入下面的命令安装软件。
rpm -ivh infobright-3.5.2-0-x86_64-eval.rpm
Installing infobright 3.5.2-0 (x86_64_eval)
The installer will generate /tmp/ib3.5.2-0-install.log install trace log.
1:infobright ########################################### [100%]
Creating/Updating datadir and cachedir
Creating user mysql and group mysql
Installing default databases
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/infobright-3.5.2-x86_64/bin/mysqladmin -u root password 'new-password'
/usr/local/infobright-3.5.2-x86_64/bin/mysqladmin -u root -h redflag11012601.localdomain password 'new-password'
Alternatively you can run:
/usr/local/infobright-3.5.2-x86_64/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/infobright-3.5.2-x86_64 ; /usr/local/infobright-3.5.2-x86_64/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/infobright-3.5.2-x86_64/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/local/infobright-3.5.2-x86_64/scripts/mysqlbug script!
The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/
System Physical memory: 100723(MB)
Infobright optimal ServerMainHeapSize is set to 32000(MB)
Infobright optimal LoaderMainHeapSize is set to 800(MB)
Infobright server installed into folder /usr/local/infobright
Installation log file /tmp/ib3.5.2-0-install.log
Installation of 3.5.2-0 completed!
