Versions Compared

Version Old Version 1 New Version Current
Changes made by

Ryan Park (Unlicensed)

Grey Shim

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Section


Column
width50%

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



ui-text-box
Column
width45%

Index

Table of Contents
maxLevel3
indent20px
exclude목차
classtoc




DISK_COLUMNAR_INDEX_SHUTDOWN_BUILD_FINISH

...

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.  

Code Block
DISK_COLUMNAR_TABLESPACE_MEMORY_MAX_SIZE * (DISK_COLUMNAR_TABLESPACE_MEMORY_SLOWDOWN_HIGH_LIMIT_PCT / 100)

...