查詢測試結果 - 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