Subject: Re: sysctl & process limitations
To: Dan Nelson <firstname.lastname@example.org>
From: Randy Arabie <email@example.com>
Date: 02/02/2002 21:14:27
On Sat, 2 Feb 2002, Dan Nelson wrote:
> In the last episode (Feb 02), Randy Arabie said:
> > On Sat, 2 Feb 2002, Dan Nelson wrote:
> > mysql.
> > > > kern.maxfiles = 1772
> > >
> > > Raise that to (say) 5000. I assume netbsd has an /etc/sysctl.conf you
> > > can use, or you can do it manually via "sysctl -w kern.maxfiles=5000" .
> > How high can I go??
> > Tried 5000, and it still bombs at the same point. I set that at the
> > kernel level and the descriptors at the process level.
> The error might not actually be the kernel limit being reached. It
> might just be the per-process rlimit. What does "ulimit -n" print?
I don't think so. I raised the limit for mysqld descriptors to 5000.
# sysctl -w proc.220.rlimit.descriptors.hard=unlimited
# sysctl -w proc.220.rlimit.descriptors.soft=unlimited
The kernel maxfiles was already set to 5000. Those commands raised the
limit for process 220 (mysqld) to 5000. And, the load still fails with
GnuPG Key Info --
Fingerprint: 7E25 DFA2 EF72 9551 9C6C 8AA6 6E8C A0F5 7E33 D981
Key ID: 7C603AEF