View Source

The properties are the settings used by the Machbase server and stored as key-value pairs in the $MACHBASE_HOME/conf/machbase.conf file.
These values are set when the Machbase server starts and are used continuously during runtime. To change this value for performance tuning, you must understand the meaning of these values and set them carefully.

CPU_AFFINITY_BEGIN_ID

This is the start number of the CPU used by the Machbase server. It is used to control the CPU usage of the Machbase server.

	Value
Minimum	0
Maximum	2 ^ 32 - 1
Default	0

CPU_AFFINITY_COUNT

This is the number of CPUs that the Machbase server will use. If set to 0, the Machbase server uses all CPUs.

	Value
Minimum	0
Maximum	2 ^ 32 - 1
Default	0

CPU_COUNT

Specifies the number of CPUs set in the system. Based on this value, the Machbase Thread determines the number. If set to 0, all CPUs in the system are used.

	Value
Minimum	0 (auto detect the physically installed count of CPU on the system)
Maximum	2^32 -1
Default	0

CPU_PARALLEL

Specifies the number of threads to spawn per CPU. If this value is 2 and the number of CPUs is 2, then two parallel threads are created per CPU, so the number of parallel processing threads is four. If this value is too large, memory can be consumed quickly.

	Value
Minimum	1
Maximum	2^32 -1
Default	1

DBS_PATH

Specifies the path where the basic data of the Machbase server will be stored. The default is "? Dbs", which means $MACHBASE_HOME/dbs.

	Value
Default	?/dbs

DEFAULT_LSM_MAX_LEVEL

Sets the base level of the LSM index. If you do not enter a MAX_LEVEL value when creating an index, this value applies.

	Value
Minimum	0
Maximum	3
Default	2

DISK_BUFFER_COUNT

Specifies the number of buffers for disk I/O.

	Value
Minimum	1
Maximum	4G (4 * 1024 * 1024 * 1024)
Default	16

DISK_COLUMNAR_INDEX_CHECKPOINT_INTERVAL_SEC

Sets the checkpoint interval for the index. If set too long, errors may occur during index creation.

	Value
Minimum	1 (sec)
Maximum	2^32 -1 (sec)
Default	120 (sec)

DISK_COLUMNAR_INDEX_FDCACHE_COUNT

Specifies the number of opened index partition file descriptors.

	Value
Minimum	0
Maximum	2^32 -1
Default	0

DISK_COLUMNAR_INDEX_SHUTDOWN_BUILD_FINISH

Sets whether or not to reflect index information on the disk when the Machbase server is shutdown. If this value is set to '1', all index information is reflected on the disk and ends, so waiting times may be long.

	Value
Minimum	0 (False)
Maximum	1 (True)
Default	0 (False)

DISK_COLUMNAR_PAGE_CACHE_MAX_SIZE

Sets the maximum size of the page cache.

	Value
Minimum	0
Maximum	2^64 - 1
Default	2 * 1024 * 1024 * 1024

DISK_COLUMNAR_TABLE_CHECKPOINT_INTERVAL_SEC

Sets checkpoint period of table data. If this value is too large, the recovery time will be longer at restart. If this value is too small, I/O will frequently occur and the overall performance may be degraded.

	Value
Minimum	1 (sec)
Maximum	2^32 -1 (sec)
Default	120 (sec)

DISK_COLUMNAR_TABLE_COLUMN_FDCACHE_COUNT

Specifies the maximum number of open file descriptors for column data in the table.

	Value
Minimum	0
Maximum	2^32 - 1
Default	0

DISK_COLUMNAR_TABLE_COLUMN_MINMAX_CACHE_SIZE

Sets the size of the default MINMAX cache set in the _ARRIVAL_TIME column.

	Value
Minimum	0
Maximum	2^64 - 1
Default	100 1024 1024

DISK_COLUMNAR_TABLE_COLUMN_PART_FLUSH_MODE

Sets the automatic flush interval for column partition files.

	Value
Minimum	0 (sec)
Maximum	2^32-1 (sec)
Default	60 (sec)

DISK_COLUMNAR_TABLE_COLUMN_PART_IO_INTERVAL_MIN_SEC

Sets the frequency with which the partition file is reflected on the disk. When more data is input than the number of partitions set, it is reflected on the disk regardless of this period.

	Value
Minimum	0 (sec)
Maximum	2^32-1 (sec)
Default	3 (sec)

DISK_COLUMNAR_TABLE_COLUMN_PARTITION_PRECREATE_COUNT

Defines the number of pre-generated column partition objects to be used for the table.

	Value
Minimum	1
Maximum	2^32-1
Default	3

DISK_COLUMNAR_TABLE_TIME_INVERSION_MODE

If set to 1, the input is allowed even if the value of the _ARRIVAL_TIME column is reduced. If it is 0, a value smaller than the Maximum of the _ARRIVAL_TIME column value is entered as an error.

	Value
Minimum	0 (False)
Maximum	1 (True)
Default	1 (True)

DISK_COLUMNAR_TABLESPACE_DWFILE_EXT_SIZE

Specifies the size at which the double write file used for recovery at startup increases at one time.

	Value
Minimum	1024 * 1024
Maximum	2^32 - 1
Default	1024 * 1024

DISK_COLUMNAR_TABLESPACE_DWFILE_INT_SIZE

Specifies the amount of space secured by the double write file when the file is created.

	Value
Minimum	1024 * 1024
Maximum	2^32 - 1
Default	2* 1024 * 1024

DISK_COLUMNAR_TABLESPACE_MEMORY_EXT_SIZE

Specifies the block size of the memory to reserve for the column partition.

	Value
Minimum	1024 * 1024
Maximum	2^64 - 1
Default	2* 1024 * 1024

DISK_COLUMNAR_TABLESPACE_MEMORY_MAX_SIZE

Specifies the maximum amount of memory allocated by the log table. If the server allocates more than this amount of memory, the memory allocation will wait until the memory usage drops below this value. It is recommended to set this value to 50 ~ 80% of physical memory.

	Value
Minimum	256 * 1024 * 1024
Maximum	2^64 - 1
Default	8 * 1024 * 1024 * 1024

DISK_COLUMNAR_TABLESPACE_MEMORY_MIN_SIZE

When the Machbase server starts, it pre-allocates memory by this value to prevent performance degradation due to memory allocation. Since this memory is used only as a data input buffer, it is recommended to use it only when memory is sufficient.

Table 24. Range of values

	Value
Minimum	1024 * 1024
Maximum	2^64 - 1
Default	100 * 1024 * 1024

DISK_COLUMNAR_TABLESPACE_MEMORY_SLOWDOWN_HIGH_LIMIT_PCT

Limits the performance when the memory usage exceeds the set value when data is input to the log table.

DISK_COLUMNAR_TABLESPACE_MEMORY_MAX_SIZE * (DISK_COLUMNAR_TABLESPACE_MEMORY_SLOWDOWN_HIGH_LIMIT_PCT / 100)

	Value
Minimum	0
Maximum	100
Default	80

DISK_COLUMNAR_TABLESPACE_MEMORY_SLOWDOWN_MSEC

Sets the next wait time for each record entry if the memory usage for the column data file exceeds the criterion.

	Value
Minimum	0 (msec)
Maximum	2^32 - 1 (msec)
Default	1 (msec)

DISK_IO_THREAD_COUNT

Sets the number of I/O threads that write data to disk.

	Value
Minimum	1
Maximum	2^32 -1
Default	3

DISK_TABLESPACE_DIRECT_IO_FSYNC

When running Direct I/O, fsync is unnecessary for data files. Disable fsync when using Direct I/O to improve data I/O performance (Set to 0).
Although fsync is unncessary, fsync must be set to perform in case of failure situations such as a power outage because in a normal situation there is no data loss,

	Value
Minimum	0
Maximum	1
Default	0

DISK_TABLESPACE_DIRECT_IO_READ

Sets whether to use DIRECT I/O for data read operation.

	Value
Minimum	0
Maximum	1
Default	0

DISK_TABLESPACE_DIRECT_IO_WRITE

Sets whether to use DIRECT I/O for data write operation.

	Value
Minimum	0
Maximum	1
Default	1

DISK_TAG_AUTO_RECLAIM

Determines whether to automatically secure unused space for TAG data.

If it is 1, which is the default value, the automatic space securing function works, and if it is 0, it does not work, and the user must directly execute the function using the ALTER TABLE statement.

	Value
최소값	0
최대값	1
기본값	1

DUMP_APPEND_ERROR

If this value is set to 1, the $MACHBASE_HOME/trc/machbase.trc file will record the error if the Append API fails.
In this situation, the append performance is very low, so it is recommended to use for testing purposes only.

If you want to check for errors in the user application, it is helpful to use the SQLAppendSetErrorCallback API.

	Value
Minimum	0
Maximum	1
Default	0

DUMP_TRACE_INFO

The server periodically records the DBMS system status information in the machbase.trc file at regular intervals, and sets this period.
If it is set to 0, it is not recorded.

	Value
Minimum	0 (sec)
Maximum	2^32 - 1 (sec)
Default	60 (sec)

DURATION_BEGIN

Sets the start time of the duration value that sets the default for the SELECT statements that do not specify the DURATION clause.
If set to 60, data will be retrieved 60 seconds before the current time.

The default is 0 to retrieve all data.

	Value
Minimum	0
Maximum	2^32 - 1
Default	0

DURATION_GAP

Sets the start time of the duration value that sets the default for the SELECT statements that do not specify the DURATION clause.

If set to 60, data will be retrieved for 60 seconds from the current time.
If the DURATION_BEGIN value is 60, the data is retrieved from 60 seconds before to 60 seconds from the current time.

The default is 0 to retrieve all data.

	Value
Minimum	0
Maximum	Non-zero
Default	0

FEEDBACK_APPEND_ERROR

Sets whether to send error data to the client when an Append API error occurs. If 0, no error data is sent to the client. If it is 1, error information is sent to the client.

	Value
Minimum	0
Maximum	1
Default	1

GRANT_REMOTE_ACCESS

Determines whether the database can be accessed remotely. If 0, the remote connection is blocked.

	Value
Minimum	0 (False)
Maximum	1 (True)
Default	1 (True)

HTTP_THREAD_COUNT

Set the number of threads to be used by the Machbase web server.

Value

Minimum

0

Maximum

1024

Default

2(Edge)

32(Fog/Cluster)

INDEX_BUILD_MAX_ROW_COUNT_PER_THREAD

If the number of records not indexed is greater than this value, the index build thread begins to add indexes.

	Value
Minimum	1
Maximum	2^32 - 1
Default	100000

INDEX_BUILD_THREAD_COUNT

Specifies the number of index creation threads. If set to 0, no index is created.

	Value
Minimum	0
Maximum	2 ^ 32 - 1
Default	3

INDEX_FLUSH_MAX_REQUEST_COUNT_PER_INDEX

Specifies the maximum number of flush requests per index.

	Value
Minimum	0
Maximum	2 ^ 32 - 1
Default	3

INDEX_LEVEL_PARTITION_AGER_THREAD_COUNT

Specifies the number of threads to delete index files that are not needed when creating LSM indexes.

	Value
Minimum	0
Maximum	1024
Default	1

INDEX_LEVEL_PARTITION_BUILD_MEMORY_HIGH_LIMIT_PCT

Sets the maximum memory usage for LSM index creation as a percent. This percent is set based on the maximum memory usage used by Machbase. If the memory usage exceeds the limit, the LSM partition merge is stopped.

	Value
Minimum	0
Maximum	100
Default	70

INDEX_LEVEL_PARTITION_BUILD_THREAD_COUNT

Determines the number of threads performing the merge operation for the creation of the LSM index.

	Value
Minimum	1
Maximum	1024
Default	3

LOOKUP_APPEND_UPDATE_ON_DUPKEY

When appending to the lookup table, it specifies how to handle duplicate primary keys.

0 : Append fail
1 : Update Row for the corresponding Primary Key.

	Value
Minimum	0
Maximum	1
Default	0

MAX_QPX_MEM

Sets the maximum amount of memory used by the query processor to perform the GROUP BY, DISTINCT, and ORDER BY clauses.
If one query uses memory with a larger value, the query is canceled. At this time, an error message is sent to the client, and the relevant content is recorded in the machbase.trc file.

	Value
Minimum	1024 * 1024
Maximum	2^64 - 1
Default	500 * 1024 * 1024

MEMORY_ROW_TEMP_TABLE_PAGESIZE

Sets the page size of the temporary tablespace for volatile tables and lookup tables. Because this page stores volatile tables and lookup table records, it should be larger than the maximum record size for volatile tables.
If you want to enter N records into the page, you should set this value to the maximum record size * N.

	Value
Minimum	8 * 1024
Maximum	2^32 - 1
Default	32 * 1024

PID_PATH

Specifies the location where the PID file of the Machbase server process is to be written. The default is "?/Conf", which means $MACHBASE_HOME/conf.

	Value
Default	?/conf

PID_PATH Value	PID File Location Path
Not Specified	$MACHBASE_HOME/conf/machbase.pid
?/test	$MACHBASE_HOME/test/machbase.pid
/tmp	/tmp/machbase.pid

PORT_NO

Specifies the TCP/IP port for the Machbase server process to communicate with the client. The Default is 5656.

	Value
Minimum	1024
Maximum	65535
Default	5656

PROCESS_MAX_SIZE

Specifies the maximum memory size used by machbased programs that are Machbase server processes. If you try to use more memory than the set limit, the server operates as follows to reduce the memory usage.

Stops data insert or treats it as an error
Decreased index creation speed

In this case, the performance is greatly degraded, so the cause of overuse of the memory must be found and solved.

	Value
Minimum	1024 * 1024 * 1024
Maximum	2^64 - 1
Default	8 * 1024 * 1024 * 1024

QUERY_PARALLEL_FACTOR

Specifies the number of execution threads of the parallel query executor.

	Value
Minimum	1
Maximum	100
Default	8

ROLLUP_FETCH_COUNT_LIMIT

Limits the amount of data the rollup thread can fetch at one time.

If set to 0, there is no limit.

	Value
Minimum	0
Maximum	2^32 - 1
Default	0

RS_CACHE_APPROXIMATE_RESULT_ENABLE

Determines whether to use the approximate result mode of the result cache. If this value is 1, the speculative value is obtained (very fast but the data may be inaccurate) when using the result cache, and if it is 0, the correct value is obtained.

	Value
Minimum	0 (False)
Maximum	1 (True)
Default	0 (False)

RS_CACHE_ENABLE

Determines whether to use the result cache.

	Value
Minimum	0 (False)
Maximum	1 (True)
Default	1 (True)

RS_CACHE_MAX_MEMORY_PER_QUERY

Sets the amount of memory the result cache will use. If the memory usage of a particular query result exceeds this value, the result of the query is not stored in the result cache.

	Value
Minimum	1024
Maximum	2^64 - 1
Default	16 * 1024 * 1024

RS_CACHE_MAX_MEMORY_SIZE

Specifies the maximum memory usage of the result cache.

	Value
Minimum	32 * 1024
Maximum	2^64 - 1
Default	512 * 1024 * 1024

RS_CACHE_MAX_RECORD_PER_QUERY

The maximum number of records to be stored in the result cache. If the number of records resulting from the query is greater than this value, the query result is not stored in the cache.

	Value
Minimum	1
Maximum	2^64 - 1
Default	10000

RS_CACHE_TIME_BOUND_MSEC

If a particular query is executed very quickly, it is better not to store it in the result cache because it can reduce memory usage.
This value determines how fast the query executed should not be stored in the cache. When set to 0, all query results are stored in the result cache.

	Value
Minimum	0 (msec)
Maximum	2^64 - 1 (msec)
Default	1000 (msec)

SHOW_HIDDEN_COLS

If set to the Default of 0, the _ARRIVAL_TIME column is not displayed by the SELECT * FROM query. If this value is set to 1, the corresponding column is displayed.

	Value
Minimum	0
Maximum	1
Default	0

TABLE_SCAN_DIRECTION

You can set the scan direction of the tag table. The property value is one of -1, 0, and 1, and the default value is 0.

-1 : Reverse scan
0 : Tag Table(Forward scan), Log Table(Reverse scan)
1 : Forward scan

	Value
Minimum	-1
Maximum	1
Default	0

TAGDATA_AUTO_META_INSERT

In 5.5 version, this property name was TAGDATA_AUTO_NAME_INSERT and supports only 0 or 1.
Below 5.7 version, default value is 1.

When entering data through APPEND / INSERT into the TAGDATA table, specify how to handle it if there is no matching TAG_NAME.

0: Input fails.
1: Input TAG_NAME value to input. If there are additional metadata columns, the values of all columns are entered as NULL.
2: Enter the additional metadata column value along with the TAG_NAME value you want to enter.
- This setting is valid only in APPEND. INSERT works like 1 because you cannot enter additional metadata column values.
- After this setting, the APPEND parameter must include the metadata column value in APPEND.

	Value
Minimum	0
Maximum	2
Default	1

TAG_TABLE_META_MAX_SIZE

When creating the TAGDATA table, set the maximum size of memory to store the metadata area.

	Value
Minimum	1024*1024
Maximum	2^32-1
Default	10010241024

TRACE_LOGFILE_COUNT

Specifies the maximum number of log trace files generated in TRACE_LOGFILE_PATH. To save disk space, delete the oldest log file if more than the maximum number of log files are created.

If more than the maximum number of log trace files is created and the oldest file is deleted, the name of the deleted file is saved as the newest log file.

	Value
Minimum	1
Maximum	2^32 - 1
Default	5

TRACE_LOGFILE_PATH

Set the path of the log trace files (machbase.trc, machadmin.trc, machcollector.trc, machsql.trc).
These files continuously record internal information at the start, end, and run of Machbase. The default ?/trc means $MACHBASE_HOME/trc.

	Value
Default	?/conf

TRACE_LOGFILE_PATH	trc direction location
Not Specified	$MACHBASE_HOME/trc/
?/test	$MACHBASE_HOME/test/
/tmp	/tmp/

TRACE_LOGFILE_SIZE

Sets the maximum size of the log trace file. If it is necessary to record more data than the size, a new log file is created.

	Value
Minimum	10 * 1024 * 1024
Maximum	2^32 - 1
Default	10 * 1024 * 1024

UNIX_PATH

Sets the path to the Unix domain socket file. The Default when not set by user is ?/conf/machbase-unix.

	Value
Default	?/conf/machbase-unix

VOLATILE_TABLESPACE_MEMORY_MAX_SIZE

Sets the total amount of memory usage for all volatile and lookup tables in the system.

	Value
Minimum	0
Maximum	2^64 - 1
Default	2 * 1024 * 1024 * 1024