Problem Statement: Problem Statement

Configuration parameter used to buffer pool size when automatic tuning is not possible.

• Configuration parameter used to buffer pool size when automatic tuning is not possible.

• When BUFFERPOOL:memory is set to auto, we set memory using AUTO_TUNE_SERVER_SIZE.

• Sets internal structures to assume that’s how much memory will get used.
• Therefore, it is possible to exceed these amounts.

• AUTO_TUNE_SERVER_SIZE [OFF | SMALL | MEDIUM | LARGE | XLARGE]

• OFF use 10% available memory
• SMALL use 10% available memory
• MEDIUM use 20% available memory
• LARGE use 33% available memory
• XLARGE use 50% available memory