Subject: Re: sysctl & process limitations
To: Randy Arabie <rrarabie@arabie.org>
From: Manuel Bouyer <bouyer@antioche.eu.org>
List: netbsd-help
Date: 02/02/2002 16:31:50
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'.
You may also want to ktrace mysqld while trying to load the
database to get more details.
--
Manuel Bouyer <bouyer@antioche.eu.org>
--