[Spce-user] MySQL client ran out of memory

[Andrew Pogrebennyk]

Michael,

Actually there should be both. "ulimit -c unlimited" enables coredump
while "ulimit -l" sets how much shared memory the process can lock.

This is what it looks like in version 2.5:

if test "$DUMP_CORE" = "yes" ; then
    # set proper ulimit
    ulimit -c unlimited

    # directory for the core dump files
    # COREDIR=/home/corefiles
    # [ -d $COREDIR ] || mkdir $COREDIR
    # chmod 777 $COREDIR
    # echo "$COREDIR/core.$TYPE.%e.sig%s.%p" > /proc/sys/kernel/core_pattern
fi

# raise memlock limit, otherwise mysql client fails to initialize
ulimit -l 524288

On 04/13/2012 11:34 AM, Michael Schoepfer wrote:
> Hi,
> 
> this was set to:
> 
> ulimit -c unlimited
> 
> and i changed it to:
> 
> ulimit -l 524288
> 
> Now it seems to work. Thanks for that. But i didn't change the value
> originally?
> 
> Michael