Subject: FW: MySQL dies
To: NetBSD users \(E-Mail\) <NetBSD-users@netbsd.org>
From: =?iso-8859-1?Q?=22M=FCller=2C_Markus=22?= <Markus.Mueller@itworks-gmbh.de>
List: netbsd-users
Date: 01/14/2002 09:48:12
<forgot to post to the list...>
More dumb rookie questions...
> You might check resource limits for the mysqld process, using
> limit/ulimit/unlimit or whatever command your particular shell wants.
When I first set up the machine a colleague told me to put the line
--
ulimit -d 256
--
in the beginning of safe_mysqld.
In addition there is a ulimit fix for BSD systems in there.
It looks like this:
--
# Does this work on all systems?
if type ulimit | grep "shell builtin" > /dev/null
then
ulimit -n 256 > /dev/null 2>&1 # Fix for BSD and FreeBSD
systems
fi
--
Like said, I'm a rookie, so I'm not sure what ulimit does...
> You can also use "sysctl proc.<process-id-of-your-process>" to examine
> and change the limits.
# sysctl proc.24604
proc.24604.corename = %n.core
proc.24604.rlimit.cputime.soft = unlimited
proc.24604.rlimit.cputime.hard = unlimited
proc.24604.rlimit.filesize.soft = unlimited
proc.24604.rlimit.filesize.hard = unlimited
proc.24604.rlimit.datasize.soft = 262144000
proc.24604.rlimit.datasize.hard = 262144000
proc.24604.rlimit.stacksize.soft = 2097152
proc.24604.rlimit.stacksize.hard = 33554432
proc.24604.rlimit.coredumpsize.soft = unlimited
proc.24604.rlimit.coredumpsize.hard = unlimited
proc.24604.rlimit.memoryuse.soft = 520790016
proc.24604.rlimit.memoryuse.hard = 520790016
proc.24604.rlimit.memorylocked.soft = 173596672
proc.24604.rlimit.memorylocked.hard = 520790016
proc.24604.rlimit.maxproc.soft = 80
proc.24604.rlimit.maxproc.hard = 532
proc.24604.rlimit.descriptors.soft = 256
proc.24604.rlimit.descriptors.hard = 256
#
I think I understand the meaning of this output, but how could it help me
solve my problem?
thanx ...
Marc
------------------
...one of these days my boss is going to kick my sorry butt...
------------------