List:General Discussion« Previous MessageNext Message »
From:Randy Arabie Date:February 2 2002 5:33pm
Subject:Re: sysctl & process limitations
View as plain text  
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

Thread
sysctl & process limitationsRandy Arabie2 Feb
  • Re: sysctl & process limitationsManuel Bouyer2 Feb
    • Re: sysctl & process limitationsRandy Arabie2 Feb
      • Re: sysctl & process limitationsManuel Bouyer2 Feb
        • Re: sysctl & process limitationsRandy Arabie2 Feb
Re: sysctl & process limitationsRandy Arabie3 Feb
Re: sysctl & process limitationsDan Nelson3 Feb
  • Re: sysctl & process limitationsRandy Arabie3 Feb
    • Re: sysctl & process limitationsManuel Bouyer3 Feb
  • Re: sysctl & process limitationsWilliam R. Mussatto4 Feb
    • Re: sysctl & process limitationsRandy Arabie4 Feb
      • Re: sysctl & process limitationsWilliam R. Mussatto4 Feb
      • Re: sysctl & process limitationsManuel Bouyer4 Feb
    • Re: sysctl & process limitationsRandy Arabie4 Feb
      • Re: sysctl & process limitationsManuel Bouyer4 Feb
        • Re: sysctl & process limitationsRandy Arabie5 Feb
          • Re: sysctl & process limitationsRandy Arabie5 Feb
            • Re: sysctl & process limitationsManuel Bouyer5 Feb
              • Re: sysctl & process limitationsRandy Arabie5 Feb
                • Re: sysctl & process limitationsManuel Bouyer5 Feb
                  • Re: sysctl & process limitationsRandy Arabie5 Feb