Property

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.

Index

• Index
• CPU_AFFINITY_BEGIN_ID
• CPU_AFFINITY_COUNT
• CPU_COUNT
• CPU_PARALLEL
• DBS_PATH
• DEFAULT_LSM_MAX_LEVEL
• DISK_BUFFER_COUNT
• DISK_COLUMNAR_INDEX_CHECKPOINT_INTERVAL_SEC
• DISK_COLUMNAR_INDEX_FDCACHE_COUNT
• DISK_COLUMNAR_INDEX_SHUTDOWN_BUILD_FINISH
• DISK_COLUMNAR_PAGE_CACHE_MAX_SIZE
• DISK_COLUMNAR_TABLE_CHECKPOINT_INTERVAL_SEC
• DISK_COLUMNAR_TABLE_COLUMN_FDCACHE_COUNT
• DISK_COLUMNAR_TABLE_COLUMN_MINMAX_CACHE_SIZE
• DISK_COLUMNAR_TABLE_COLUMN_PART_FLUSH_MODE
• DISK_COLUMNAR_TABLE_COLUMN_PART_IO_INTERVAL_MIN_SEC
• DISK_COLUMNAR_TABLE_TIME_INVERSION_MODE
• DISK_COLUMNAR_TABLESPACE_DWFILE_EXT_SIZE
• DISK_COLUMNAR_TABLESPACE_DWFILE_INT_SIZE
• DISK_COLUMNAR_TABLESPACE_MEMORY_EXT_SIZE
• DISK_COLUMNAR_TABLESPACE_MEMORY_MAX_SIZE
• DISK_COLUMNAR_TABLESPACE_MEMORY_MIN_SIZE
• DISK_COLUMNAR_TABLESPACE_MEMORY_SLOWDOWN_HIGH_LIMIT_PCT
• DISK_COLUMNAR_TABLESPACE_MEMORY_SLOWDOWN_MSEC
• DISK_IO_THREAD_COUNT
• DISK_TABLESPACE_DIRECT_IO_FSYNC
• DISK_TABLESPACE_DIRECT_IO_READ
• DISK_TABLESPACE_DIRECT_IO_WRITE
• DUMP_APPEND_ERROR
• DUMP_TRACE_INFO
• DURATION_BEGIN
• DURATION_GAP
• FEEDBACK_APPEND_ERROR
• GRANT_REMOTE_ACCESS
• HTTP_THREAD_COUNT
• INDEX_BUILD_MAX_ROW_COUNT_PER_THREAD
• INDEX_BUILD_THREAD_COUNT
• INDEX_FLUSH_MAX_REQUEST_COUNT_PER_INDEX
• INDEX_LEVEL_PARTITION_AGER_THREAD_COUNT
• INDEX_LEVEL_PARTITION_BUILD_MEMORY_HIGH_LIMIT_PCT
• INDEX_LEVEL_PARTITION_BUILD_THREAD_COUNT
• LOOKUP_APPEND_UPDATE_ON_DUPKEY
• MAX_QPX_MEM
• MEMORY_ROW_TEMP_TABLE_PAGESIZE
• PID_PATH
• PORT_NO
• PROCESS_MAX_SIZE
• QUERY_PARALLEL_FACTOR
• ROLLUP_FETCH_COUNT_LIMIT
• RS_CACHE_APPROXIMATE_RESULT_ENABLE
• RS_CACHE_ENABLE
• RS_CACHE_MAX_MEMORY_PER_QUERY
• RS_CACHE_MAX_MEMORY_SIZE
• RS_CACHE_MAX_RECORD_PER_QUERY
• RS_CACHE_TIME_BOUND_MSEC
• SHOW_HIDDEN_COLS
• TABLE_SCAN_DIRECTION
• TAGDATA_AUTO_META_INSERT
• TAG_TABLE_META_MAX_SIZE
• TAG_PARTITION_COUNT
• TAG_DATA_PART_SIZE
• TRACE_LOGFILE_COUNT
• TRACE_LOGFILE_PATH
• TRACE_LOGFILE_SIZE
• UNIX_PATH
• VOLATILE_TABLESPACE_MEMORY_MAX_SIZE

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.

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.

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.

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.

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.

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.

DISK_BUFFER_COUNT

Specifies the number of buffers for disk I/O.

DISK_COLUMNAR_INDEX_CHECKPOINT_INTERVAL_SEC

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

DISK_COLUMNAR_INDEX_FDCACHE_COUNT

Specifies the number of opened index partition file descriptors.

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.

DISK_COLUMNAR_PAGE_CACHE_MAX_SIZE

Sets the maximum size of the page cache.

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.

DISK_COLUMNAR_TABLE_COLUMN_FDCACHE_COUNT

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

DISK_COLUMNAR_TABLE_COLUMN_MINMAX_CACHE_SIZE

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

DISK_COLUMNAR_TABLE_COLUMN_PART_FLUSH_MODE

Sets the automatic flush interval for column partition files.

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.

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.

DISK_COLUMNAR_TABLESPACE_DWFILE_EXT_SIZE

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

DISK_COLUMNAR_TABLESPACE_DWFILE_INT_SIZE

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

DISK_COLUMNAR_TABLESPACE_MEMORY_EXT_SIZE

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

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.

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

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)

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.

DISK_IO_THREAD_COUNT

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

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,

DISK_TABLESPACE_DIRECT_IO_READ

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

DISK_TABLESPACE_DIRECT_IO_WRITE

Sets whether to use DIRECT I/O for data write operation. If DIRECT I/O is not supported on the file system (ex: ZFS), it must be set to 0.

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.

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.

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.

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.

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.

GRANT_REMOTE_ACCESS

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

HTTP_THREAD_COUNT

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

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.

INDEX_BUILD_THREAD_COUNT

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

INDEX_FLUSH_MAX_REQUEST_COUNT_PER_INDEX

Specifies the maximum number of flush requests per index.

INDEX_LEVEL_PARTITION_AGER_THREAD_COUNT

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

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.

INDEX_LEVEL_PARTITION_BUILD_THREAD_COUNT

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

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.

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.

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.

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.

PORT_NO

Specifies the TCP/IP port for the Machbase server process to communicate with the client. The Default is 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.

QUERY_PARALLEL_FACTOR

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

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.

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.

RS_CACHE_ENABLE

Determines whether to use the result cache.

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.

RS_CACHE_MAX_MEMORY_SIZE

Specifies the maximum memory usage of the result cache.

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.

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.

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.

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

TAGDATA_AUTO_META_INSERT

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.

TAG_TABLE_META_MAX_SIZE

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

TAG_PARTITION_COUNT

Specify the number of Key Value tables that consist the tag table.

TAG_DATA_PART_SIZE

Determines the partition size in tag data storage.

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.

TRACE_LOGFILE_PATH

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

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.

UNIX_PATH

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

VOLATILE_TABLESPACE_MEMORY_MAX_SIZE

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