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
Errcode: 23.

-- 

Cheers!

Randy

================================================================
Randy Arabie
GnuPG Key Info -- 

 Fingerprint: 7E25 DFA2 EF72 9551 9C6C  8AA6 6E8C A0F5 7E33 D981
 Key ID: 7C603AEF
 http://www.arabie.org/keys/rrarabie.gnupg
================================================================