Skip to content

Latest commit

 

History

History
62 lines (59 loc) · 4.72 KB

README.md

File metadata and controls

62 lines (59 loc) · 4.72 KB

Benchmark influxdb

This project is using iot-benchmark to test influxdb

1. environment

  1. influxdb: 1.8.6-1

2. config

Demo config

3. test result

----------------------Main Configurations----------------------
DB_SWITCH: InfluxDB
OPERATION_PROPORTION: 1:1:1:1:1:1:1:1:1:1:1
ENABLE_THRIFT_COMPRESSION: false
INSERT_DATATYPE_PROPORTION: 1:1:1:1:1:1
IS_CLIENT_BIND: true
CLIENT_NUMBER: 20
GROUP_NUMBER: 20
DEVICE_NUMBER: 20
SENSOR_NUMBER: 300
BATCH_SIZE_PER_WRITE: 10
LOOP: 1000
POINT_STEP: 5000
QUERY_INTERVAL: 250000
IS_OUT_OF_ORDER: false
OUT_OF_ORDER_MODE: 0
OUT_OF_ORDER_RATIO: 0.5
---------------------------------------------------------------
main measurements:
Create schema cost 0.02 second
Test elapsed time (not include schema creation): 23.81 second
----------------------------------------------------------Result Matrix----------------------------------------------------------
Operation           okOperation         okPoint             failOperation       failPoint           throughput(point/s) 
INGESTION           1824                5472000             0                   0                   229823.86           
PRECISE_POINT       1831                0                   0                   0                   0.00                
TIME_RANGE          1776                58026               0                   0                   2437.09             
VALUE_RANGE         1871                61099               0                   0                   2566.16             
AGG_RANGE           1734                1403                0                   0                   58.93               
AGG_VALUE           1769                1757                0                   0                   73.79               
AGG_RANGE_VALUE     1790                1478                0                   0                   62.08               
GROUP_BY            1912                21344               0                   0                   896.45              
LATEST_POINT        1841                1809                0                   0                   75.98               
RANGE_QUERY_DESC    1875                59689               0                   0                   2506.94             
VALUE_RANGE_QUERY_DESC1777                57475               0                   0                   2413.95             
---------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------Latency (ms) Matrix--------------------------------------------------------------------------
Operation           AVG         MIN         P10         P25         MEDIAN      P75         P90         P95         P99         P999        MAX         SLOWEST_THREAD
INGESTION           49.53       19.05       32.12       35.50       40.55       49.93       66.68       86.37       171.74      635.29      652.59      5115.04     
PRECISE_POINT       19.85       1.07        8.90        11.23       15.71       23.49       34.36       44.64       83.47       165.52      218.22      2427.25     
TIME_RANGE          20.41       1.74        9.73        11.85       15.97       23.60       34.78       45.81       93.63       138.73      179.34      2054.51     
VALUE_RANGE         21.50       1.84        9.76        12.26       16.32       24.95       36.28       49.40       102.84      209.85      297.07      2474.57     
AGG_RANGE           20.27       1.79        9.50        11.69       15.60       23.28       33.22       44.46       102.41      205.31      257.87      2408.83     
AGG_VALUE           21.15       2.50        10.14       12.32       16.24       23.97       36.39       45.56       84.75       278.99      347.58      2354.46     
AGG_RANGE_VALUE     20.80       1.59        9.47        11.75       16.12       23.72       34.43       46.94       100.46      181.82      270.81      2516.03     
GROUP_BY            20.54       1.39        9.82        11.80       15.84       23.26       35.74       47.68       88.66       141.62      170.65      2425.34     
LATEST_POINT        20.56       1.43        9.51        11.45       15.79       23.66       35.70       45.27       83.91       230.50      246.98      2528.49     
RANGE_QUERY_DESC    21.35       1.88        9.76        12.10       16.42       24.42       36.04       47.86       105.55      205.40      221.11      2627.79     
VALUE_RANGE_QUERY_DESC21.97       1.49        9.88        12.22       16.45       24.63       35.99       52.92       111.61      231.46      291.88      2506.34     
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------