查询测试结果 - 云原生多模数据库 Lindorm

本章节介绍查询测试的结果对比。本测试是在发挥数据最佳性能，并在没有任何数据写入的情况下测得的结果。在不同时间线规模的业务场景，或同时存在大量写入的场景下，或查询扫描的时间线和时间点更多时，查询性能可能会下降，建议在使用前结合自己的业务场景进行测试评估，本测试结果仅供参考。

查询的基础数据量

设备数100
每个设备每10秒上报101个测量值
共上报1天的数据

查询样例

分别测试多种查询，queryType表示查询类型，分别介绍如下

1-host-1-hr-raw: 查询1个小时数据，1个设备，查找所有的cpu.usage_user的值

select time, usage_user from cpu where (hostname = 'host_17') and time >=1514837782646 and time < 1514841382646 ;

1-host-1-hr: 查询1个小时数据，1个设备，查找每分钟cpu.usage_user的最大值

select time, max(usage_user) as max_usage_user from cpu where (hostname = 'host_17') and time >=1514837782646 and time < 1514841382646 sample by 1m

1-host-12-hr-raw: 查询12个小时数据，1个设备，查找所有的cpu.usage_user的值

select time, usage_user from cpu where (hostname = 'host_0') and time >=1514787382646 and time < 1514830582646;

1-host-12-hr: 查询12小时数据，1个设备，查找每分钟cpu.usage_user的最大值

select time, max(usage_user) as max_usage_user from cpu where (hostname = 'host_0') and time >=1514787382646 and time < 1514830582646 sample by 1m ;

1-host-latest: 随机查找1个设备的cpu.usage_user的最新值

select  time, latest(usage_user) as latest_usage_user from cpu where (hostname = 'host_50') sample by 0

8-host-latest: 随机查找8个设备的cpu.usage_user的最新值

select  time, latest(usage_user) as latest_usage_user from cpu where (hostname = 'host_64' or hostname = 'host_80' or hostname = 'host_21' or hostname = 'host_5' or hostname = 'host_79' or hostname = 'host_47' or hostname = 'host_25' or hostname = 'host_18') sample by 0

测试性能指标说明

介绍该测试中查询的性能指标。

queryType：参考上一节查询样例中的介绍
worker：查询的并发数量
qps：每秒执行完成的查询SQL数量
max_cpu: CPU的峰值百分比
max_mem: 内存的峰值百分比

测试结果

注意

下述查询的性能测试结果均是在时序引擎无其他工作负载的情况下单独测得。

图 1. 并发为200的情况下，各个规格的3种查询下的QPS

表 1. 集群1（4核16GB * 3节点）

queryType	worker	qps	max_cpu	max_mem
1-host-1-hr	16	1,420.96	86.95	48.08
1-host-1-hr	50	1,865.50	83.45	49.32
1-host-1-hr	100	1,887.00	81.71	48.95
1-host-1-hr	200	1,846.00	82.99	48.87
1-host-1-hr-raw	16	1,324.80	79.54	50.34
1-host-1-hr-raw	50	1,722.00	86.42	50.96
1-host-1-hr-raw	100	1,737.00	86.36	50.92
1-host-1-hr-raw	200	1,752.00	87.09	50.88
1-host-12-hr	16	497.44	86.77	48.81
1-host-12-hr	50	555.00	95.05	48.81
1-host-12-hr	100	571.00	94.97	48.90
1-host-12-hr	200	584.00	94.77	49.11
1-host-12-hr-raw	16	286.56	82.20	51.04
1-host-12-hr-raw	50	328.00	95.34	51.14
1-host-12-hr-raw	100	330.00	96.51	51.21
1-host-12-hr-raw	200	334.00	96.70	51.56
1-host-latest	16	1,025.12	81.79	49.34
1-host-latest	50	1,146.00	93.36	49.42
1-host-latest	100	1,144.00	92.41	49.36
1-host-latest	200	1,164.00	92.89	49.44
8-host-latest	16	175.20	96.65	49.64
8-host-latest	50	180.00	97.01	49.95
8-host-latest	100	181.00	96.59	50.05
8-host-latest	200	182.00	96.73	50.15

表 2. 集群2（8核32GB * 3节点）

queryType	worker	qps	max_cpu	max_mem
1-host-1-hr	16	2,426.56	79.45	31.83
1-host-1-hr	50	3,363.50	71.58	33.50
1-host-1-hr	100	3,530.00	73.80	35.44
1-host-1-hr	200	3,584.00	70.12	35.43
1-host-1-hr-raw	16	2,181.92	52.67	36.10
1-host-1-hr-raw	50	3,231.50	69.77	36.20
1-host-1-hr-raw	100	3,371.00	72.88	36.19
1-host-1-hr-raw	200	3,348.00	69.80	35.08
1-host-12-hr	16	877.44	59.57	35.66
1-host-12-hr	50	1,132.50	82.37	35.51
1-host-12-hr	100	1,145.00	84.10	35.55
1-host-12-hr	200	1,152.00	84.69	35.62
1-host-12-hr-raw	16	445.44	58.55	35.29
1-host-12-hr-raw	50	641.00	84.98	35.31
1-host-12-hr-raw	100	668.00	90.79	35.35
1-host-12-hr-raw	200	670.00	91.98	35.42
1-host-latest	16	1,785.44	51.20	35.80
1-host-latest	50	2,273.50	64.86	35.92
1-host-latest	100	2,280.00	64.97	35.82
1-host-latest	200	2,284.00	65.01	35.85
8-host-latest	16	439.04	85.04	35.98
8-host-latest	50	471.50	91.71	36.00
8-host-latest	100	472.00	92.42	36.08
8-host-latest	200	470.00	93.10	36.09

表 3. 集群3（16核64GB * 3节点）

queryType	worker	qps	max_cpu	max_mem
1-host-1-hr	16	3,287.84	49.77	25.83
1-host-1-hr	50	6,543.50	56.06	26.45
1-host-1-hr	100	7,713.00	59.81	26.48
1-host-1-hr	200	8,902.00	75.23	26.47
1-host-1-hr-raw	16	2,857.60	32.42	26.89
1-host-1-hr-raw	50	5,173.00	50.44	26.96
1-host-1-hr-raw	100	6,177.00	56.88	26.95
1-host-1-hr-raw	200	6,530.00	59.20	26.98
1-host-12-hr	16	1,148.48	38.69	26.52
1-host-12-hr	50	1,920.50	71.18	26.57
1-host-12-hr	100	2,181.00	82.79	26.62
1-host-12-hr	200	2,398.00	91.44	26.64
1-host-12-hr-raw	16	539.20	33.78	27.04
1-host-12-hr-raw	50	704.50	46.87	27.12
1-host-12-hr-raw	100	612.00	41.76	27.17
1-host-12-hr-raw	200	694.00	46.89	27.24
1-host-latest	16	2,141.60	40.24	26.69
1-host-latest	50	3,602.00	77.84	26.69
1-host-latest	100	4,098.00	91.87	26.72
1-host-latest	200	4,356.00	94.94	26.71
8-host-latest	16	541.28	81.87	26.77
8-host-latest	50	599.50	97.52	26.77
8-host-latest	100	648.00	97.85	26.88
8-host-latest	200	832.00	97.40	26.94

表 4. 集群4（32核128GB * 3节点）

queryType	worker	qps	max_cpu	max_mem
1-host-1-hr	16	3,543.04	24.25	28.33
1-host-1-hr	50	9,351.00	34.14	28.89
1-host-1-hr	100	12,567.00	46.42	28.92
1-host-1-hr	200	15,072.00	57.27	28.94
1-host-1-hr-raw	16	2,811.20	15.41	29.11
1-host-1-hr-raw	50	6,086.50	27.85	29.13
1-host-1-hr-raw	100	7,881.00	36.44	29.14
1-host-1-hr-raw	200	8,762.00	40.97	29.17
1-host-12-hr	16	1,394.24	18.85	28.91
1-host-12-hr	50	3,317.50	49.89	28.96
1-host-12-hr	100	4,160.00	67.13	28.96
1-host-12-hr	200	4,808.00	79.02	28.96
1-host-12-hr-raw	16	542.56	17.31	29.22
1-host-12-hr-raw	50	826.50	24.96	29.24
1-host-12-hr-raw	100	669.00	23.55	29.28
1-host-12-hr-raw	200	772.00	24.86	29.32
1-host-latest	16	2,600.00	16.04	28.97
1-host-latest	50	6,590.00	46.11	28.98
1-host-latest	100	8,516.00	65.60	28.99
1-host-latest	200	9,634.00	75.93	28.98
8-host-latest	16	949.12	55.91	29.03
8-host-latest	50	1,525.50	83.49	29.04
8-host-latest	100	1,710.00	93.16	29.06
8-host-latest	200	1,758.00	95.54	29.09