This topic compares the test results of writing data to ApsaraDB for Lindorm (Lindorm) clusters of different specifications.

Write data

The following list describes the information about the data that is written to different Lindorm clusters:
  • Data type: high-frequency and medium-frequency instantaneous data
  • Number of analog devices: 50,000
  • Write interval: 60 minutes
  • Total number of data points: 18,000,000
  • Total number of data values: 90,000,000

Test results

  • Maximum number of concurrent write threads: 12, 24, or 48.
  • Number of data points in each batch of write operations: 200 or 400.
  • Unit: PPS. PPS refers to points per second. The values of tuples per second (TPS) are obtained by dividing the PPS values by 5.
Table 1. Cluster 1 that contains two 4-core 16 GB nodes
Data points per batch Number of threads Time consumption (seconds) TPS PPS Peak CPU utilization Peak memory usage
200 12 131 136989 684947 97.25% 28.75%
200 24 117 152996 764982 97.75% 31.25%
200 48 116 154547 772739 98.75% 34.3%
400 12 118 151669 758348 98% 30%
400 24 111 160839 804197 98.5% 31.25%
400 48 110 162382 811910 98.75% 31.8%
Table 2. Cluster 2 that contains two 8-core 32 GB nodes
Data points per batch Number of threads Time consumption (seconds) TPS PPS Peak CPU utilization Peak memory usage
200 12 76 236046 1180230 84.6% 21.5%
200 24 67 265947 1329739 92.5% 22.5%
200 48 62 286588 1432940 94% 22.8%
400 12 67 268260 1341303 88% 22.2%
400 24 61 291653 1458267 94.1% 22.5%
400 48 59 303528 1517642 95.4% 22.5%
Table 3. Cluster 3 that contains two 16-core 64 GB nodes
Data points per batch Number of threads Time consumption (seconds) TPS PPS Peak CPU utilization Peak memory usage
200 12 51 351376 1756881 70% 20.1%
200 24 43 415324 2076623 79% 20.7%
200 48 39 455979 2279896 79% 20.6%
400 12 45 392735 1963676 75% 20.5%
400 24 38 464813 2324068 84% 20.7%
400 48 37 476328 2381640 80% 20.5%
Table 4. Cluster 4 that contains two 32-core 64 GB nodes
Data points per batch Number of threads Time consumption (seconds) TPS PPS Peak CPU utilization Peak memory usage
200 12 39 460851 2304255 40% 20.3%
200 24 33 537757 2688787 36% 20.7%
200 48 33 538846 2694230 35% 20.6%
400 12 37 483576 2417884 28% 20.5%
400 24 33 539959 2699798 36% 20.7%
400 48 33 539856 2699283 30% 20.5%
Figure 1. TPS increases when the number of threads increases or the batch size increases
tps