对比mysql一般引擎与infobright
1.mysql与infobirght的配置
采用虚拟机:
mysql:10.28.174.74 10.28.174.237
内存: 4g 3g
cpu:双核 cpu MHz : 3309.71
2.测试程序python
3.测试数据700w左右结果1:
infobright:
----start time:Tue, 23 Jul 2013 13:51:32 +0000----end time:Tue, 23 Jul 2013 13:51:42 +0000----start time:Tue, 23 Jul 2013 13:51:42 +0000exec start0Tue, 23 Jul 2013 13:51:42 +0000exec start50000Tue, 23 Jul 2013 13:51:44 +0000exec start100000Tue, 23 Jul 2013 13:51:49 +0000exec start150000Tue, 23 Jul 2013 13:51:55 +0000exec start200000Tue, 23 Jul 2013 13:52:04 +0000----end time:Tue, 23 Jul 2013 13:52:12 +0000
从结果得出:
mysql infobrightcount: 10s 2sfetch_data(20w左右分页5w):30s 7s