Bufferpool configuration

Posted in 2018

JOCHEN SCHNEIDER — Fri, 20 Jul 2018 12:52:54 — source: IIUG Forums & Mailing Lists

Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFERPOOL default,memory=10mb BUFFERPOOL size=2k,memory=4gb BUFFERPOOL size=8k,memory=36gb Now to my Questions: 1. I am not sure how many LRUs I should use. Is there any best-practice for this? 2. How many page cleaners I need? 3. How agressive LRU-Flushing over lru_max_dirt do you recommend to me? Is it a good configuration setting lru_max_dirt to 50, lru_min_dirt to 20 and AUTO_LRU_TUNING to 1? Thanks in advance.

↪ replying to JOCHEN SCHNEIDER

BENJAMIN THOMPSON — Mon, 23 Jul 2018 13:32:45 — source: IIUG Forums & Mailing Lists

Hi, a recent thread titled "BUFFERPOOL Configuration" dealt with most of these issues. Ben.