Configuration Parameters

    In total, we provide users three kinds of configurations module:

    • environment configuration file (, iotdb-env.sh). The default configuration file for the environment configuration item. Users can configure the relevant system configuration items of JAVA-JVM in the file.

    • system configuration file (iotdb-engine.properties).

      • iotdb-engine.properties: The default configuration file for the IoTDB engine layer configuration item. Users can configure the IoTDB engine related parameters in the file, such as JDBC service listening port (rpc_port), unsequence data storage directory (unsequence_data_dir), etc. What’s more, Users can configure the information about the TsFile, such as the data size written to the disk per time().
    • log configuration file (logback.xml)

    The configuration files of the three configuration items are located in the IoTDB installation directory: $IOTDB_HOME/conf folder.

    Trigger way: The client sends the command to the IoTDB server. See Chapter 4 for the usage of the client.

    The environment configuration file is mainly used to configure the Java environment related parameters when IoTDB Server is running, such as JVM related configuration. This part of the configuration is passed to the JVM when the IoTDB Server starts. Users can view the contents of the environment configuration file by viewing the iotdb-env.sh (or iotdb-env.bat) file.

    The detail of each variables are as follows:

    • MAX_HEAP_SIZE
    • HEAP_NEWSIZE
    NameHEAP_NEWSIZE
    DescriptionThe minimum heap memory size that IoTDB can use at startup.
    TypeString
    DefaultOn Linux or MacOS, the default is min{cores * 100M, one quarter of MAX_HEAP_SIZE}. On Windows, the default value for 32-bit systems is 512M, and the default for 64-bit systems is 2G.
    EffectiveAfter restarting system
    • JMX_LOCAL
    NameJMX_LOCAL
    DescriptionJMX monitoring mode, configured as yes to allow only local monitoring, no to allow remote monitoring
    TypeEnum String: “true”, “false”
    Defaulttrue
    EffectiveAfter restarting system
    • JMX_PORT
    NameJMX_PORT
    DescriptionJMX listening port. Please confirm that the port is not a system reserved port and is not occupied
    TypeShort Int: [0,65535]
    Default31999
    EffectiveAfter restarting system
    • JMX_IP
    NameJMX_IP
    DescriptionJMX listening address. Only take effect if JMX_LOCAL=false. 0.0.0.0 is never allowed
    TypeString
    Default127.0.0.1
    EffectiveAfter restarting system

    We STRONGLY RECOMMENDED you CHANGE the PASSWORD for the JMX remote connection.

    The permission definitions are in ${IOTDB_CONF}/conf/jmx.access.

    • compressor
    Namecompressor
    DescriptionData compression method
    TypeEnum String : “UNCOMPRESSED”, “SNAPPY”
    DefaultUNCOMPRESSED
    EffectiveTrigger
    • group_size_in_byte
    Namegroup_size_in_byte
    DescriptionThe data size written to the disk per time
    TypeInt32
    Default134217728
    EffectiveTrigger
    • page_size_in_byte
    Namepage_size_in_byte
    DescriptionThe maximum size of a single page written in memory when each column in memory is written (in bytes)
    TypeInt32
    Default65536
    EffectiveTrigger
    • max_number_of_points_in_page
    Namemax_number_of_points_in_page
    DescriptionThe maximum number of data points (timestamps - valued groups) contained in a page
    TypeInt32
    Default1048576
    EffectiveTrigger
    • max_degree_of_index_node
    Namemax_degree_of_index_node
    DescriptionThe maximum degree of the metadata index tree (that is, the max number of each node’s children)
    TypeInt32
    Default256
    EffectiveOnly allowed to be modified in first start up
    • max_string_length
    Namemax_string_length
    DescriptionThe maximum length of a single string (number of character)
    TypeInt32
    Default128
    EffectiveTrigger
    • time_encoder
    Nametime_encoder
    DescriptionEncoding type of time column
    TypeEnum String: “TS_2DIFF”,“PLAIN”,“RLE”
    DefaultTS_2DIFF
    EffectiveTrigger
    • value_encoder
    Namevalue_encoder
    DescriptionEncoding type of value column
    TypeEnum String: “TS_2DIFF”,“PLAIN”,“RLE”
    DefaultPLAIN
    EffectiveTrigger
    • float_precision
    Namefloat_precision
    DescriptionThe precision of the floating point number.(The number of digits after the decimal point)
    TypeInt32
    DefaultThe default is 2 digits. Note: The 32-bit floating point number has a decimal precision of 7 bits, and the 64-bit floating point number has a decimal precision of 15 bits. If the setting is out of the range, it will have no practical significance.
    EffectiveTrigger
    • bloomFilterErrorRate
    NamebloomFilterErrorRate
    DescriptionThe false positive rate of bloom filter in each TsFile. Bloom filter checks whether a given time series is in the tsfile before loading metadata. This can improve the performance of loading metadata and skip the tsfile that doesn’t contain specified time series. If you want to learn more about its mechanism, you can refer to: wiki page of bloom filter (opens new window).
    Typefloat, (0, 1)
    Default0.05
    EffectiveAfter restarting system

    Engine Layer

    • rpc_address
    Namerpc_address
    DescriptionThe jdbc service listens on the address.
    TypeString
    Default“0.0.0.0”
    EffectiveAfter restarting system
    • rpc_port
    Namerpc_port
    DescriptionThe jdbc service listens on the port. Please confirm that the port is not a system reserved port and is not occupied.
    TypeShort Int : [0,65535]
    Default6667
    EffectiveAfter restarting system
    • rpc_thrift_compression_enable
    Namerpc_thrift_compression_enable
    DescriptionWhether enable thrift’s compression (using GZIP).
    TypeBoolean
    Defaultfalse
    EffectiveAfter restarting system
    • rpc_advanced_compression_enable
    Namerpc_advanced_compression_enable
    DescriptionWhether enable thrift’s advanced compression.
    TypeBoolean
    Defaultfalse
    EffectiveAfter restarting system
    • time_zone
    Nametime_zone
    DescriptionThe time zone in which the server is located, the default is Beijing time (+8)
    TypeTime Zone String
    Default+08:00
    EffectiveTrigger
    • base_dir
    Namebase_dir
    DescriptionThe IoTDB system folder. It is recommended to use an absolute path.
    TypeString
    Defaultdata
    EffectiveAfter restarting system
    • data_dirs
    Namedata_dirs
    DescriptionThe directories of data files. Multiple directories are separated by comma. The starting directory of the relative path is related to the operating system. It is recommended to use an absolute path. If the path does not exist, the system will automatically create it.
    TypeString[]
    Defaultdata/data
    EffectiveTrigger
    • wal_dir
    Namewal_dir
    DescriptionWrite Ahead Log storage path. It is recommended to use an absolute path.
    TypeString
    Defaultdata/wal
    EffectiveAfter restarting system
    • enable_wal
    Nameenable_wal
    DescriptionWhether to enable the pre-write log. The default value is true(enabled), and false means closed.
    TypeBool
    Defaulttrue
    EffectiveTrigger
    Nameenable_mem_control
    Descriptionenable memory control to avoid OOM
    TypeBool
    Defaulttrue
    EffectiveAfter restarting system
    • memtable_size_threshold
    Namememtable_size_threshold
    Descriptionmax memtable size
    TypeLong
    Default1073741824
    Effectivewhen enable_mem_control is false & After restarting system
    • enable_timed_flush_seq_memtable
    Nameenable_timed_flush_seq_memtable
    Descriptionwhether to enable timed flush sequence memtable
    TypeBool
    Defaultfalse
    EffectiveTrigger
    • seq_memtable_flush_interval_in_ms
    Nameseq_memtable_flush_interval_in_ms
    Descriptionif a memTable’s created time is older than current time minus this, the memtable will be flushed to disk
    TypeInt32
    Default3600000
    EffectiveTrigger
    • seq_memtable_flush_check_interval_in_ms
    Nameseq_memtable_flush_check_interval_in_ms
    Descriptionthe interval to check whether sequence memtables need flushing
    TypeInt32
    Default600000
    EffectiveTrigger
    • enable_timed_flush_unseq_memtable
    Nameenable_timed_flush_unseq_memtable
    Descriptionwhether to enable timed flush unsequence memtable
    TypeBool
    Defaultfalse
    EffectiveTrigger
    • unseq_memtable_flush_interval_in_ms
    Nameunseq_memtable_flush_interval_in_ms
    Descriptionif a memTable’s created time is older than current time minus this, the memtable will be flushed to disk
    TypeInt32
    Default3600000
    EffectiveTrigger
    • unseq_memtable_flush_check_interval_in_ms
    Nameunseq_memtable_flush_check_interval_in_ms
    Descriptionthe interval to check whether unsequence memtables need flushing
    TypeInt32
    Default600000
    EffectiveTrigger
    • enable_timed_close_tsfile
    Nameenable_timed_close_tsfile
    Descriptionwhether to timed close tsfiles
    TypeBool
    Defaultfalse
    EffectiveTrigger
    • close_tsfile_interval_after_flushing_in_ms
    Nameclose_tsfile_interval_after_flushing_in_ms
    Descriptionif a TsfileProcessor’s last working memtable flush time is older than current time minus this and its working memtable is null, the TsfileProcessor will be closed
    TypeInt32
    Default3600000
    EffectiveTrigger
    • close_tsfile_check_interval_in_ms
    Nameclose_tsfile_check_interval_in_ms
    Descriptionthe interval to check whether tsfiles need closing
    TypeInt32
    Default600000
    EffectiveTrigger
    • avg_series_point_number_threshold
    Nameavg_series_point_number_threshold
    Descriptionmax average number of point of each series in memtable
    TypeInt32
    Default10000
    EffectiveAfter restarting system
    • tsfile_size_threshold
    Nametsfile_size_threshold
    Descriptionmax tsfile size
    TypeLong
    Default536870912
    EffectiveAfter restarting system
    • enable_partition
    • partition_interval
    Namepartition_interval
    DescriptionTime range for dividing storage group, time series data will be divided into groups by this time range
    TypeInt64
    Default604800
    EffectiveOnly allowed to be modified in first start up
    • concurrent_writing_time_partition
    Nameconcurrent_writing_time_partition
    DescriptionThis config decides how many time partitions in a storage group can be inserted concurrently
    For example, your partitionInterval is 86400 and you want to insert data in 5 different days,
    TypeInt32
    Default1
    EffectiveAfter restarting system
    • multi_dir_strategy
    Namemulti_dir_strategy
    DescriptionIoTDB’s strategy for selecting directories for TsFile in tsfile_dir. You can use a simple class name or a full name of the class. The system provides the following three strategies:
    1. SequenceStrategy: IoTDB selects the directory from tsfile_dir in order, traverses all the directories in tsfile_dir in turn, and keeps counting;
    2. MaxDiskUsableSpaceFirstStrategy: IoTDB first selects the directory with the largest free disk space in tsfile_dir;
    3. MinFolderOccupiedSpaceFirstStrategy: IoTDB prefers the directory with the least space used in tsfile_dir;
    4. UserDfineStrategyPackage (user-defined policy)
    You can complete a user-defined policy in the following ways:
    1. Inherit the cn.edu.tsinghua.iotdb.conf.directories.strategy.DirectoryStrategy class and implement its own Strategy method;
    2. Fill in the configuration class with the full class name of the implemented class (package name plus class name, UserDfineStrategyPackage);
    3. Add the jar file to the project.
    TypeString
    DefaultMaxDiskUsableSpaceFirstStrategy
    EffectiveTrigger
    • tsfile_size_threshold
    Nametsfile_size_threshold
    DescriptionWhen a TsFile size on the disk exceeds this threshold, the TsFile is closed and open a new TsFile to accept data writes. The unit is byte and the default value is 2G.
    TypeInt64
    Default536870912
    EffectiveAfter restarting system
    • tag_attribute_total_size
    Nametag_attribute_total_size
    DescriptionThe maximum persistence size of tags and attributes of each time series.
    TypeInt32
    Default700
    EffectiveOnly allowed to be modified in first start up
    • tag_attribute_flush_interval
    Nametag_attribute_flush_interval
    Descriptioninterval num for tag and attribute records when force flushing to disk. When a certain amount of tag and attribute records is reached, they will be force flushed to disk. It is possible to lose at most tag_attribute_flush_interval records
    TypeInt32
    Default1000
    EffectiveOnly allowed to be modified in first start up
    • enable_partial_insert
    Nameenable_partial_insert
    DescriptionWhether continue to write other measurements if some measurements are failed in one insertion.
    TypeBool
    Defaulttrue
    EffectiveAfter restarting system
    • mtree_snapshot_interval
    Namemtree_snapshot_interval
    DescriptionThe least interval line numbers of mlog.txt when creating a checkpoint and saving snapshot of MTree. Unit: line numbers
    TypeInt32
    Default100000
    EffectiveAfter restarting system
    • mlog_buffer_size
    Namemlog_buffer_size
    Descriptionsize of log buffer in each metadata operation plan(in byte)
    TypeInt32
    Default1048576
    EffectiveAfter restart system
    • sync_mlog_period_in_ms
    Namesync_mlog_period_in_ms
    DescriptionThe cycle when metadata log is periodically forced to be written to disk(in milliseconds). If force_mlog_period_in_ms = 0 it means force metadata log to be written to disk after each refreshment
    TypeInt64
    Default100
    EffectiveAfter restart system
    • flush_wal_threshold
    Nameflush_wal_threshold
    DescriptionAfter the WAL reaches this value, it is flushed to disk, and it is possible to lose at most flush_wal_threshold operations.
    TypeInt32
    Default10000
    EffectiveTrigger
    • force_wal_period_in_ms
    Nameforce_wal_period_in_ms
    DescriptionThe period during which the log is periodically forced to flush to disk(in milliseconds)
    TypeInt32
    Default10
    EffectiveTrigger
    • fetch_size
    Namefetch_size
    DescriptionThe amount of data read each time in batch (the number of data strips, that is, the number of different timestamps.)
    TypeInt32
    Default10000
    EffectiveAfter restarting system
    • enable_stat_monitor
    Nameenable_stat_monitor
    DescriptionWhether to enable background statistics
    TypeBoolean
    Defaultfalse
    EffectiveAfter restarting system
    • concurrent_flush_thread
    Nameconcurrent_flush_thread
    DescriptionThe thread number used to perform the operation when IoTDB writes data in memory to disk. If the value is less than or equal to 0, then the number of CPU cores installed on the machine is used. The default is 0.
    TypeInt32
    Default0
    EffectiveAfter restarting system
    • concurrent_query_thread
    Nameconcurrent_query_thread
    DescriptionThe thread number which can concurrently execute query statement. When <= 0, use CPU core number. The default is 16.
    TypeInt32
    Default16
    EffectiveAfter restarting system
    • concurrent_sub_rawQuery_thread
    Nameconcurrent_sub_rawQuery_thread
    DescriptionThe thread number which can concurrently read data for raw data query. When <= 0, use CPU core number. The default is 8.
    TypeInt32
    Default8
    EffectiveAfter restarting system
    • tsfile_storage_fs
    Nametsfile_storage_fs
    DescriptionThe storage file system of Tsfile and related data files. Currently LOCAL file system and HDFS are supported.
    TypeString
    DefaultLOCAL
    EffectiveOnly allowed to be modified in first start up
    • core_site_path
    Namecore_site_path
    DescriptionAbsolute file path of core-site.xml if Tsfile and related data files are stored in HDFS.
    TypeString
    Default/etc/hadoop/conf/core-site.xml
    EffectiveAfter restarting system
    • hdfs_site_path
    Namehdfs_site_path
    DescriptionAbsolute file path of hdfs-site.xml if Tsfile and related data files are stored in HDFS.
    TypeString
    Default/etc/hadoop/conf/hdfs-site.xml
    EffectiveAfter restarting system
    • hdfs_ip
    Namehdfs_ip
    DescriptionIP of HDFS if Tsfile and related data files are stored in HDFS. If there are more than one hdfs_ip in configuration, Hadoop HA is used.
    TypeString
    Defaultlocalhost
    EffectiveAfter restarting system
    • hdfs_port
    Namehdfs_port
    DescriptionPort of HDFS if Tsfile and related data files are stored in HDFS
    TypeString
    Default9000
    EffectiveAfter restarting system
    • dfs_nameservices
    Namehdfs_nameservices
    DescriptionNameservices of HDFS HA if using Hadoop HA
    TypeString
    Defaulthdfsnamespace
    EffectiveAfter restarting system
    • dfs_ha_namenodes
    Namehdfs_ha_namenodes
    DescriptionNamenodes under DFS nameservices of HDFS HA if using Hadoop HA
    TypeString
    Defaultnn1,nn2
    EffectiveAfter restarting system
    • dfs_ha_automatic_failover_enabled
    Namedfs_ha_automatic_failover_enabled
    DescriptionWhether using automatic failover if using Hadoop HA
    TypeBoolean
    Defaulttrue
    EffectiveAfter restarting system
    • dfs_client_failover_proxy_provider
    Namedfs_client_failover_proxy_provider
    DescriptionProxy provider if using Hadoop HA and enabling automatic failover
    TypeString
    Defaultorg.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider
    EffectiveAfter restarting system
    • hdfs_use_kerberos
    Namehdfs_use_kerberos
    DescriptionWhether use kerberos to authenticate hdfs
    TypeString
    Defaultfalse
    EffectiveAfter restarting system
    • kerberos_keytab_file_path
    Namekerberos_keytab_file_path
    DescriptionFull path of kerberos keytab file
    TypeString
    Default/path
    EffectiveAfter restarting system
    • kerberos_principal
    Namekerberos_principal
    DescriptionKerberos pricipal
    TypeString
    Defaultyour principal
    EffectiveAfter restarting system
    • authorizer_provider_class
    Nameauthorizer_provider_class
    Descriptionthe class name of the authorization service
    TypeString
    Defaultorg.apache.iotdb.db.auth.authorizer.LocalFileAuthorizer
    EffectiveAfter restarting system
    Other available valuesorg.apache.iotdb.db.auth.authorizer.OpenIdAuthorizer
    • openID_url
    NameopenID_url
    Descriptionthe openID server if OpenIdAuthorizer is enabled
    TypeString (a http url)
    Defaultno
    EffectiveAfter restarting system
    Namethrift_max_frame_size
    Descriptionthe max bytes in a RPC request/response
    Typelong
    Default536870912 (should >= 512 1024 1024)
    EffectiveAfter restarting system

    InfluxDB-Protocol Adaptor

    • enable_influxdb_rpc_service
    Nameenable_influxdb_rpc_service
    DescriptionWhether to enable InfluxDB RPC service
    TypeBoolean
    Defaulttrue
    EffectiveAfter restarting system
    • influxdb_rpc_port
    Nameinfluxdb_rpc_port
    DescriptionThe port used by InfluxDB RPC service
    TypeINT32
    Default8086
    EffectiveAfter restarting system
    • default_fill_interval
    Namedefault_fill_interval
    DescriptionDefault interval of group by fill query in ms
    TypeInt32
    Default-1
    EffectiveAfter restarting system
    • group_by_fill_cache_size_in_mb
    Namegroup_by_fill_cache_size_in_mb
    DescriptionCache size of group by fill query
    TypeFloat
    Default1.0
    EffectiveAfter restarting system

    Compaction Config

    • enable_seq_space_compaction
    • enable_unseq_space_compaction
    Nameenable_unseq_space_compaction
    Descriptionenable the compaction between unsequence files
    TypeBoolean
    Defaultfalse
    EffectiveAfter restart system
    • enable_cross_space_compaction
    Nameenable_cross_space_compaction
    Descriptionenable the compaction between sequence files and unsequence files
    TypeBoolean
    Defaulttrue
    EffectiveAfter restart system
    • cross_compaction_strategy
    Namecross_compaction_strategy
    Descriptionstrategy of cross space compaction
    TypeString
    Defaultrewrite_compaction
    EffectiveAfter restart system
    • inner_compaction_strategy
    Nameinner_compaction_strategy
    Descriptionstrategy of inner space compaction
    TypeString
    Defaultsize_tiered_compaction
    EffectiveAfter restart system
    • compaction_priority
    Namecompaction_priority
    DescriptionPriority of compaction task. When it is BALANCE, system executes all types of compaction equally; when it is INNER_CROSS, system takes precedence over executing inner space compaction task; when it is CROSS_INNER, system takes precedence over executing cross space compaction task
    TypeString
    DefaultBALANCE
    EffectiveAfter restart system
    • target_compaction_file_size
    Nametarget_compaction_file_size
    DescriptionThe target file is in inner space compaction
    TypeInt64
    Default1073741824
    EffectiveAfter restart system
    • target_chunk_size
    Nametarget_chunk_size
    DescriptionThe target size of compacted chunk
    TypeInt64
    Default1048576
    EffectiveAfter restart system
    • target_chunk_point_num
    Nametarget_chunk_point_num
    DescriptionThe target point number of compacted chunk
    TypeInt32
    Default100000
    EffectiveAfter restart system
    • chunk_size_lower_bound_in_compaction
    Namechunk_size_lower_bound_in_compaction
    DescriptionA source chunk will be deserialized in compaction when its size is less than this value
    TypeInt64
    Default128
    EffectiveAfter restart system
    • chunk_point_num_lower_bound_in_compaction
    Namechunk_size_lower_bound_in_compaction
    DescriptionA source chunk will be deserialized in compaction when its point num is less than this value
    TypeInt32
    Default100
    EffectiveAfter restart system
    • max_inner_compaction_candidate_file_num
    Namemax_inner_compaction_candidate_file_num
    DescriptionThe max num of files encounter in inner space compaction
    TypeInt32
    Default30
    EffectiveAfter restart system
    • max_cross_compaction_file_num
    Namemax_cross_compaction_candidate_file_num
    DescriptionThe max num of files encounter in cross space compaction
    TypeInt32
    Default1000
    EffectiveAfter restart system
    • cross_compaction_file_selection_time_budget
    Namecross_compaction_file_selection_time_budget
    DescriptionTime budget for cross space compaction file selection
    TypeInt32
    Default30000
    EffectiveAfter restart system
    • cross_compaction_memory_budget
    Namecross_compaction_memory_budget
    DescriptionMemory budget for a cross space compaction
    TypeInt32
    Default2147483648
    EffectiveAfter restart system
    • concurrent_compaction_thread
    Nameconcurrent_compaction_thread
    Descriptionthread num to execute compaction
    TypeInt32
    Default10
    EffectiveAfter restart system
    • compaction_schedule_interval_in_ms
    Namecompaction_schedule_interval_in_ms
    Descriptioninterval of scheduling compaction
    TypeInt64
    Default60000
    EffectiveAfter restart system
    • compaction_submission_interval_in_ms
    Namecompaction_submission_interval_in_ms
    Descriptioninterval of submitting compaction task
    TypeInt64
    Default60000
    EffectiveAfter restart system
    • compaction_write_throughput_mb_per_sec
    Namecompaction_write_throughput_mb_per_sec
    DescriptionThe write rate of all compaction tasks in MB/s
    TypeInt32
    Default16
    EffectiveAfter restart system

    Insertion

    • insert_multi_tablet_enable_multithreading_column_threshold
    Nameinsert_multi_tablet_enable_multithreading_column_threshold
    DescriptionWhen the insert plan column count reaches the specified threshold, multi-threading is enabled.
    TypeInt32
    Default10
    EffectiveAfter restarting system
    • enable_auto_create_schema
    Nameenable_auto_create_schema
    Descriptionwhether auto create the time series when a non-existed time series data comes
    Typetrue or false
    Defaulttrue
    EffectiveAfter restarting system
    • default_storage_group_level
    Namedefault_storage_group_level
    DescriptionStorage group level when creating schema automatically is enabled. For example, if we receives a data point from root.sg0.d1.s2, we will set root.sg0 as the storage group if storage group level is 1. (root is level 0)
    Typeinteger
    Default1
    EffectiveAfter restarting system
    • boolean_string_infer_type
    Nameboolean_string_infer_type
    DescriptionTo which type the values “true” and “false” should be reslved
    TypeBOOLEAN or TEXT
    DefaultBOOLEAN
    EffectiveAfter restarting system
    • integer_string_infer_type
    Nameinteger_string_infer_type
    DescriptionTo which type an integer string like “67” in a query should be resolved
    TypeINT32, INT64, DOUBLE, FLOAT or TEXT
    DefaultDOUBLE
    EffectiveAfter restarting system
    • nan_string_infer_type
    Namenan_string_infer_type
    DescriptionTo which type the value NaN in a query should be resolved
    TypeDOUBLE, FLOAT or TEXT
    DefaultFLOAT
    EffectiveAfter restarting system
    • floating_string_infer_type
    Namefloating_string_infer_type
    DescriptionTo which type a floating number string like “6.7” in a query should be resolved
    TypeDOUBLE, FLOAT or TEXT
    DefaultFLOAT
    EffectiveAfter restarting system
    • enable_partition
    Nameenable_partition
    Descriptionwhether enable data partition. If disabled, all data belongs to partition 0
    TypeBOOLEAN
    Defaultfalse
    EffectiveOnly allowed to be modified in first start up
    • partition_interval
    Namepartition_interval
    Descriptiontime range for partitioning data inside each storage group, the unit is second
    TypeLONG
    Default604800
    EffectiveOnly allowed to be modified in first start up
    • virtual_storage_group_num
    Namevirtual_storage_group_num
    Descriptionnumber of virtual storage groups per user-defined storage group, a virtual storage group is the unit of parallelism in memory as all ingestions in one virtual storage group are serialized, recommended value is [virtual storage group number] = [CPU core number] / [user-defined storage group number]
    TypeLONG
    Default1
    EffectiveOnly allowed to be modified in first start up

    UDF

    • udf_initial_byte_array_length_for_memory_control
    Nameudf_initial_byte_array_length_for_memory_control
    DescriptionUsed to estimate the memory usage of text fields in a UDF query. It is recommended to set this value to be slightly larger than the average length of all texts.
    TypeInt32
    Default48
    EffectiveAfter restarting system
    • udf_memory_budget_in_mb
    Nameudf_memory_budget_in_mb
    DescriptionHow much memory may be used in ONE UDF query (in MB). The upper limit is 20% of allocated memory for read.
    TypeFloat
    Default30.0
    EffectiveAfter restarting system
    • udf_reader_transformer_collector_memory_proportion
    Nameudf_reader_transformer_collector_memory_proportion
    DescriptionUDF memory allocation ratio for reader, transformer and collector. The parameter form is a : b : c, where a, b, and c are integers.
    TypeString
    Default1:1:1
    EffectiveAfter restarting system
    • udf_root_dir
    Nameudf_root_dir
    DescriptionRoot directory of UDF
    TypeString
    Defaultext/udf(Windows:ext\udf)
    EffectiveAfter restarting system

    SELECT-INTO

    • select_into_insert_tablet_plan_row_limit
    Nameselect_into_insert_tablet_plan_row_limit
    DescriptionThe maximum number of rows that can be processed in insert-tablet-plan when executing select-into statements. When <= 0, use 10000.
    TypeInt32
    Default10000
    EffectiveTrigger
    • concurrent_window_evaluation_thread
    Nameconcurrent_window_evaluation_thread
    DescriptionHow many threads can be used for evaluating sliding windows. When <= 0, use CPU core number.
    TypeInt32
    DefaultThe number of CPU cores
    EffectiveAfter restarting system
    • max_pending_window_evaluation_tasks
    Namemax_pending_window_evaluation_tasks
    DescriptionMaximum number of window evaluation tasks that can be pending for execution. When <= 0, the value is 64 by default.
    TypeInt32
    Default64
    EffectiveAfter restarting system

    Continuous Query

    • continuous_query_execution_thread
    Namecontinuous_query_execution_thread
    DescriptionHow many threads will be set up to perform continuous queries
    TypeInt32
    Defaultmax(1, the / 2)
    EffectiveAfter restarting system
    • max_pending_continuous_query_tasks
    • continuous_query_min_every_interval
    Namecontinuous_query_min_every_interval
    DescriptionMinimum every interval to perform continuous query.
    Typeduration
    Default1s
    EffectiveAfter restarting system

    GC log is off by default. For performance tuning, you may want to collect the GC info.

    To enable GC log, just add a parameter “printgc” when you start the server.

    Or

    1. sbin\start-server.bat printgc