globals

Allocates shared memory to the database cache to create global buffers.

Synopsis

[config]   globals=0,b,c,d,e,f

Description

Six comma-separated values specify how many megabytes of shared memory to allocate for different sizes of global cache. From left to right, each value is the number of megabytes for global caches organized into:

no longer used, always 0
4–kilobyte blocks
8–kilobyte blocks
16–kilobyte blocks
32–kilobyte blocks
64–kilobyte blocks

So, for example, the following setting:

globals=0,0,16,0,0,0

Allocates 16 megabytes of buffers for 8–kilobyte database blocks.

Examples

Allocate 8mb of 4kb blocks and 32 mb of 8kb blocks:

globals=0,8,32,0,0,0

Allocate 32 mb of 8kb blocks. If a need for a 4kb block exists, then the system uses an 8kb block to store it since no 4kb blocks are configured:

globals=0,0,32,0,0,0

Let the system allocate memory itself by setting all parameters to 0.

globals=0,0,0,0,0,0

Range of Values

If all the values are 0, space is automatically allocated based on an estimate of the machine capability and shared memory resources. On a 64–bit system, there is a limit of 16 TB.

Management Portal

On the page System Administration > Configuration > System Configuration > Memory and Startup, select the option to Configure Memory Settings Manually. Enter number of megabytes for the amount of memory to allocate for each database block size.