|
|
|
FairCom DB allows extremely fine tuned cache and memory management beyond basic data cache and index cache pool sizes. This section covers options that control this granularity, including per user memory limits.
NONTRAN_DATA_FLUSH_SEC, NONTRAN_INDEX_FLUSH_SEC, TRAN_DATA_FLUSH_SEC, TRAN_INDEX_FLUSH_SEC
Configure a fixed rate of background flushing of updated data cache pages and index cache.
Specifies the number of index cache pages in each block list mutex.
Specifies the number of consecutive write operations performed while walking a list of buffer/cache pages before allowing other threads to acquire control of the list.
Specifies the size of memory blocks the FairCom Server uses in conjunction with data and index caches.
Permits the DAT_MEMORY and IDX_MEMORY values to be reinterpreted as megabytes instead of bytes.
Override the number of cache hit counters.
COMPATIBILITY MINIMUM_INDEX_BUFFERS
Restores behavior prior to V11 where the index cache memory was expanded past the specified limit to allow more concurrent index threads.
Specifies how many LRU lists are maintained for data cache pages. Note: The LRU algorithm is no longer used for the data cache.
Specifies the memory usage limit in bytes for a user without a User ID.
Specifies how many LRU lists are maintained for index cache pages.
Specifies the size of memory “chunks” the FairCom Server uses for various internal data structures.
Sets the maximum size for a single allocation using the FairCom DB memory suballocator.
Causes 8 times the specified number of lists to be created (8 for each internal memory suballocator).
When set to a non-zero value, N, causes records falling within N+2 cache pages to be stored entirely within the cache.
When set to Yes, suppresses calls to flush updated file system cache pages to disk for all non-TRNLOG data and index files.
Specifies files that are NOT be cached.
PRIME_CACHE and PRIME_INDEX (PRIME_CACHE, Prime Cache)
Specifies data and index files are added to the priming list and the number of bytes to be loaded into cache when physically opening the file.
Prime be the data cache from the specified file with the specified number of bytes by the specified index in forward or reverse order.
Specifies the size of sort buffers used by the FairCom Server.
Dedicates a specified amount of cache memory to a particular Extended data file.
Note: TOT_MEMORY is a deprecated keyword. FairCom does not recommend setting a total memory limit.
Specifies the total number of bytes the system will attempt to allocate for all uses (including index and data caches specified by the IDX_MEMORY and DAT_MEMORY keywords).
Sets the system default rule for FairCom Server action when a user exceeds his/her memory limit.
Specifies the system default limit of memory (in bytes) available to each user.
