Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Memory-Related Parameters

The following are parameters related to the memory used by the database server or client. The type and value range for each parameter are as follows:

Parameter Name

Type

Default Value

Min

Max

data_buffer_size

int

512M

16M

2G (32 bit)

index_scan_oid_buffer_size

int

64K

1K

256K

sort_buffer_size

int

2M

64K

 

temp_file_memory_size_in_pages

int

4

0

20

thread_stacksize

int

1048576

65536

 

data_buffer_size

data_buffer_size is a parameter used to configure the size of data buffer to be cached in the memory by the database server. You can set units as K, M, G and T, which stand for kilobytes (KB), megabytes(MB), gigabytes (GB), and terabytes (TB) respectively. If you omit the unit, bytes will be applied. The default value is 512M, and the minimum value is 16M. Note that the maximum value of 32-bit CUBRID is 2 GB.

The greater the value of the data_buffer_size parameter, the more data pages to be cached in the buffer, thus providing the advantage of decreased disk I/O cost. However, if this parameter is too large, the buffer pool can be swapped out by the operating system because the system memory is excessively occupied. It is recommended to configure the data_buffer_size parameter in a way the required memory size is less than two-thirds of the system memory size.

  • Required memory size = data buffer size (data_buffer_size)
index_scan_oid_buffer_size

index_scan_oid_buffer_size is a parameter used to configure the size of buffer where the OID list is to be temporarily stored during the index scan.  You can set units as K, M, G and T, which stand for KB (kilobytes), MB (megabytes), GB (gigabytes) and TB (terabytes), respectively. If you omit the unit, bytes will be applied. The default value is 64K, the minimum value is 1K, and the maximum value is 256K.

The size of the OID buffer tends to vary in proportion to the value of the index_scan_oid_buffer_size parameter and the page size set when the database was created. In addition, the bigger the size of such OID buffer, the more the index scan cost. You can set the value of the index_scan_oid_buffer_size by considering these factors.

sort_buffer_size

sort_buffer_size is a parameter used to configure the size of buffer to be used when sorting. You can set units as K, M, G and T, which stand for kilobytes (KB), megabytes (MB), gigabytes (GB), and terabytes (TB) respectively. If you omit the unit, bytes will be applied. The default value is 2M, and the minimum value is 64K.

The server assigns one sort buffer for each client request, and releases the assigned buffer memory when sorting is complete.

temp_file_memory_size_in_pages

temp_file_memory_size_in_pages is a parameter used to configure the number of buffer pages to cache temporary result of a query. The default value is 4 and the maximum value is 20.

  • Required memory size = the number of temporary memory buffer pages (temp_file_memory_size_in_pages * page size)
  • The number of temporary memory buffer pages = the value of the temp_file_memory_size_in_pages parameter
  • Page size = the value of the page size specified by the -s option of the cubrid createdb utility during the database creation
thread_stacksize

thread_stacksize is a parameter used to configure the stack size of a thread. The default value is 1048576 bytes. The value of the thread_stacksize parameter must not exceed the stack size allowed by the operating system.