Redis性能测试报告

Redis的性能测试报告主要是基于TPCDS的性能测试报告。

测试环境

操作系统: CentOS release 6.2 (Final) ​
虚拟机版本: Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode) ​
测试机器: client01v.qss.zzzc.qihoo.net、clientadmin.dfs.shbt.qihoo.net

XSQL配置

基于TPCDS的性能测试报告

测试目标

本次测试旨在对比XSQL下推与jedis api的性能表现。

测试数据集

测试结果汇总

序号 jedis api xsql sql语句
1 0.003 0.479 select * where key = 'geonames2w:10000029';
2 0.005 0.142 select * from geonames2w where suffix in ('10000028','10000030');
3 55.818 59.991 select * from geonames2w;
4 0.003 0.465 select * where key = 'geonames10w:10000029';
5 0.006 0.072 select * from geonames10w where suffix in ('10000028','10000030');
6 297.196 294.35 select * from geonames10w;
7 0.004 0.047 select * where key = 'geonames10w:10000029';
8 0.006 0.051 select * from geonames100w where suffix in ('10000028','10000030');
9 2832.887 2960.651 select * from geonames100w;

采用pipeline方法后:

序号 jedis get key only xsql sql语句
3 5.17 8.219 select * from geonames2w;
6 25.895 30.513 select * from geonames10w;
9 261.946 333.238 select * from geonames100w;

结论