Very Computer

by **Gerhard Hofma** » Wed, 13 Feb 2002 01:47:53

Hi all,

I had some problems when starting Ingres on Suse Linux. It complained to be
unable to get enough shared memory.

Workaround in the moment is to put

echo 134217728 > /proc/sys/kernel/shmmax

at the beginning of the ingres startup script in /etc/init.d, this overrides
the kernel default.

Is there any reason why I should not use this method?
How can I configure the shared memory in the kernel? I tried "make xconfig"
command but this does not show an option to set the shared memory
parameters.

TIA
Gerhard Hofmann

by **Karl & Betty Schend** » Wed, 13 Feb 2002 03:26:55

Quote:>Hi all,

>I had some problems when starting Ingres on Suse Linux. It complained to be
>unable to get enough shared memory.

>Workaround in the moment is to put

> echo 134217728 > /proc/sys/kernel/shmmax

>at the beginning of the ingres startup script in /etc/init.d, this overrides
>the kernel default.

Not sure about changing the kernel default shm max, but you should check
out your locking parameters in CBF as well. It's pretty easy to get Ingres
configured for ridiculous numbers of locks and resources, and the lock/log
shared memory segment gets huge. I haven't seen many Ingres installations
that actually use more than say 50000 locks/resources.

--

K/B Computer Associates www.kbcomputer.com
Ingres, Unix, VMS Consulting and Training

Very Computer

Shared memory size on Linux

Shared memory size on Linux

Shared memory size on Linux