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:

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 pages. The minimum value is 1 and the maximum value is 16.

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.