Subject: Re: sysctl & process limitations
To: Manuel Bouyer <bouyer@antioche.eu.org>
From: Randy Arabie <rrarabie@arabie.org>
List: netbsd-help
Date: 02/02/2002 10:33:21
On Sat, 2 Feb 2002, Manuel Bouyer wrote:
> On Sat, Feb 02, 2002 at 08:23:49AM -0700, Randy Arabie wrote:
> > Environment: AlphaStation 255 w/ 64 MB RAM
> > NetBSD 1.5.2 - custom kernel
> > MySQL 3.23.47
> >
> > I'm trying to load data into tables in a mysql database. When I feed the
> > load script into the database it fails about 3/4 through. Error follows:
> >
> > <SNIP>
> > ERROR 1105 at line 11: File ./geeklog/userinfo.MYD not found (Errcode: 23)
> > </SNIP>
>
> 23 is "Too many open files in system"
>
> Maybe the whole system has too many open files ?
> The limit is kern.maxfiles and you can count them with 'fstat'.
The output of "# fstat | wc -l" is 213.
kern.maxfiles = 1772
> You may also want to ktrace mysqld while trying to load the
> database to get more details.
Tried this. I'm not much on analyzing a kernel trace, but I could see
from the trace that the file was opened. And, it appears that some of
the data was inserted. However, I can't check via the database. When I
log in and try "desc tablename" I get the same Errcode: 23 for the
corresponding mysql *.MYD file. This happens with a number of the tables
in the database.
--
Cheers!
Randy