Problem Statement: Problem Statement

Bufferpool Extending for Legacy Format

• The BUFFERPOOL configuration parameter’s legacy “buffers” format uses these attributes:
• buffers – starting number of buffers
• next_buffers – is the number of buffers to add when the buffer pool is extended and will be doubled every 4th extension *.
• max_extends – maximum number of extensions the buffer pool is allowed

Bufferpool Extending for Memory Format

• Bufferpool Extending for Memory Format

• The BUFFERPOOL configuration parameter’s new “Memory” format uses these attributes:
• memory – target amount of memory that a buffer pool can grow to. Values will be rounded up to 32mb alignments.
• start_memory – starting amount of memory
• Both memory and start_memory values can be expressed in a variety of units.
• For example:
• BUFFERPOOL size=4k,start_memory=32mb,memory=54gb
• BUFFERPOOL size=8k,start_memory=48000,memory=204mb