Configuration Parameters

Before starting to use IoTDB, you need to config the configuration files first. For your convenience, we have already set the default config in the files.

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

  • environment configuration file (iotdb-env.bat, 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(group_size_in_byte).
  • log configuration file (logback.xml)

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

Hot Modification Configuration

For the convenience of users, IoTDB server provides users with hot modification function, that is, modifying some configuration parameters in iotdb engine. Properties during the system operation and applying them to the system immediately. In the parameters described below, these parameters whose way of Effective is trigger support hot modification.

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

IoTDB Environment Configuration File

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
NameMAX_HEAP_SIZE
DescriptionThe maximum heap memory size that IoTDB can use at startup.
TypeString
DefaultOn Linux or MacOS, the default is one quarter of the memory. On Windows, the default value for 32-bit systems is 512M, and the default for 64-bit systems is 2G.
EffectiveAfter restarting system
  • 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

JMX Authorization

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

The user and passwords are in ${IOTDB_CONF}/conf/jmx.password.

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

IoTDB System Configuration File

File Layer

  • 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 filterConfig Manual - 图1 (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
  • enable_mem_control
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
Nameenable_partition
DescriptionWhether enable time partition for data, if disabled, all data belongs to partition 0 (it’s not recommend to open this function. If open, please calculate appropriate concurrent_writing_time_partition and wal_buffer_size)
TypeBool
Defaultfalse
EffectiveOnly allowed to be modified in first start up
  • 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
  • thrift_max_frame_size
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

Query

  • 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
Nameenable_seq_space_compaction
Descriptionenable the compaction between sequence files
TypeBoolean
Defaulttrue
EffectiveAfter restart system
  • 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

Automatic Schema Creation and Type Inference

  • 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

Trigger

  • 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
Namemax_pending_continuous_query_tasks
DescriptionMaximum number of continuous query tasks that can be pending for execution
TypeInt32
Default64
EffectiveAfter restarting system
  • continuous_query_min_every_interval
Namecontinuous_query_min_every_interval
DescriptionMinimum every interval to perform continuous query.
Typeduration
Default1s
EffectiveAfter restarting system

Enable GC log

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.

  1. nohup sbin/start-server.sh printgc >/dev/null 2>&1 &

Or

  1. sbin\start-server.bat printgc

GC log is stored at IOTDB_HOME/logs/gc.log. There will be at most 10 gc.log.* files and each one can reach to 10MB.