Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Shared memoryThese topics describe the content of database server shared memory, the factors that determine the sizes of shared-memory areas, and how data moves into and out of shared memory.
Database server thread access to shared buffersDatabase server threads access shared buffers through a system of queues, using mutexes and locks to synchronize access and protect data.
FIFO/LRU queuesA buffer holds data for the purpose of caching. The database server uses the least-recently used (LRU) queues to replace the cached data. HCL OneDB™ also has a first-in first-out (FIFO) queue. When you set the number of LRU queues, you are actually setting the number of FIFO/LRU queues.

FIFO/LRU queues

A buffer holds data for the purpose of caching. The database server uses the least-recently used (LRU) queues to replace the cached data. HCL OneDB™ also has a first-in first-out (FIFO) queue. When you set the number of LRU queues, you are actually setting the number of FIFO/LRU queues.

Use the BUFFERPOOL configuration parameter to specify information about the buffer pool, including information about the number of LRU queues to create when database server shared memory is set up and values for lru_min_dirty and lru_max_dirty, which control how frequently the shared-memory buffers are flushed to disk.

To improve transaction throughput, increase the lru_min_dirty and lru_max_dirty values. However, do not change the gap between the lru_min_dirty and lru_max_dirty values. If the AUTO_LRU_TUNING configuration parameter is enabled, the values of the lru_max_dirty and lru_min_dirty fields are reset automatically as needed to improve performance.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.