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_pages

int

25000

1

 

index_scan_oid_buffer_pages

float

4.0

0.05

16.0

sort_buffer_pages

int

16

1

 

temp_file_memory_size_in_pages

int

4

0

20

thread_stacksize

int

102400

65536

 

garbage_collection

bool

no

 

 

data_buffer_pages

data_buffer_pages is a parameter that configures the number of data pages to be cached in the memory by the Database Server. The greater the value of the data_buffer_pages 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_pages parameter in a way the required memory size is less than two-thirds of the system memory size. The default value is 25,000 pages.

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

index_scan_oid_buffer_pages is a parameter that configures the number of buffer pages where the OID list is to be temporarily saved during the index scan. The default value is 4. The minimum value is 0.05 and the maximum value is 16.0.

The size of the OID buffer tends to vary in proportion to the value of the index_scan_oid_buffer_pages 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_pages by considering these factors.

sort_buffer_pages

sort_buffer_pages is a parameter that configures the number of buffer pages to be used when sorting. The default value is 16 and the minimum value is 1. 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 that configures 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 that configures the stack size of a thread. The default value is 100*1024. The value of the thread_stacksize parameter must not exceed the stack size allowed by the operating system.

garbage_collection

garbage_collection is a parameter that specifies whether or not to collect garbage memory no longer used by the client. The default value is no.