This topic describes the query performance tests and provides the test results of different ApsaraDB for Lindorm (Lindorm) clusters.

Information of the test data

  • Data type: high-frequency and medium-frequency instantaneous data
  • Number of devices: 50,000
  • Query interval: 60 minutes
  • Total number of data points: 18,000,000
  • Total number of data values: 90,000,000

Test cases

SN Description Type
1 This test queries the data of multiple metrics collected from a device over a period of time. The volume of the queried data varies based on the query duration. single_raw_query
2 This test queries the latest data points in different time series. lastest
3 The aggregate query hits 360 data points that contain 1,800 data values within 60 minutes. aggregation
4 The downsampling query hits 360 data points that contain 1,800 data values within 60 minutes. downsample

Results

Table 1. Cluster 1 that contains two hosts with the specification of 4 CPU cores and 16 GB memory
Type Number of data values in a single query Number of queries Number of threads Response time (seconds) Maximum QPS Minimum QPS Average QPS Peak CPU utilization Peak memory usage
single_raw_query 1800 100000 10 72 453.04 1.00 138.16 84.5 33.7
single_raw_query 1800 100000 30 56 347.46 0.48 59.28 85.3 35
latest 12500 2000 4 111 8.97 0.72 4.66 84 38
latest 12500 2000 10 111 5.97 0.31 1.79 98.9 38.1
aggregation 1800 2000 10 719 1.01 0.08 0.28 99 38
downsample 1800 100000 10 78 467.44 0.55 128.60 71 38
downsample 1800 100000 30 68 392.55 0.34 48.87 82 38
Table 2. Cluster 2 that contains two hosts with the specification of 8 CPU cores and 32 GB memory
Type Number of data values in a single query Number of queries Number of threads Response time (seconds) Maximum QPS Minimum QPS Average QPS Peak CPU utilization Peak memory usage
single_raw_query 1800 100000 10 43 443.19 0.98 230.12 58.7 24.4
single_raw_query 1800 100000 30 32 372.11 0.67 104.74 78 25.3
latest 12500 2000 4 111 10.92 4.59 8.24 46 23.4
latest 12500 2000 10 111 7.42 0.62 4.35 96.8 23.4
aggregation 1800 2000 10 719 1.30 0.14 0.73 92.3 24
downsample 1800 100000 10 78 511 2.35 268.14 66.8 24
downsample 1800 100000 30 68 423.88 1.00 135.47 76.3 24
Table 3. Cluster 3 that contains two hosts with the specification of 16 CPU cores and 64 GB memory
Type Number of data values in a single query Number of queries Number of threads Response time (seconds) Maximum QPS Minimum QPS Average QPS Peak CPU utilization Peak memory usage
single_raw_query 1800 100000 10 34 477.92 1.57 297.54 41.3 18.75
single_raw_query 1800 100000 30 19 405.77 0.96 171.62 61.37 21.87
latest 12500 2000 4 64 9.79 0.59 7.75 23.7 25
latest 12500 2000 10 37.4 9.21 0.62 5.35 68.9 25
aggregation 1800 2000 10 214 1.26 0.21 0.93 52 25
downsample 1800 100000 10 27.8 549.05 2.84 364.56 35.3 25
downsample 1800 100000 30 16.1 463.27 1.89 209.73 64 24
Table 4. Cluster 4 that contains two hosts with the specification of 32 CPU cores and 64 GB memory
Type Number of data values in a single query Number of queries Number of threads Response time (seconds) Maximum QPS Minimum QPS Average QPS Peak CPU utilization Peak memory usage
single_raw_query 1800 100000 10 23 626.98 2.57 427.18 37 21.7
single_raw_query 1800 100000 30 11 583.47 1.87 289.13 55.4 22.6
latest 12500 2000 4 67 8.59 0.49 7.45 23.7 25.1
latest 12500 2000 10 40 8.21 0.32 5.35 23.9 25.2
aggregation 1800 2000 10 199 1.26 0.21 0.93 24 39.8
downsample 1800 100000 10 20 758.52 2.84 493.47 48.2 36.4
downsample 1800 100000 30 10 719.27 2.34 320.06 56.2 36.8
Figure 1. A higher cluster specification enables a higher QPS
qps