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.
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.
Override the number of cache hit counters.
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.
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.
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.